呼喚遠(yuǎn)方
2019-11-18 14:15:19
我只需要這個(gè)不太了解的PHP錯(cuò)誤的幫助:致命錯(cuò)誤:在第13行的/web/stud/openup/inactivatesession.php中無(wú)法通過(guò)引用傳遞參數(shù)2<?phperror_reporting(E_ALL);include('connect.php');$createDate = mktime(0,0,0,09,05,date("Y"));$selectedDate = date('d-m-Y', ($createDate));$sql = "UPDATE Session SET Active = ? WHERE DATE_FORMAT(SessionDate,'%Y-%m-%d' ) <= ?"; $update = $mysqli->prepare($sql);$update->bind_param("is", 0, $selectedDate); //LINE 13$update->execute();?>這個(gè)錯(cuò)誤是什么意思?如何解決此錯(cuò)誤?
2 回答

白豬掌柜的
TA貢獻(xiàn)1893條經(jīng)驗(yàn) 獲得超10個(gè)贊
首先,DATE_FORMAT當(dāng)您要比較日期時(shí)不應(yīng)該使用,因?yàn)镈ATE_FORMAT將其更改為字符串不再是日期,
UPDATE Session
SET Active = ?
WHERE SessionDate <= ?
第二,首先將值存儲(chǔ)在變量中,然后將其傳遞給參數(shù)
$createDate = mktime(0,0,0,09,05,date("Y"));
$selectedDate = date('d-m-Y', ($createDate));
$active = 0;
$sql = "UPDATE Session SET Active = ? WHERE SessionDate <= ?";
$update = $mysqli->prepare($sql);
$update->bind_param("is", $active, $selectedDate);
$update->execute();
添加回答
舉報(bào)
0/150
提交
取消