嘿伙计们,以前可能有人问过这个问题,但我仍然被一个特殊的问题所困扰。
我正在尝试将日期时间对象传递给我的 mysql 插入语句,但它总是告诉我有一个错误,即:
无法将类的对象转换为字符串 日期时间
$dateToPass = new DateTime('now');
//$dateToPass = $dateToPass->format('d/m/Y H:i:s');
//inserting values
$SQLstring="Insert into Request(cust_num,request_date,item_description,item_weight,pickup_address,pickup_suburb,
pickup_date,pickup_time,receiver_name,delivery_address,delivery_suburb,delivery_state)
values(27,$dateToPass,'$desc',$weight,'$address','$suburb','$date', '$time','$rname','$raddress','$rsuburb','$rstate');";
$queryResult = @mysqli_query($DBConnect, $SQLstring)
Or die ("<p>Unable to query the Customer table.</p>"."<p>Error code ". mysqli_errno($DBConnect). ": ".mysqli_error($DBConnect)). "</p>";
其中$dateToPass是我的数据库中的日期时间字段。
希望你们能帮上忙。
您不能DateTime
对象作为字符串发送。尝试按照MySQL的期望将其转换为字符串。
$dateToPass = new DateTime('now');
$dateToPass = $dateToPass->format('Y-m-d H:i:s');
或者,如果您总是要存储当前日期时间,则可以使用 MySQL NOW((
$SQLstring="Insert into Request(cust_num,request_date,item_description,item_weight,pickup_address,pickup_suburb,
pickup_date,pickup_time, receiver_name,delivery_address,
delivery_suburb,delivery_state)
values(27,NOW(),'$desc',$weight,'$address','$suburb','$date', '$time','$rname','$raddress','$rsuburb','$rstate');";