这个 PDO 脚本似乎写得正确,但我一直收到语法错误,没有生成 json 数组。
$stmt = $pdo->query('SELECT `person`,
sum( `stat` = "Ready" ) as Num1
from `Table1`
WHERE `code` = :code AND
(`stat` = "Ready")
group by `person`
Order by `Num1` DESC ');
$stmt->execute([
'code' => $_POST['code']
]);
$row = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($row);
这是我收到的错误消息:
Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]
记住命名参数需要:
所以:code
而不是code
在执行数组键中
$stmt = $pdo->query('SELECT `person`,
sum( `stat` = "Ready" ) as Num1
from `Table1`
WHERE `code` = :code AND
(`stat` = "Ready")
group by `person`
Order by `Num1` DESC ');
$stmt->execute([
':code' => $_POST['code']
]);
$row = $stmt->fetchAll(PDO::FETCH_ASSOC);
对于 json 你可以
$myJson = json_encode($row);
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句