php实现网页流行分页

最新推荐文章于 2021-03-20 12:41:04 发布

qq_40910095

最新推荐文章于 2021-03-20 12:41:04 发布

阅读量199

点赞数

CC 4.0 BY-SA版权

文章标签： php+myslql实现分页

本文链接：https://blog.youkuaiyun.com/qq_40910095/article/details/97943562

<?php 
 header('content-type:text/html;charset=utf-8');
// 实现分页
$con = mysqli_connect('localhost','root','root','mydb1');
$sql = "select count(*) as total from emp";
$res = mysqli_query($con,$sql);
$row = mysqli_fetch_assoc($res);
$total =  $row['total'];
echo '<hr/>';
// 当前页
$curpage=isset($_GET['curpage'])?$_GET['curpage']:1;
// 设置每页显示条数
$pageSize = 2;
$totalPage = ceil($total/$pageSize); 
$curpage>$totalPage?$curpage=$totalPage:$curpage;
$curpage=$curpage<=0?1:$curpage;
// 计算每次查询的位置
$place = ($curpage-1) * $pageSize;
unset($sql,$res,$row);
$sql = "select * from emp limit $place,{$pageSize}";
$res = mysqli_query($con,$sql);
if ($curpage<=5) {
	$begin = 1;
	$end = $totalPage<10?$totalPage:10;
}else{
	$end = $curpage + 5>$totalPage?$totalPage:$curpage + 5;
	$begin = $end - 9<0?1:$end - 9;
}
$page="";
// 上一页
$prev = $curpage - 1 > 0?$curpage - 1:1;
$prev = "<a href='page.php?curpage=$prev'>上一页</a>";
// 下一页
$next = $curpage + 1 > $totalPage?$totalPage:$curpage + 1;
$next = "<a href='page.php?curpage=$next'>下一页</a>";
for ($i=$begin; $i <= $end; $i++) { 
	if ($curpage==$i) {
		$page .= "<a href='page.php?curpage=$i' style='color:red;'>$i </a>&nbsp;&nbsp;";
	}else{
		$page .= "<a href='page.php?curpage=$i'>$i </a>&nbsp;&nbsp;";
	}
	
}
$page = $prev.' '.$page.' '.$next;
?>
<html>
<head>
	<title></title>
</head>
<body>
	<table border="1px" cellpadding="0" cellspacing="0" width="1000px">
		
		<tr>
			<td>员工编号</td>
			<td>员工姓名</td>
			<td>员工岗位</td>
			<td>上司编号</td>
			<td>出生日期</td>
			<td>工资</td>
			<td>奖金</td>
			<td>部门编号</td>
		</tr>
	 	<?php while ($row = mysqli_fetch_assoc($res)){
		echo '<tr>';
			echo "<td> {$row['empno']}</td>";
			echo "<td> {$row['ename']	}</td>";
			echo "<td> {$row['job']		}</td>";
			echo "<td> {$row['mgr']		}</td>";
			echo "<td> {$row['hiredate']}</td>";
			echo "<td> {$row['sal'] 	}</td>";
			echo "<td> {$row['comm']    }</td>";
			echo "<td> {$row['deptno']  }</td>";
			
		echo '</tr>';
	}
		mysqli_close($con);
	 	?>
	</table>
	<?php  echo $page; ?>
</body>
</html>