mysqli准备查询无法正常工作

Question

I have this table:

CREATE TABLE `comment` (
  `id` int(11) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `comment` text,
  `article_id` int(11) unsigned NOT NULL DEFAULT '1',
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

This is in the table:

INSERT INTO `comment` VALUES (0,'Bernard','[e-mail]','This is a comment',1,'2014-07-22 17:34:24',0);

This php code spits out "foo" and nothing else:

<?php
error_reporting(E_ALL);
echo 'foo';
$db = new mysqli("localhost", 'root', '', 'ggs');
$query = $db->prepare("SELECT * FROM `comment` `c` WHERE `c`.`article_id` = ? AND `c`.`deleted` = 0 ORDER BY `c`.`date` ASC");
if (!$query) {
    echo $db->errno . " - Could not prepare SQL statement: " . $db->error;
} else {
    $query->bind_param('i', 1);
    $query->execute();
    echo json_encode($query->fetch());
}
echo 'bar';

Why is this failing, and why is it not throwing any errors?

Answer 1

As for the query, you should replace the first 0 a null to let the auto-increment work:

INSERT INTO `comment` VALUES (NULL,'Bernard','[e-mail]','This is a comment',1,'2014-07-22 17:34:24',0);