PHP 简单分页查询 (笔记)

效果图：

                           

 

代码如下：

 

<?php include("conn.php"); $pagesize=5; //每页显示多少条数据 //..........取得当前url地址....... $url=$_SERVER["REQUEST_URI"]; $url=parse_url($url); $url=$url[path]; //................................ //......... 查询数据总条数............... $num_sql=mysql_query("select * from text"); $num=mysql_num_rows($num_sql); //....................................... if($_GET[page]) { $pageval=$_GET[page]; $page=($pageval-1)*$pagesize; $page.=','; } if($num > $pagesize){ if($pageval<=1)$pageval=1; echo "<a href="$url?page=1" mce_href="$url?page=1">首页</a>"." "; echo "<a href="$url?page=" mce_href="$url?page="".($pageval-1).">上一页 </a>"; $unm_url=ceil($num/$pagesize); //取得尾页条数 echo "共".$unm_url."页".$num."条数据 "; echo "<a href="$url?page=" mce_href="$url?page="".($pageval+1).">下一页 </a>"; echo "<a href="$url?page=" mce_href="$url?page="".$unm_url.">尾页 </a>"; //..获取跳转第几页.... echo "跳转到第 <select name='select' onchange='window.location=/"$url?page=/"+this.value'>"; for ($i = 1; $i <= $unm_url; $i++) { echo "<option value=".$i." >".$i."</option>"; } echo "</select> 页"; //................ } //...........判断最后页的下一页.......... if($pageval>$unm_url) { echo "</br>已经是最后一页,没有数据可显示";return; } //......................................... $sql="select * FROM `text`limit $page $pagesize"; $result=mysql_query($sql,$conn); ?> <table width="393" border="1" bordercolor="#CCCCCC"> <tr> <td width="63">id号</td> <td width="61">姓名</td> <td width="61">内容</td> <td width="87">日期</td> </tr> <?php //...................................................查询显示.................................. while($rows=mysql_fetch_row($result)) { ?> <tr> <form id="form1" name="form1" method="post" action="ss.php"> <td height="22"> <input name="id" type="text" size="10" style="border:0px;color:green" mce_style="border:0px;color:green" value=<?php echo $rows[0] ?>></td> <td><input name="name" type="text" size="10" style="border:0px;color:green" mce_style="border:0px;color:green" value=<?php echo $rows[1] ?>></td> <td><input name="content" type="text" size="10" style="border:0px;color:green" mce_style="border:0px;color:green" value=<?php echo $rows[2] ?>></td> <td><input name="date" type="text" size="10" style="border:0px;color:green" mce_style="border:0px;color:green" value=<?php echo $rows[3] ?>> </td> </form> </tr> <?php } ?></table>