<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=utf-8"/>
<title>雇员信息列表</title>
</head>
<h1>雇员信息列表</h1>
<?php
$conn=mysql_connect("localhost","root","123456") or die(mysql_error());
mysql_query("set names utf8");
mysql_select_db("empmanage",$conn);
$pageSize=6;
$rowCount=0;
$pageNow=1;
if(isset($_GET['pageNow'])){
$pageNow=$_GET['pageNow'];
}
$pageCount=0;
$sql="select count(id) from emp";
$res1=mysql_query($sql);
if($row=mysql_fetch_row($res1)){
$rowCount=$row[0];
}
$pageCount=ceil($rowCount/$pageSize);
$sql="select * from emp limit ".($pageNow-1)*$pageSize.",$pageSize";
$res2=mysql_query($sql,$conn);
echo "<table border='1' bordercolor='green' cellspacing=0 width='700px'>";
echo "<tr><th>id</th><th>name</th><th>grade</th><th>email</th><th>salary</th><th>删除用户</th><th>修改用户</th></</tr>";
while($row=mysql_fetch_assoc($res2)){
echo "<tr><td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['grade']}</td><td>{$row['email']}</td><td>{$row['salary']}</td>"
."<td><a href=''>删除用户</a></td><td><a href=''>修改用户</a></td></tr>";
}
echo "</table>";
/* for($i=1;$i<=$pageCount;$i++){
echo "<a href='empList.php?pageNow=$i'>$i</a> ";
} */
echo "<a href='empList.php?pageNow=1'>首页</a> ";
if($pageNow>1){
$prePage=$pageNow-1;
echo "<a href='empList.php?pageNow=$prePage'>上一页</a> ";
}
if($pageNow<$pageCount){
$nextPage=$pageNow+1;
echo "<a href='empList.php?pageNow=$nextPage'>下一页</a> ";
}
echo "<a href='empList.php?pageNow=$pageCount'>尾页</a> ";
$i=6;
$k=ceil($pageNow/$i);
$n_1=$i*($k-2)+1;
$n_2=$i*$k+1;
for($m=1;$m<=$i;$m++){
$k_{$m}=$i*($k-1)+$m;
//echo $k_{$m};
}
if($k>1){
echo "<a style='text-decoration: none' href='empList.php?pageNow=$n_1'><<</a>";
}
if($k<ceil($pageCount/$i)){
for($m=1;$m<=$i;$m++){
echo "<a style='text-decoration: none' href='empList.php?pageNow={$k_{$m}}'>[{$k_{$m}}]</a> ";
}
echo "<a style='text-decoration: none' href='empList.php?pageNow=$n_2'>>></a>";
}elseif($k==ceil($pageCount/$i)){
for($m=1;$m<=$i&&$k_{$m}<=$pageCount;$m++){
echo "<a style='text-decoration: none' href='empList.php?pageNow={$k_{$m}}'>[{$k_{$m}}]</a> ";
}
}
echo "当前页{$pageNow}/共{$pageCount}页";
echo "<br/><br/>";
?>
<form action="empList.php">
跳转到:<input type="text" name="pageNow"/>
<input type="submit" value="GO"/>
</form>
<?php
mysql_free_result($res2);
mysql_close($conn);
?>
</html>