PHP PDO方式访问Mysql数据库实例

<?php
$dsn = 'mysql:dbname=menagerie;host=127.0.0.1;port=3306';
$user = 'root';
$password = '';
try {
$dbh = new PDO($dsn, $user, $password);
}
catch (PDOException $e) {
die('Connection failed: '.$e->getMessage( ));
}
print "Connected OK!"."<br/>";

$sql = "select * from pet where Owner = 'Gwen'";
foreach($array = $dbh->query($sql) as $row)
{
	echo $row['name']."<br/>";
	echo $row['owner']."<br/>";
	echo $row['sex']."<br/>";
}
?>

输出结果：

Connected OK!
Claws
Gwen
m
Chirpy
Gwen
f
Whistler
Gwen