mysqli_query插入数据
//获得post的json数据,转换成对象。
$postJsonData = file_get_contents('php://input');
$postObjData = json_decode($postJsonData);
$account = $postObjData->account;
$password = $postObjData->password;
$email = $postObjData->email;
//连接数据库
try {
$connect = Db::getInstance()->connect();
} catch (\Throwable $th) {
return Response::show(403, '数据库连接失败');
}
//给数据表增加数据。
$sql = "INSERT INTO riye_user_login (user_account, user_password, user_email) VALUES ('{$account}','{$password}','{$email}')";
if (mysqli_query($connect, $sql)) {
//echo "新账号信息插入成功";
$success = 1;
} else {
//echo "Error: " . $sql . "<br>" . mysqli_error($connect);
$success = 0;
}
mysqli_close($connect);
我之前犯的一个错误是将
$sql = "INSERT INTO riye_user_login (user_account, user_password, user_email) VALUES ('{$account}','{$password}','{$email}')";
写成了
$sql = "INSERT INTO riye_user_login (user_account, user_password, user_email) VALUES ($account, $password, $email)";