<?php
$sql="SELECT * FROM books";
$result=mysqli_query($conn, $sql); 
//查詢結果一次給定陣列
$rowall = mysqli_fetch_all($result,MYSQLI_ASSOC);

?>

MYSQLI_ASSOC：文字欄位
MYSQLI_NUM：數字欄位
MYSQLI_BOTH：兩者都有