php 分页 (一页一页的查询，提高相对情况下的查询速度)

Ethanhuyi

于 2016-07-19 11:14:28 发布

阅读量1.1k

点赞数

分类专栏： php扩展 php随记 PHp函数

本文链接：https://blog.csdn.net/will5451/article/details/51954126

版权

php随记同时被 3 个专栏收录

70 篇文章 0 订阅

订阅专栏

php扩展

46 篇文章 0 订阅

订阅专栏

PHp函数

37 篇文章 0 订阅

订阅专栏

<?php
header("Content-Type: text/html; charset=utf-8");
$connec=mysql_connect('localhost','root','root') or die('不能连接数据库服务器： '.mysql_error());
mysql_select_db('asp9sqlbak',$connec) or die ('不能选择数据库: '.mysql_error());
mysql_query("set names 'utf8'");
$biao="asp9bak";
$t1 = microtime(true);
$column1 = $_REQUEST['search'];
$Page_size=25;
$result=mysql_query("select * from $biao where  (web like '%$column1%' or dingdan like '%$column1%' or kuaidihao like '%$column1%' or link like '%$column1%')  "); 
$count = mysql_num_rows($result); 
$row = mysql_fetch_array($result);
$page_count = ceil($count/$Page_size); 
$init=1; 
$page_len=7; 
$max_p=$page_count; 
$pages=$page_count; 
if(empty($_GET['page'])||$_GET['page']<0){$page=1;}else {$page=$_GET['page'];} 
$offset=$Page_size*($page-1); 
$sql="select * from $biao where (web like '%$column1%' or dingdan like '%$column1%' or kuaidihao like '%$column1%' or link like '%$column1%')  order by id desc limit $offset,$Page_size"; 
$result=mysql_query($sql,$connec); 
while ($row=mysql_fetch_array($result)) { 
?>
<?=$row['id'];?>>
<?=date('m-d',strtotime($row['addtime']));;?>>
<?=$row['web'];;?>>
<?=$row['dingdan'];;?>>
<?=$row['kuaidi'];;?>>
<?=$row['kuaidihao'];;?>>
<?=$row['link'];;?>><br>
<?
}
$t2 = microtime(true);
echo '耗时'.round($t2-$t1,3).'秒';
//循环结束
//开始分页
$page_len =
($page_len%2)?$page_len:$pagelen+1;
$pageoffset = ($page_len-1)/2;
$key='<div class="Pagination">'; 
$key.="<span>共<b>$count </b>条，每页$Page_size 条</span>
";
if($page!=1){ 
$key.="<a
href=\"".$_SERVER['PHP_SELF']."?page=1&search=$column1\">第一页</a>"; 
$key.="<a
href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."&search=$column1\">上一页</a>";
}else {
$key.="  ";} 
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.=' <span>'.$i.'</span>'; 
} else { 
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".$i."&search=$column1\">".$i."</a>";
}} 
if($page!=$pages){ 
$key.=" <a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."&search=$column1\">下一页</a>";
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page={$pages}&search=$column1\">最后一页</a>";
}else {$key.="  ";} 
$key.=" 共$pages 页"; 
$key.='</div>';
?>
<div align="center"><?echo $key?></div>