我有一个包含DATETIME列的数据库,我想使用JSON / PHP将当前日期插入其中,但是 我一直有这个错误: p>
第13行的/storage/h3/744/754744/public_html/SendBookingReq.php中无法将类DateTime的对象转换为字符串 strong>
这是我的php文件 p>
老实说,我看了很多关于我应该用datetime ex写的字母:“ s“for string但我找不到。 p>
div>
<?php
require(“password.php”);
$ connect = mysqli_connect(“localhost”,XXXX ,XXXX,XXXX);
$ driver_id = $ _POST [“driver_id”];
$ email = $ _POST [“email”];
$ duree = $ _POST [“duree”];
$ distance = $ _POST [“distance”];
$ response = array();
$ dt_obj = new DateTime($ response ['DateTime'],new
DateTimeZone('America / Chicago'));
$ dt_obj-> setTimezone(new DateTimeZone('Europe / Paris'));
$ dt_obj->格式('d-m-Y H:i:s');
echo $ dt_obj;
函数AddRequest(){
global $ connect,$ driver_id,$ email,$ duree,$ distance,$ dt_obj;
$ statement = mysqli_prepare($ connect,“INSERT INTO demande(driver_id,pass_id,duree,distance) ,send_moment)VALUES(?,(SELECT user_id FROM passager WHERE email =?),?,?,'$ dt_obj')“);
mysqli_stmt_bind_param($ statement,”isdis“,$ driver_id,$ email,$ duree, $ distance,$ dt_obj);
mysqli_stmt_execute($ statement);
\ mysqli_stmt_close($ statement);
}
$ response [“success”] = false;
AddRequest();
$ response [“success”] = true;
echo json_encode($ response);
?>
code> pre>