一般情況下,查詢用到的次數遠比增删查要多。
那麼PDO如何查詢呢?直接上代碼!!!
$atime=5;
$pdo=new PDO('mysql:host=127.0.0.1;dbname=test1','root','root');
$stmt=$pdo->prepare('select * from test where atime>:atime');
$stmt->bindParam(':atime',$atime);
$stmt->execute();
$stmt=$pdo->prepare('select * from test where atime>:atime');
$stmt->bindParam(':atime',$atime);
$stmt->execute();
//查詢單條資料
$a=$stmt->fetch(PDO::FETCH_ASSOC);//關聯數組print_r($a);
$a=$stmt->fetch(PDO::FETCH_LAZY);//隻能用于單條查詢
//PDORow Object
//(
// [queryString] => select * from test where atime>:atime
// [id] => 7
// [aname] => aa
// [atime] => 23
//)
//查詢多條資料
$a=$stmt->fetchAll(PDO::FETCH_ASSOC);//關聯數組
//索引鍵
$a=$stmt->fetchAll(PDO::FETCH_NUM);//索引鍵
//既有索引鍵也有關聯鍵
$a=$stmt->fetchAll(PDO::FETCH_BOTH);//既有索引鍵也有關聯鍵
Array
//(
// [0] => Array
// (
// [id] => 7
// [0] => 7
// [aname] => aa
//[1] => aa
//[atime] => 23
// [2] => 23
// )
//
// [1] => Array
//(
// [id] => 8
// [0] => 8
// [aname] => aa
//[1] => aa
//[atime] => 23
// [2] => 23
// )
嗯,就是如此簡單~