最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
php 分页程序代码
时间:2009-08-15 编辑:简简单单 来源:一聚教程网
$tempquery = mysql_query("select dpb,facejtype from zgy_member_p_d_basic where dpb = '$city' and facejtype like '%$keyword%' ");
$count = mysql_num_rows( $tempquery );
if( $count )
{
$page=isset($_GET['page'])?$_GET['page']:1;
$pagesize=20;
$pagecount=($count % $pagesize)?(int)($count / $pagesize) +1:$count / $pagesize;
$page=($page>$pagecount || $page<1)?$page=1:$page;
$start=$pagesize*($page-1);
$sql = "Select
dpb,
truename,
uid,
sex,
birth,
education,
experience,
facejkind,
facejtype,
id
from
zgy_member_p_d_basic
where
dpb = '$city' and
facejtype like '%$keyword%' group by uid order by id desc limit $start,$pagesize";
$query = mysql_query( $sql ) or die( mysql_error() );
while( $rs = mysql_fetch_array( $query ) )
{
?>
$date = date("Y-m-d");
$date1 = $rs['birth'];
echo sdate($date,$date1);
?>
}
?>
}
else
{
?>
}
?>
-
上一个: php 计算中英文混合字符串的长度
-
下一个: 经典全面的php取得url参数与域名代码
相关文章
- php与Redis分页程序代码 06-21
- php+smarty模板分页程序代码 11-01
- php长文章分页原理与实现程序 12-21
- php利用模板分页程序(带demo演示); 07-23
- PHP导出数据超时的优化建议解读 10-31
- PHP之mysql位运算解析 10-31