php pdo mysql query用法介绍

<?php
$dbconn = array(
 'dns'=>"mysql:host=localhost;dbname=gosoa",
 'dbuser'=>'root',
 'dbpwd'=>'123456'
);
try{
$db = new PDO($dbconn['dns'],$dbconn['dbuser'],$dbconn['dbpwd']);
$sql = "SELECT * FROM yourtable limit 0,2";
 $query = $db->query($sql);
 foreach($query as $rs)
 {
  print_r($rs);
 }
}catch(PDOException  $e)
{
 echo $e->getMessage();
}