php使用MySQL中的limit子句實現分頁的實例，原生分頁代碼，演示了從連接MYSQL、選擇數據庫到讀取記錄、計算分頁、輸出分頁按鈕的整個過程，若對PHP分頁不太懂的朋友，相信這個例子對你會有很大幫助。注：例子中的MYSQL用戶名和密碼以及表名和字段名請以你的為準，請修改這些信息后再測試。
001 | <html> |
002 | <head> |
003 | <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> |
004 | <title>應用limit子句實現分頁顯示</title> |
005 | <script> |
006 | //全選/取消全選 |
007 | function chek(){ |
008 | var leng = this.form1.chk.length; |
009 | if(leng==undefined){ |
010 | leng=1; |
011 | if(!form1.chk.checked) |
012 | document.form1.chk.checked=true; |
013 | else |
014 | document.form1.chk.checked=false; |
015 | }else{ |
016 | for( var i = 0; i < leng; i++) |
017 | { |
018 | if(!form1.chk[i].checked) |
019 | document.form1.chk[i].checked = true; |
020 | else |
021 | document.form1.chk[i].checked = false; |
022 | } |
023 | } |
024 | return false; |
025 | } |
026 | </script> |
027 | <?php |
028 | $conn = mysql_connect("localhost","root","pwd");//連接MYSQL |
029 | mysql_query("set names gb2312"); |
030 | mysql_select_db("db_softinfo"); //指定數據表 |
031 | ?> |
032 | </head> |
033 | <body> |
034 | <center> |
035 | <table width="798" border="0" cellpadding="0" cellspacing="0"> |
036 | <tr> |
037 | <td> |
038 | <table width="100%" height="38" border="0" cellpadding="0" cellspacing="0"> |
039 | <tr> |
040 | <td width="193" align="center" valign="middle"> |
041 | <b><?php echo date("Y-m-d")." ".date(l);?></b></td> |
042 | <td width="101" align="center" valign="middle"><a href="index.php?action=show" class="a">瀏覽目錄</a></td> |
043 | <td width="102" align="center" valign="middle"><a href="#">添加內容</a></td> |
044 | <td width="101" align="center" valign="middle"><a href="#">簡單查詢</a></td> |
045 | <td width="101" align="center" valign="middle"><a href="#">高級查詢</a></td> |
046 | <td width="101" align="center" valign="middle"><a href="#">分組統計</a></td> |
047 | <td width="99" align="center" valign="middle"><a href="#">退出系統</a></td> |
048 | </tr> |
049 | </table> |
050 | </td> |
051 | </tr> |
052 | </table> |
053 | <table width="799" height="300" border="0" cellpadding="0" cellspacing="0"> |
054 | <tr> |
055 | <td align="center" valign="middle"> |
056 | <?php |
057 | //瀏覽數據庫內容 |
058 | if (($action == null) or ($_GET[action] == "show")){ |
059 | ?> |
060 | <form name="form1" id="form1" method="post"> |
061 | <table width="90%" border="0" cellpadding="0" cellspacing="0"> |
062 | <tr> |
063 | <td height="25" width="5%" class="top"> </td> |
064 | <td width="5%" class="top">id</td> |
065 | <td width="30%" class="top">名稱</td> |
066 | <td width="10%" class="top">價格</td> |
067 | <td width="20%" class="top">時間</td> |
068 | <td width="10%" class="top">類別</td> |
069 | <td width="10%" class="top">操作</td> |
070 | </tr> |
071 | <?php |
072 | |
073 | $pagesize = 5 ; //每頁顯示記錄數 |
074 | $sqlstr = "select * from tb_mrbook order by id"; |
075 | $total = mysql_query($sqlstr,$conn); |
076 | $totalNum = mysql_num_rows($total); //總記錄數 |
077 | $pagecount = (int)(($totalNum - 1) / $pagesize) + 1;//總頁數 |
078 | (!$absolutepage)?($absolutepage = 1):$absolutepage; //當前顯示頁數 |
079 | ($absolutepage <= $pagecount)?$absolutepage:($absolutepage = $pagecount); |
080 | $f_pageNum = $pagesize * ($absolutepage - 1);//當前頁的第一條記錄 |
081 | $sqlstr1 = $sqlstr." limit ".$f_pageNum.",".$pagesize; |
082 | $result = mysql_query($sqlstr1,$conn); |
083 | while ($rows = mysql_fetch_row($result)){ |
084 | echo "<tr><td height='25' align='center' class='m_td'>"; |
085 | echo "<input type=checkbox name='chk[]' id='chk' value=".$rows[0].">"; |
086 | echo "</td>"; |
087 | for($i = 0; $i < count($rows); $i++){ |
088 | echo "<td height='25' align='center' class='m_td'>".$rows[$i]."</td>"; |
089 | } |
090 | echo "<td class='m_td'><a href='#'>修改</a>/<a href='#'>刪除</a></td>"; |
091 | echo "</tr>"; |
092 | } |
093 | ?> |
094 | <tr> |
095 | <td height="25" colspan="7" class="m_td" align="left"><a href="" onClick="return chek();">全部選擇/取消</a> |
096 | <input type="hidden" name="action" value="delall"><input type="submit" value="刪除選擇" onclick = 'return false'> |
097 | 共<?php echo $totalNum ?>本圖書,第<?php echo $absolutepage ?>頁/共<?php echo $pagecount ?>頁:<a href="?absolutepage=<?php echo ($absolutepage > 1)?($absolutepage - 1):1;s?>">上一頁</a> <a href="?absolutepage=<?php echo ($absolutepage < ($pagecount - 1))?($absolutepage+1):$pagecount;?>">下一頁</a></td> |
098 | </tr> |
099 | </table> |
100 | </form> |
101 | <?php } ?> |
102 | </td> |
103 | </tr> |
104 | </table> |
105 | </center> |
106 | </body> |
107 | </html> |
新聞熱點
疑難解答
圖片精選
