我想从用户那里获取一个值,然后更新表格中的开始时间和结束时间 . 但我得到这个错误:
致命错误:未捕获的异常'mysqli_sql_exception',消息表'fyp.biding'在C:\ xampp \ htdocs \ fyp \ profile \ user \ sadd_property_bidding.php中不存在:61堆栈跟踪:#0 C:\ xampp \ htdocs \ fyp \ profile \ user \ _dabd_property_bidding.php(61):mysqli_query(Object(mysqli),'UPDATE biding S ...')#1 抛出C:\ xampp \ htdocs \ fyp \ profile \第61行的user \ _ sadd_property_bidding.php
//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());
1 回答
这是一个明确的错误信息,你将得到 . 表
biding
没有't exists. It may be a typo in the name or your haven' t创建它 .