<?php
$sql="SELECT * FROM books";
$result = $mysqli->query($sql);
//取得查詢結果的筆數
$num = $result->num_rows;

?>