$table_name="tiopic";//查取表名設定$perpage=5;//每頁顯示的資料個數//最大頁數和總記錄數$total_sql="select count(*) from $table_name";$total_result =mysqli_query($conn,$total_sql);$total_row=mysqli_fetch_row($total_result);$total = $total_row[0];//取得最大頁碼數$total_page = ceil($total/$perpage );//向上整數//臨界點$page=$page>$total_page ? $total_page:$page;//當下一頁數大於最大頁數時的情況//分頁設定初始化$start=($page- 1)*$perpage;$sql="select * from tiopic order by id desc limit $start ,$perpage";$que=mysqli_query($conn,$sql);$sum=mysqli_num_rows($que);
#