php简单分页（初级）

最新推荐文章于 2022-02-12 14:55:50 发布

JIANDANQINXINILOVEYO

最新推荐文章于 2022-02-12 14:55:50 发布

阅读量168

点赞数

分类专栏： php 文章标签： PHP MySQL SQL

本文链接：https://blog.csdn.net/JIANDANQINXINILOVEYO/article/details/83666188

版权

php 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

1、数据库,这里是MySQL数据库


 DROP TABLE IF EXISTS `paging`;
CREATE TABLE paging(
	`id` int(3) NOT NULL auto_increment,
	`name` varchar(30) ,
	primary KEY id(`id`)
);
INSERT INTO paging(name)  values('jack01');
INSERT INTO paging(name)  values('jack02');
INSERT INTO paging(name)  values('jack03');
INSERT INTO paging(name)  values('jack04');
INSERT INTO paging(name)  values('jack05');
INSERT INTO paging(name)  values('jack06');
INSERT INTO paging(name)  values('jack07');
INSERT INTO paging(name)  values('jack08');
INSERT INTO paging(name)  values('jack09');
INSERT INTO paging(name)  values('jack10');
INSERT INTO paging(name)  values('jack11');
INSERT INTO paging(name)  values('jack12');
INSERT INTO paging(name)  values('jack13');
INSERT INTO paging(name)  values('jack14');
INSERT INTO paging(name)  values('jack15');
INSERT INTO paging(name)  values('jack16');
INSERT INTO paging(name)  values('jack17');

2、连接数据库程序，conn_sql.php


<?php
$conn=mysql_connect("localhost","root","密码");
mysql_select_db("test");
?>

3、主代码 paging.php


<html>
	<head>
		<title>分页</title>
		<meta http-equiv="content-type" content="text/html;charset=gb2312">
	</head>
	<body>
<?php 
$pages=0;//总页数
$rows=5;//每一页要显示的条数
$page=1;//当前页
$allrows=0;//总条数
$starrow=0;//每一页的第一条在数据库中的条数
$endrow=0;//每一页的最后一条在数据库中的 总条数
$dbrows=0;//数据库中的总条数
?>
<?php
//连接数据库
require_once 'conn_mysql.php';
//查询
if(isset($_GET['page'])){
	$page=intval($_GET['page']);
}else{
	//设置为第一页
	$page=1;
}
$sqlCount=mysql_query("select count(*) from paging");
$dbrows=mysql_fetch_row($sqlCount);// 找出总条数
$dbrows=$dbrows[0];
if($dbrows%$rows!=0){
	$pages=intval($dbrows/$rows)+1;// 算出总页数
}else{
	$pages=intval($dbrows/$rows);// 算出总页数
}
$starrow=($page-1)*$rows;
$sql ="select id,name from paging limit $starrow,$rows";
$res=mysql_query($sql);

?>

			<table width="400" align="center" bordercolor='black' border='1' style="border-collapse: collapse">
				<tr>
					<th>id </th>
					<th>name </th>
				</tr>
<?php 
while($result = mysql_fetch_array($res)){
?>
				<tr>
					<td><?php echo $result["id"]?></td>
					<td><?php echo $result["name"]?></td>
				</tr>

<?php 
}
?>
			</table>
			<div align='center'>
<?php 
$i=1;
if($page>1){
	echo "<a href=mypaging.php?page=1>首页</a>   ";
	echo "<a href=mypaging.php?page=".($page-1).">上一页</a>   ";
}
for($i;$i<=$pages;$i++){
	echo "<a href=mypaging.php?page=".$i.">".$i."</a>    ";
}
if($page<$pages){
	echo "<a href=mypaging.php?page=".($page+1).">下一页</a>   ";	
	echo "<a href=mypaging.php?page=".$pages.">尾页</a>";
}
?>
	</div>
	<div align='center'> 
<?php 
	echo "<a font=15>共   ".$pages." 页，当前是第[ ".$page." ]页";
?>
	</div>		
	</body>
</html>