mysql - 运行 PDO mysql_num_rows 查询

Question

如何将其作为 PDO 查询运行？

$query = "SELECT * FROM `Top_10` WHERE DOB =". $date;
$result = mysql_query($query) or die(mysql_error());
if(mysql_num_rows($result)==0){
while blah blah
}

我可以运行 PDO 获取数组。但一旦我这样做，它就失败了。

有什么想法吗？

Answer 1

$dbh = new PDO("mysql:dbname=$dbname", $user, $password);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, FALSE);

try {
  $qry = $dbh->prepare('SELECT * FROM Top_10 WHERE DOB = ?');
  $qry->execute([$date]);

  while ($row = $qry->fetch()) {
    // blah blah blah
  }
}
catch (PDOException $e) {
  die($e->getMessage());
}