<?php
$sql="SELECT * FROM books";
$result=$conn->query($sql);
//查詢結果一次給定陣列
$row = $result->fetchAll(PDO::FETCH_ASSOC);

?>

輸出文字欄位：$row = $result->fetchAll(PDO::FETCH_ASSOC); 
輸出數字欄位：$rowe = $result->fetchAll(PDO::FETCH_NUM); 
輸出Both：$row = $result->fetchAll();