我不知道为什么会发生这种情况,但我已经引用了我的日期,每次运行此代码时,它不是更新日期,而是减去日期并返回:
0000-00-00
这是我的密码:
$format_date = date("Y-m-d", strtotime($date));
$newinfo = "UPDATE
tickets
SET
`date` = '".mysqli_real_escape_string($connct,$format_date)."'
AND `boolean` = '".mysqli_real_escape_string($connct,$booleancheck)."'
WHERE
`id` = '".mysqli_real_escape_string($connct,$id)."'
";
$update_this = mysqli_query($connct, $newinfo);
编辑:
感谢@barmar,我曾经 ,
而不是 AND
而且成功了。
$newinfo = "UPDATE
tickets
SET
`date` = '".mysqli_real_escape_string($connct,$formatar_data)."',
`boolean` = '".mysqli_real_escape_string($connct,$booleancheck)."'
WHERE
`id` = '".mysqli_real_escape_string($connct,$id)."'
";
暂无答案!
目前还没有任何答案,快来回答吧!