当前位置：首页 > CN2资讯 > 正文内容

PHP分页

1天前CN2资讯

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>客户列表</title>
</head>
<?php
require_once 'PageClass.php';
require_once 'EmpService.php';
/* $conn = mysql_connect("localhost","root","123456");
if(!$conn){
    die('Could not connect: ' . mysql_error());
}
mysql_select_db('empmanage',$conn); */
/* $pagesize=3 ;
$pageCount = 0;
$pageNo = 1 ;
$rowCount = 0 ; */
/* $sql2 ="select count(Id) from emp";
$result2 = mysql_query($sql2,$conn);
if($row2=mysql_fetch_row($result2)){
    $rowCount = $row2[0];//获取总的记录数
}
$pageCount =ceil($rowCount/$pagesize);//ceil去整数的作用 */
$fenyePage = new FenyePage();
$fenyePage->setPagesize(3);
$fenyePage->setPageNo(1);
$empService = new EmpService();
//$pageCount = $empService->getPageCount($pagesize);
$Number = $_GET['pageNo'];//用于读取自己页面提交时的数据
if($Number>$fenyePage->getPageNo()){
    $fenyePage->setPageNo( $Number) ;
}
/* $sql = "select * from emp limit ".($pageNo-1)*$pagesize.",$pagesize";
//echo $sql;
$result = mysql_query($sql,$conn); */
//$result = $empService->getEmpList($pageNo, $pagesize);
$empService->getFenyeBypageClass($fenyePage);///根据对象进行分页技术的
echo "<table border='1'>";
echo "<tr><th>id</th><th>name</th><th>grder</th><th>email</th><th>salay</th><th>删除用户</th><th>修改用户</th></tr>";
/* while ($row = mysql_fetch_assoc($result)){
    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='empDelect.php?id={$row['Id']}'>删除用户</a></td><td><a href='empModefy.php?id={$row['Id']}'>修改用户</a></td></tr>";
} */
$result = $fenyePage->getRes_arry();///数组为二维数组的
for($i=0;$i<count($result);$i++){
    $row = $result[$i];
    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='empDelect.php?id={$row['Id']}'>删除用户</a></td><td><a href='empModefy.php?id={$row['Id']}'>修改用户</a></td></tr>";
}
echo "</table>";
/* for($i=1 ; $i<=$pageCount;$i++){
     echo "<a href='empList.php?pageNo=$i'>$i</a>&nbsp";
}
*/
if($fenyePage->getPageNo()>1){
$pagepre = $fenyePage->getPageNo()-1 ;
echo "<a href='empList.php?pageNo=$pagepre'>上一页</a>&nbsp";
             }
if($fenyePage->getPageNo()<$fenyePage->getPageCount()){
     $pageNext = $fenyePage->getPageNo()+1 ;
echo "<a href='empList.php?pageNo=$pageNext'>下一页</a>&nbsp";
             }//可以进行类的封装
             /**
             * 按数字的链接排序，实现整天翻页
             */
             //echo $fenyePage->getDaohang();导航封装调用
     $start = floor(($fenyePage->getPageNo()-1)/10)*10+1;//floor向下取整
     $index = $start;
     if($fenyePage->getPageNo()>10){
         echo "<a href='empList.php?pageNo=".($start-1)."'><<</a>&nbsp";//减一操作
     }
             for(;$start<$index+10;$start++){
                 echo "<a href='empList.php?pageNo=$start'>[$start]</a>&nbsp";
             }
             echo "<a href='empList.php?pageNo=$start'>>>></a>&nbsp";
echo "当前第{$fenyePage->getPageNo()}页&nbsp";
echo "共{$fenyePage->getPageCount()}页";?>
//可以用javascript尝试实现该功能
<form action="empList.php">
跳转到<input type="text" name="pageNo" /><br/>
<input type="submit" value="GO" >
</form>

</html>