MySQLi查询失败,但在SQL shell中成功失败
问题描述:
我试图从我的OsTicket安装中拉出一些数据,但由于某种原因,第一个SQL查询无提示失败(行首:$openTickets
)。但是,查询在输入到MySQL shell时起作用。MySQLi查询失败,但在SQL shell中成功失败
<?php
define('INCLUDE_DIR','dumb hack');
require_once("./include/ost-config.php");
$mysqli = new mysqli(DBHOST, DBUSER, DBPASS, DBNAME);
if ($mysqli->connect_error) {
die("Couldn't Connect to MySQL Database.\nError (" . $mysqli->connect_errno . "): " . $mysqli->connect_error);
}
$openTickets = $mysqli->query("SELECT ticket_id, number, user_id FROM ost_ticket WHERE status='open'");
[...snip...]
?>
答
$openTickets = $mysqli->query("SELECT ticket_id, number, user_id FROM ost_ticket WHERE status='open'");
if ($openTickets === false) {
printf("Errorcode: %d\n", $mysqli->errno);
}
+0
'$ mysqli-> errno = 0'根据该行后面的变量转储。 – ellisgeek 2014-09-26 17:29:30
如果'$ openTickets'是返回false,使用'$ mysqli-> error'弄清楚是什么错误。 – castis 2014-09-25 22:16:49