这是说“错误:列'DeliveredDate'不能为空。”
$delivereddate = null;
$stmt = $connection->prepare("INSERT INTO orders (receiptid, date, cid, cardno, expirydate, expecteddate, delivereddate) VALUES (?,?,?,?,?,?,?)");
$stmt->bind_param("sssssss", $receiptid, $date, $cid, $cardno, $expirydate, $expecteddate, $delivereddate);
相关表为:
CREATE TABLE Orders(
ReceiptId char(30) not null,
Date date not null,
CId char(30) not null,
CardNo char(30) not null,
ExpiryDate date not null,
ExpectedDate date not null,
DeliveredDate date,
PRIMARY KEY(ReceiptId));
我尝试在mysql工作台中插入值,我可以这样做:
INSERT INTO orders VALUE
(1, '2012-12-10', 1, 1, '2014-2-3', '2012-12-23', null);
最佳答案
尝试这个
$delivereddate = '2014-11-26 10:40:35'; // some date
$stmt = $connection->prepare("INSERT INTO orders (receiptid, date, cid, cardno, expirydate, expecteddate, delivereddate) VALUES (?,?,?,?,?,?,?)");
$stmt->bind_param("sssssss", $receiptid, $date, $cid, $cardno, $expirydate, $expecteddate, $delivereddate);
我认为该错误是由于
$delivereddate = null;
评论错误...
关于php - MySQL/PHP的bind_param设置为空,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/27164321/