php分页技术
php和MYSQL面向过程分页技术总结： <center> <a href="index.php">首页</a> <a href="liuyan.php">留言</a> <a href="./admin/login.php">后台登陆</a> <br /><marquee direction=left>给我留言吧 ^_^ ......</marquee> <hr width="100%" color="#666666" noshade="noshade" /> <?php include 'conn.php'; $perNumber=2; //每页显示的记录数 $page=isset($_GET['page'])?$_GET['page']:1; //获得当前的页面值 $count=mysql_query("select count(*) from tb_liuyan"); //获得记录总数 $rs=mysql_fetch_array($count); //获得记录总数 $totalNumber=$rs[0];//获得记录总数 $totalPage=ceil($totalNumber/$perNumber); //计算出总页数 $startCount=($page-1)*$perNumber; //分页开始,根据此方法计算出开始的记录 $result=mysql_query("select * from tb_liuyan limit $startCount,$perNumber"); //根据前面的计算出开始的记录和记录数 ?> <table width='200px' border='1px'> <tr> <th>id</th> <th>name</th> <th>liuyan</th> <th>time</th> </tr> <?php while($rows=mysql_fetch_assoc($result)){ echo "<tr>"; echo "<td>{$rows['id']}</td>"; echo "<td>{$rows['name']}</td>"; echo "<td>{$rows['liuyan']}</td>"; echo "<td>{$rows['time']}</td>"; echo "</tr>"; } ?> </table> <br /> <?php echo "<span>页次:". $page."/".$totalPage."页 记录:".$totalNumber."条</span> "; if($page!=1){ echo "<a href=index.php?page=1>首页</a> "; echo "<a href=index.php?page=".($page-1).">上一页</a>"; } if($page<$totalPage){ echo "<a href=index.php?page=".($page+1).">下一页</a> "; echo "<a href=index.php?page=".$totalPage.">尾页</a>"; } ?> </center>
