插入查询不插入错误消息

I can't get an INSERT query to INSERT in db. I am not getting any error message and was following a tutorial any help will be greatly appreciated.

我无法在db中获取INSERT查询到INSERT。我没有收到任何错误消息,并且正在关注教程,任何帮助将不胜感激。

$query = "INSERT INTO rooms (room_title,room_description,monthly_rate,prop_name,prop_description) VALUES ( ?, ?, ?, ?, ?)";

$stmt = mysqli_prepare($dbc,$query);
//$stmt = mysqli_query($dbc, $query);
if($stmt == false) {
  die("<pre>".mysqli_error($dbc).PHP_EOL.$query."</pre>");
}

mysqli_stmt_bind_param($stmt,"ssiss",$pn,$d,$p,$ppn,$ppd);
mysqli_stmt_execute($stmt);
//mysqli_stmt_close($stmt);
// Check the results...
if (mysqli_stmt_affected_rows($stmt) == 1)

  {

    echo'<p>The room has been added.</p>';                  
    // Clear $_POST:
    $_POST = array();

  }

mysqli_stmt_close($stmt);

} // End of $errors IF.
// End of the submission IF.

Because it does not echo "The room has been added" I suspect the problem is with the mysqli_stmt_affected_rows($stmt) == 1

因为它没有回应“房间已被添加”我怀疑问题是与mysqli_stmt_affected_rows($ stmt)== 1

1 个解决方案

#1

try this

    if ($stmt = mysqli_prepare($dbc, "INSERT INTO rooms (room_title,room_description,monthly_rate,prop_name,prop_description) VALUES ( ?, ?, ?, ?, ?)")) {

 mysqli_stmt_bind_param("ssiss",$pn,$d,$p,$ppn,$ppd);

mysqli_stmt_execute($stmt);

} printf("Error: %s.\n", mysqli_stmt_error($stmt));