数据库操作失败: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',)' at line 1
<?php
// 数据库连接参数
$servername = "xunlianshoutao.com";
$username = 'fjl';
$dbpassword = 'fjl111';
$dbname = 'xunlianshoutao';
$tablename = 'userinfo';
// 从 $_GET 获取用户输入的电话号码和密码
$phonenumber = $_GET['phonenumber'];
$password = $_GET['password'];
// 返回的数据对象
$res = array('error' => false);
// 创建数据库连接
$conn = mysqli_connect($servername, $username, $dbpassword, $dbname);
// 检查连接是否成功
if (!$conn) {
$res['error'] = true;
$res['message'] = "连接失败:".mysqli_connect_error();
} else {
// 构建 SQL 插入语句
$sql='INSERT INTO $tablename(phonenumber,passsword) VALUES ('.$phonenumber.','.$password.')';
//$sql = 'INSERT INTO userinfo (phonenumber, password) VALUES ('. mysqli_real_escape_string($conn, $phonenumber). ', '. mysqli_real_escape_string($conn, $password). ')';
// 执行 SQL 语句
$result = mysqli_query($conn, $sql);
// 检查查询结果
if (!$result) {
die("数据库操作失败: ". mysqli_error($conn));
}
// 执行 SQL 语句
if ($conn->query($sql) === TRUE) {
$res['error'] = false;
$res['message'] = "用户数据插入成功";
} else {
$res['error'] = true;
$res['message'] = "用户数据插入失败: ". $conn->error;
}
}
// 关闭数据库连接
$conn->close();
// 将结果以 JSON 格式输出
echo json_encode($res);
?>