![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
[php]
<?php
${basename(__FILE__)} = true; #加载本页标志
# =================================================================== #
#GET参数:
#$page => 当前页码
#$record_total => 纪录总数
#设置:
#$pagesize => 每页长度
#输出:
#$first_link =>第一页
#$front_link =>上一页
#$next_link =>下一页
#$last_link =>最后一页
#变量:
#$sql_all =>不带分页的sql语句
# =================================================================== #
# -------------------- #
#设置分页的SQL语句
#输出$sql => SQL语句(含LIMIT 0 ,%d)
# -------------------- #
function set_centpage_sql(&$sql)
{
global $page,$pagesize,$record_total,$sql_all,$db_rows_count;
if(!isset($record_total) )
{
db_query($sql_all);
$record_total = $db_rows_count;
}else if($record_total <1)
{
$record_total = 1;
}
if(!isset($page) || $page < 1 ) $page = 1;
if(!isset($pagesize)) $pagesize = 8;
$start_record = ($page - 1) * $pagesize;
$sql = sprintf('%s LIMIT %d , %d',$sql,$start_record,$pagesize);
}
# -------------------- #
#设置分页的链接
#$querystring => 查询字符串 &开头,用&分隔
# -------------------- #
function set_centpage_link($querystring='')
{
global $first_link,$front_link,$next_link,$last_link,$PHP_SELF,
$page,$pagesize,$record_total,$pagecount;
if(!isset($page)) $page = 1;
if(!isset($pagesize)) $pagesize = 8;
if(!isset($record_total)) $record_total = 1;
$first_link = $front_link = $next_link = $last_link = '';
//计算总页数
$pagecount = ceil($record_total/$pagesize);
if($pagecount == 0 ) $pagecount = 1;
//设置queryString
$querystring = "&record_total=".$record_total.$querystring;
//设置分页链接
$first_link = "href=". sprintf("%s?page=%d%s", $PHP_SELF, 1, $querystring);
$front_link = "href=" . sprintf("%s?page=%d%s", $PHP_SELF, $page - 1, $querystring);
$next_link = "href=" . sprintf("%s?page=%d%s", $PHP_SELF, $page + 1, $querystring);
$last_link = "href=" . sprintf("%s?page=%d%s", $PHP_SELF, $pagecount, $querystring);
if($page == 1)
{
$first_link= $front_link = "";
if($pagecount == 1)
$next_link = $last_link = "";
}
else if($page == $pagecount)
{
$next_link = $last_link = "";
}
else if($page > $pagecount)
{
$first_link= $front_link=$next_link = $last_link = "";
}
}
?>
[/php]
有哪里不会希望告诉我一下噢。

