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());
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.