php-quoted date正在减去

nfg76nw0  于 2021-06-21  发布在  Mysql
关注(0)|答案(0)|浏览(156)

我不知道为什么会发生这种情况,但我已经引用了我的日期,每次运行此代码时,它不是更新日期,而是减去日期并返回:
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)."'
                     ";

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题