php pdo 遍历,如何在PHP中通过PDO遍历MySQL查询？

小编典典

这是一个使用PDO连接到数据库，告诉它引发Exception(而不是php错误)(将帮助您调试)以及使用参数化语句而不是将动态值替换为查询本身的示例(强烈建议)：

// $attrs is optional, this demonstrates using persistent connections,

// the equivalent of mysql_pconnect

$attrs = array(PDO::ATTR_PERSISTENT => true);

// connect to PDO

$pdo = new PDO("mysql:host=localhost;dbname=test", "user", "password", $attrs);

// the following tells PDO we want it to throw Exceptions for every error.

// this is far more useful than the default mode of throwing php errors

$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// prepare the statement. the place holders allow PDO to handle substituting

// the values, which also prevents SQL injection

$stmt = $pdo->prepare("SELECT * FROM product WHERE productTypeId=:productTypeId AND brand=:brand");

// bind the parameters

$stmt->bindValue(":productTypeId", 6);

$stmt->bindValue(":brand", "Slurm");

// initialise an array for the results

$products = array();

if ($stmt->execute()) {

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

$products[] = $row;

}

}

// set PDO to null in order to close the connection

$pdo = null;

2020-05-17