2.PHP与PDO扩展,面向过程、对象

<?php$mysql_conf = array( ‘host‘ => ‘127.0.0.1:3306‘, ‘db‘ => ‘test‘, ‘db_user‘ => ‘root‘, ‘db_pwd‘ => ‘joshua317‘, );$pdo = new PDO("mysql:host=" . $mysql_conf[‘host‘] . ";dbname=" . $mysql_conf[‘db‘], $mysql_conf[‘db_user‘], $mysql_conf[‘db_pwd‘]);//创建一个pdo对象$pdo->exec("set names ‘utf8‘");$sql = "select * from user where name = ?";$stmt = $pdo->prepare($sql);$stmt->bindValue(1, ‘joshua‘, PDO::PARAM_STR);$rs = $stmt->execute();if ($rs) { // PDO::FETCH_ASSOC 关联数组形式 // PDO::FETCH_NUM 数字索引数组形式 while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { var_dump($row); }}$pdo = null;//关闭连接?>