示例代码:
//连接数据库
$db = new mysqli("localhost", "username", "password", "database");
//验证连接是否成功,可选
if ($db->connect_error) {
die("连接失败: " . $conn->connect_error);
}
//用户输入
$name = $_POST['name']; //string类型
$age = $_POST['age']; //int类型
//prepared statement进行插入操作
$stmt = $db->prepare("INSERT INTO user (name, age) VALUES (?, ?)");
$stmt->bind_param("si", $name, $age); //参数类型和参数列表
$stmt->execute();
if ($stmt->affected_rows > 0) {
echo "插入成功!";
} else {
echo "插入失败!";
}
//关闭prepared statement和数据库连接
$stmt->close();
$db->close();