PHP查询选择一条记录

Question

我刚开始使用 PHP，我不明白为什么这一行行不通

$zoek = '2341 KG';
foreach ($pdo->query ("select * from blad1 where Postkode = $zoek" ) as $klant)

但是这个确实很完美

foreach ($pdo->query ("select * from blad1 where Postkode = '2341 KG' " ) as $klant)

Answer 1

您应该准备该查询。

$stmt = $pdo ->prepare("select * from blad1 where Postkode = ?" );
$stmt->execute(array($zoek)); 
$klant = $stmt->fetch();//no loop it's a single record!