php脚本插入错误don't work - Error in php script insert don't work

Error in php script insert don't work

本文关键字：work don 脚本插入错误 php | 更新日期: 2023-09-27

我想在我的数据库中插入单词' urloon'…但是我得到了一个错误

会话已启动，我包含了header.php，其中会话已启动

<?php
// UREN
 $con=mysqli_connect("d","d","d","d");
 // Check connection
if (mysqli_connect_errno()) {
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
 // escape variables for security
  $omschrijving = mysqli_real_escape_string($con, $_POST['omschrijving']);
  $sql=("UPDATE users (uurloon,)
 VALUES ( '$omschrijving') WHERE user_id = ".$_SESSION['user_id']." ");
 if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
 }
  echo '<script type="text/javascript">
 <!--
window.location = "index.php"
//-->
 </script>';
mysqli_close($con);
?>

我收到以下错误:

Error: SQL语法错误;查看与MySQL服务器版本对应的手册，以便在第1行附近使用正确的语法'(uurloon，) VALUES ('haa'，) WHERE user_id =1'

谁能告诉我我做错了什么?

我看不出我的错误或什么

连接是好的，但插入…我遇到麻烦了

<?php
if($_POST) {
    if(!empty($_POST['omschrijving']) {
//uren 
$connect = mysqli_connect("d","d","d","d");
// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// escape variables for security
$omschrijving = mysqli_real_escape_string($connect, $_POST['omschrijving']);
$user_id = $_SESSION['user_id'];
$query = "UPDATE `users` SET `uurloon` = '$omschrijving' WHERE `user_id` = '$user_id'"; //Update query
$query = "INSERT INTO `users` (`uurloon`) VALUES ('$omschrijving')"; //Insert query
if (!mysqli_query($con, $sql)) {
    die('Error: ' . mysqli_error($con));
}
echo '<script type="text/javascript">
<!--
window.location = "index.php"
//-->
</script>';
}}
mysqli_close($con);
?>

Je haalt een update query en een insert query door elkaar。

您正在混合更新和插入查询。我猜你需要一个更新查询

更新探头说皇后区(试试):

$query = "UPDATE `users` SET `some_column` = 'uurloon' WHERE `user_id` = '$user_id'"; //This will put the word "uurloon" in some_column

转到另一个页面的更好方法:

header('Location: index.php');
exit();

在函数中:

to($url) {
   header('Location: ' . $url);
   exit();
}

$sql=("UPDATE users (uurloon,)去掉urloon后面的逗号

所以如果你想INSERT你需要使用INSERT命令，而不是UPDATE:

$sql=("INSERT INTO users (uurloon) VALUES ('$omschrijving')");