Mysql/php bind_param设置为空

Question

它显示“错误:列'DeliveredDate‘不能为null。”

$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);

Answer 1

尝尝这个

$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;造成的

错误注释...

Answer 2

只需将表sql更改为允许DeliveryDate列的NULL即可。

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 null, 
PRIMARY KEY(ReceiptId));

剩下的应该可以用了。(假设您希望在该列中存储null )