Home > Backend Development > PHP Tutorial > 关于PHP的分页有关问题

关于PHP的分页有关问题

WBOY
Release: 2016-06-13 13:18:41
Original
747 people have browsed it

关于PHP的分页问题
本人是新手,麻烦大神们教我怎么用PHP完成查看数据中的分页功能,谢谢

------解决方案--------------------
看这个分页,有注释,看不懂就拿下来改着用
http://www.jb51.net/article/27813.htm
------解决方案--------------------
给个例子,最近也在整这个东西。

PHP code
public static function getuser(CleanRequest &$clean){
    Registry::set('clean',$clean);
    //print_r(Registry::get('clean'));die();
    //print_r(Registry::get());
    $user=$clean->get('user');
    if($user)
    $where.=($where?' and':' where').' admin_name like \'%'.$user.'%\'';
    $db=new MysqlDB();
    $sql1="select * from admin";
    $result=$db->query($sql1);
    $count=$db->num_rows($result);
    $pagesize=5;
     if($page=$clean->get('page')){
            $page = intval($page);
        }
        else {
            $page=1;
        }
   $pagecount=ceil($count/$pagesize);
   $limit=$page-1;
        //if($where)
        $sql="select * from admin ".$where." limit ".$limit*$pagesize.",$pagesize";
        $r=$db->select($sql);
        foreach($r as $v){
        $html.='<tr>
<td>'.$v['admin_id'].'</td>
<td>'.$v['admin_name'].'</td>
<td>'.$v['admin_pwd'].'</td>
<td><a href="javascript:void(0)" class="del">删除</a></td>
</tr>';
        }
        /*for($i=1;$i$i";
        else
        $html.=" ".$i;*/
          //}
        if($count>$pagesize){
        /*if($page==1){//如果页数只有一页
            $html .= '首页|上一页';
         }*/
         //else{
         $html.='<tr><td colspan="5">';
         if($page>1){
            $html .= '<a href="/?r=User&action=index&page=1">首页</a>|<a href="/?r=User&action=index&page='.(%24page-1).'">上一页</a>|';
        }
         if($page==$pagecount||$pagecount==0){//如果当前页等于总也数
            $html .= '下一页|尾页';
        }
         else{
            $html .=  '<a href="/?r=User&action=index&page='.(%24page+1).'">下一 页</a>|<a href="/?r=User&action=index&page='.%24pagecount.'">尾页</a>';
        }
        }
        $html.='  共'.$count.'条记录 每页'.$pagesize.'条 共'.$pagecount.'页</td></tr>';
        return $html;
        }
<br><font color="#e78608">------解决方案--------------------</font><br>5楼给的是很清楚的,用的面向对象的方法,我也给你一个我自己用的<br><?php   <br />require_once 'db.php';<br>session_start();<br>$pagesize = 5;        // 每一页显示多少<br>$page = $_GET["page"];<br><br>if($page == ""){        //如果没有设定页数则默认为1<br>	$page=1;<br>}<br>$sql = "select * from st_info order by ID desc limit ".($pagesize*($page-1)).",".$pagesize;<br><br>$query=mysql_query($sql); //显示从多少到多少<br><br><br>$quer2=mysql_query("select * from st_info");<br>$num=mysql_num_rows($quer2);     //查找所有的行数<br>$pagecount=ceil($num/$pagesize); //应该显示多少页<br><br><br>if($pagecount == 0){<br>	echo "sorry,it's null";<br>}else{<br>	if(mysql_num_rows($query)==0){<br>		echo "sorry,";<br>	}<br><br>}<br><br>?>  <br>
Copy after login




总共有页,
每页显示条信息,
总共有条数据.
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template