致命错误：带消息的未捕获异常'mysqli_sql_exception'

Question

I want to get a value from the user and then update the start time and end time for biding in the table. But i am getting this error:

Fatal error: Uncaught exception 'mysqli_sql_exception' with message Table 'fyp.biding' doesn't exist' in

C:\xampp\htdocs\fyp\profile\user\sadd_property_bidding.php:61 Stack trace: #0

C:\xampp\htdocs\fyp\profile\user\sadd_property_bidding.php(61): mysqli_query(Object(mysqli), 'UPDATE biding S...') #1 {main} thrown in

C:\xampp\htdocs\fyp\profile\user\sadd_property_bidding.php on line 61

//Change the 25 to  however many minutes you want to countdown
$targetDate = strtotime('+3 days');
$actualDate = time();
echo $targetDate;
echo $actualDate;
$sql2 = "UPDATE biding SET start='$actualDate', end='$targetDate' WHERE      
id='$id'";
$result2 = mysqli_query($con, $sql2) or die(mysqli_error());

Answer 1

Fatal error: Uncaught exception 'mysqli_sql_exception' with message Table 'fyp.biding' doesn't exist' in

This is as clear an error message as you'll ever get. The table biding doesn't exists. It may be a typo in the name or your haven't created it.