PHP网站数据库插入操作指南

在PHP网站中，向数据库插入数据是最基础也是最重要的操作之一。以下是几种常见数据库的插入语句实现方法。

MySQL插入操作

使用MySQLi扩展

php

$servername = "localhost";$username = "your_username";$password = "your_password";$dbname = "your_database";// 创建连接$conn = new mysqli($servername, $username, $password, $dbname);// 检查连接if ($conn->connect_error) { die("连接失败: " . $conn->connect_error);}// 准备插入语句$sql = "INSERT INTO users (username, email, password) VALUES (?, ?, ?)";$stmt = $conn->prepare($sql);// 绑定参数$username = "john_doe";$email = "john@example.com";$password = password_hash("", PASSWORD_DEFAULT); // 密码哈希$stmt->bind_param("sss", $username, $email, $password);// 执行插入if ($stmt->execute()) { echo "新记录插入成功，ID: " . $conn->insert_id;} else { echo "错误: " . $sql . "
" . $conn->error;}// 关闭连接$stmt->close();$conn->close();?>

使用PDO（推荐）

php

$servername = "localhost";$username = "your_username";$password = "your_password";$dbname = "your_database";try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password