客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
|
代码不详细解说了，注释里有
1<?php
2 //page当前页，num每页的页数 3 $page=isset($_GET['page'])?intval($_GET['page']):1; 4 $num=5; 5 6 $conn = mysql_connect('127.0.0.1','root',''); 7 if (!$conn) { 8 die('Could not connect:'.mysql_error()); 9 } 10 mysql_select_db('shop'); 11 //获取记录总数 12 $total=mysql_num_rows(mysql_query("select * from user")); 13 //计算页数 14 $pagenum=ceil($total/$num); 15 //限制页数不能超出范围 16 If($page>$pagenum || $page == 0){ 17 Echo 'Error : Can Not Found The page.'; 18 Exit; 19 } 20 //语句“Select * from table limit 0,10”从table表提取十条信息，0为起点，10为提取的数目 21 //$offset为起点值，如当前页为第一页，每页5条，起点即为0，同理当前为第二页，起点将为5 22 $offset=($page-1)*$num; 23 $result=mysql_query("select * from user limit $offset,$num"); 24 While($it=mysql_fetch_array($result)){ 25 Echo 'id:'.$it['id'].' name:'.$it['name'].'<br />'; 26 } 27 //显示链接页面切换链接，当前页无链接 28 For($i=1;$i<=$pagenum;$i++){ 29 $show=($i!=$page)?"<a href='index.php?page=".$i."'>$i</a>":"<b>$i</b>"; 30 Echo $show." "; 31 } 32 echo $total.'条记录，每页5条，共'.$pagenum.'页'; 33 mysql_free_result($result); 34 mysql_close($conn); 35?> |
2022-08-17
2022-11-06
2022-07-29
2022-08-18
2022-07-30
TOTOLINK T6 V4.1.9cu.5179_B20201015 was discovered to contain a stack overflow v
xorrior/macOSTools: macOS Offensive Tools
caseypugh/minecraft: Some scripts to make your server more fun
Testinium/MobileDeviceInfo
xsfelvis/MaterialDesignStudy: A practice demo based on MaterialDesign
unit U_func; interface uses forms,SysUtils,ComCtrls,DBGrids,DB,Dialogs,Messages
tradingview/charting-library-tutorial: This tutorial explains step by step how t
kmycode/mastoom: Mastodon cross-platform client
重的笔顺怎么写?重的笔顺笔画顺序是什么?介绍重字的笔画顺序怎么写了解到好多的写字朋
Dynamical Systems with Applications using MATLAB® | SpringerLink
请发表评论