在mysql中,使用now()函数时如何绑定参数?
$stmt = $conn->prepare("INSERT INTO MyGuests (firstname, lastname, date) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $firstname, $lastname, now());
这行不通。
NOW()
不是查询的参数。就这样说吧:
$stmt = $conn->prepare("INSERT INTO MyGuests (firstname, lastname, date) VALUES (?, ?, NOW())");
$stmt->bind_param("sss", $firstname, $lastname);
NOW()
是一个SQL函数,而不是PHP函数。无需为本机 SQL 创建绑定参数,也不需要传入。
您可以执行以下操作:
$stmt = $conn->prepare("INSERT INTO MyGuests (firstname, lastname, date) VALUES (?, ?, NOW())");
$stmt->bind_param("sss", $firstname, $lastname);
为什么你不能直接这样称呼它
$stmt = $conn->prepare("INSERT INTO MyGuests (firstname, lastname, date) VALUES (?, ?, NOW())");