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

46 篇文章 0 订阅
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>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值