php简略翻页代码

WBOY
Release: 2016-06-13 11:00:19
Original
795 people have browsed it

php简单翻页代码
php简单翻页代码

<style type="text/css">*{    margin:0;    padding:0;}#lay{    margin:100px 100px 100px 100px;}a{    padding:5px;    font-size:13px;    text-decoration:none;}span{    font-size:13px;}table{    border:1px solid red;    border-collapse:collapse;}</style><div id="lay"><table border="1" align="center" cellpadding="0" cellpadding="0"><tr align="center" bgcolor="#ffcc">    <td width="200px;">id</td>    <td width="200px;">值</td>  </tr><?php    $link = mysql_connect("localhost","root","admin"); //连接数据库    mysql_select_db("pagelist");//选择哪个数据库    mysql_query("set names gbk"); //设置数据库字符编码为中文    $sql = mysql_query("select *from v_char");    $pagesize = 10; //    $sum = mysql_num_rows($sql); //一共有多少条数据    $count = ceil($sum/$pagesize);//求出一共有多少页    $pages = $count; //显示最后一页    $init = 1;    $page_len = 7;    $max_p = $count;        if(empty($_GET["page"]) || $_GET["page"]<0){        $page = 1;    }else{        $page = $_GET["page"];    }    $off = ($page-1)*$pagesize; //求出数据库查询的第一个数据    $he = mysql_query("select *from v_char limit $off,$pagesize");//按照off开始,到pagesize规律显示    while($row = mysql_fetch_array($he)){?>    <tr align="center"><td><?php echo $row["id"];?></td><td><?php echo $row["name"];?></td></tr><?php     }    $page_len = ($page_len%2)?$page_len:$page_len+1;//如果余为1则为真,为0则为假    $pageoffset = ($page_len-1)/2;//页码偏移量        if($page!=1){        $key.="<span><a href=\"".$_SERVER['PHP_SELF']."?page=1"."\">第一页 </a></span>";        $key.="<span><a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">上一页 </a></span>";    }else{        $key.="<span>第一页 </span>";        $key.="<span>上一页 </span>";    }    if($pages>$page_len){        if($page<=$pageoffset){            $init=1;            $max_p = $page_len;        }else{            if($page+$pageoffset>=$pages+1){                $init = $pages - $page_len+1;            }else{                $init = $page-$pageoffset;                $max_p = $page + $pageoffset;            }        }    }    for($i=$init;$i<$max_p;$i++){        if($i==$page){            $key.="[ ".$i." ]";                    }else{            $key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">$i</a>";        }    }    if($i!=$page){        $key.="<span><a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">下一页</a></span>";        $key.="<span><a href=\"".$_SERVER['PHP_SELF']."?page=".$pages."\">最后一页</a></span>";    }else{        $key.="<span>下一页</span>";        $key.="<span>最后一页</span>";    }?><tr align="center"><td colspan="2"><?php echo $key;?></td></tr></table></div>
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
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!