我试图弄清楚是什么问题,但是我转过身,我找不到一个有相同问题的人...
所以我有这个请求:
select killer as idPlayer FROM
(SELECT v.idPlayer as victim, v.name as vicName,k.idPlayer as killer, k.name as kilName, count(*) as number
FROM stats_players v
LEFT OUTER JOIN stats_events e ON v.idPlayer = e.idPlayerVictim
LEFT OUTER JOIN stats_players k ON e.idPlayer = k.idPlayer
WHERE e.type="PVP"
GROUP BY v.idPlayer,k.idPlayer
HAVING COUNT(*) > 3 ORDER BY COUNT(*) DESC) AS T
group by killer
order by count(*) DESC, sum(number) DESC
LIMIT 1
在phpmyadmin中正常工作,它返回了我1个记录,正是我想要的。
当我使用php呼叫(与PDO)的情况完全相同的请求时:
try {
$bdd = new PDO('mysql:host=' . SQL_HOST . ';dbname=' . SQL_DBASE, SQL_USER, SQL_PASS);
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$bdd->query('SET session wait_timeout=120');
$bdd->query('SET session interactive_timeout=120');
} catch (PDOException $e) {
die('Error during the connection to the MYSQL database : ' . $e->getMessage());
}
$title['request'] = 'select killer as idPlayer FROM
(SELECT v.idPlayer as victim, v.name as vicName,k.idPlayer as killer, k.name as kilName, count(*) as number
FROM stats_players v
LEFT OUTER JOIN stats_events e ON v.idPlayer = e.idPlayerVictim
LEFT OUTER JOIN stats_players k ON e.idPlayer = k.idPlayer
WHERE e.type="PVP"
GROUP BY v.idPlayer,k.idPlayer
HAVING COUNT(*) > 3 ORDER BY COUNT(*) DESC) AS T
group by killer
order by count(*) DESC, sum(number) DESC
LIMIT 1';
$playerList = request_db($bdd,$title['request']);
function request_db($bdd, $request, $txt = '') {
try {
if (isset($_GET['debug']) && $_GET['debug'] == 'request') {
echo $request . '<br>';
// logfile('requete : ' . $request);
}
$timeReqStart = microtime(true);
$result = $bdd->query($request);
$timeReqEnd = microtime(true);
$timeReq = $timeReqEnd - $timeReqStart;
if ($txt != '') {
echo $txt . '<br>';
}
if (preg_match("/^SELECT/", $request)) { /* Return the ID of the last request (INSERT ONLY) */
$res_tab = $result->fetchAll();
$result->closeCursor();
return $res_tab;
} else if (preg_match("/^INSERT/", $request) || preg_match("/^UPDATE/", $request)) { /* All that not insert return table */
echo 'Time Process request : ' . number_format($timeReq, 3) . ' sec <br>';
return $bdd->lastInsertId();
}
} catch (Exception $e) {
echo 'Error while contacting the database. Please contact the administrator. <br>';
logfile($request);
logfile('request error :' . $e->getMessage());
if (isset($_GET['debug'])) {
echo 'request : ' . $request . '<br>';
die('Error during the request to the MYSQL database : <br>' . $e->getMessage());
}
}
}
结果根本什么都没有返回我。
所以我试图在我的请求中删除子查询:
SELECT v.idPlayer as victim, v.name as vicName,k.idPlayer as killer, k.name as kilName, count(*) as number
FROM stats_players v
LEFT OUTER JOIN stats_events e ON v.idPlayer = e.idPlayerVictim
LEFT OUTER JOIN stats_players k ON e.idPlayer = k.idPlayer
WHERE e.type="PVP"
GROUP BY v.idPlayer,k.idPlayer
HAVING COUNT(*) > 3 ORDER BY COUNT(*) DESC
和两个动作(PhpMyAdmin或通过PHPCALL)都可以正常工作,在两种情况下,我都有很好的结果。
为什么php调用不想要子查询,而它在phpmyadmin上正常工作?:((我正在使用WAMP服务器)
谢谢,
好的,问题来自我请求开头的'select',在我的函数" request_db()"我的状况等待'/^select/',而我发送一个"选择"。这对情况很敏感,因此在减去不起作用的情况下:)
我将我的请求从"选择"更改为'select',现在它就像魅力一样。