<?php
try{
$pdo = new PDO("mysql:host=127.0.0.1;dbname=fd", "fd", "fd");
}catch(PDOException $e) {
die("数据库连接失败" . $e->getMessage());
}
$sql = "select * from user";
$stmt = $pdo->query($sql);
$list = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($list as $val) {
echo $val['id'] . "->" . $val['username'] . "<br>";
}
$stmt = null;
$pdo = null;
上面程序的简化版如下:
<?php
try{
$pdo = new PDO("mysql:host=127.0.0.1;dbname=fd", "fd", "fd");
}catch(PDOException $e) {
die("数据库连接失败" . $e->getMessage());
}
$sql = "select * from user";
foreach ($pdo->query($sql) as $val) {
echo $val['id'] . "->" . $val['username'] . "<br>";
}
$stmt = null;
$pdo = null;