$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);
