澳门新葡亰平台官网php 解决旧系统 查出所有数据分页的类

?phpPHP代码:

添加了几个自定义的 从mysql result 集合中 抽取指定片段的方法 ,
没有调用释放的原因 这个涉及到 程序的 原来校验
也多亏网上大神的帮助啊 。。。。 老系统害死人啊, 后台都不能动
复制代码 代码如下:
/* 分页类
* @author xiaojiong & 290747680@qq.com
* @date 2011-08-17
*
* show(2) 1 … 62 63 64 65 66 67 68 … 150
* 分页样式
* #page{font:12px/16px arial}
* #page span{float:left;margin:0px 3px;}
* #page a{float:left;margin:0 3px;border:1px solid #ddd;padding:3px
7px; text-decoration:none;color:#666}
* #page a.now_page,#page a:hover{color:#fff;background:#05c}
*/
class Core_Lib_Page
{
public $first_row; //起始行数
public $list_rows; //列表每页显示行数
protected $total_pages; //总页数
protected $total_rows; //总行数
protected $now_page; //当前页数
protected $method = ‘defalut’; //处理情况 Ajax分页 Html分页(静态化时)
普通get方式
protected $parameter = ”;
protected $page_name; //分页参数的名称
protected $ajax_func_name;
public $plus = 3; //分页偏移量
protected $url;
public function get_page_result()
{
$lastResult = array();
$skipCount = $this->get_skip_row_count();
if(mysql_num_rows($result)>0)
{
mysql_data_seek($result,$skipCount);
}
$pageSize = $this->$list_rows;
while($row = mysql_fetch_array($result))
{
$pageSize –;
$lastResult[] = $row;
if($pageSize == 0)
{
break ;
}
}
return $lastResult;
}
public function get_skip_row_count()
{
return $this->list_rows*($this->now_page-1);
}
/**
* 构造函数
* @param unknown_type $data
*/
public function __construct($data = array())
{
$this->total_rows = $data[‘total_rows’];
$this->parameter = !empty($data[‘parameter’]) ?
$data[‘parameter’] : ”;
$this->list_rows = !empty($data[‘list_rows’]) &&
$data[‘list_rows’] <= 100 ? $data[‘list_rows’] : 15;
$this->total_pages = ceil($this->total_rows /
$this->list_rows);
$this->page_name = !empty($data[‘page_name’]) ?
$data[‘page_name’] : ‘p’;
$this->ajax_func_name = !empty($data[‘ajax_func_name’]) ?
$data[‘ajax_func_name’] : ”;
$this->method = !empty($data[‘method’]) ? $data[‘method’] : ”;
/* 当前页面 */
if(!empty($data[‘now_page’]))
{
$this->now_page = intval($data[‘now_page’]);
}else{
$this->now_page = !empty($_GET[$this->page_name]) ?
intval($_GET[$this->page_name]):1;
澳门新葡亰平台官网 ,}
$this->now_page = $this->now_page <= 0 ? 1 :
$this->now_page;
if(!empty($this->total_pages) && $this->now_page >
$this->total_pages)
{
$this->now_page = $this->total_pages;
}
$this->first_row = $this->list_rows * ($this->now_page –
1);
}
/**
* 得到当前连接
* @param $page
* @param $text
* @return string
*/
protected function _get_link($page,$text)
{
switch ($this->method) {
case ‘ajax’:
$parameter = ”;
if($this->parameter)
{
$parameter = ‘,’.$this->parameter;
}
return ” . $text . ‘)’ . “n”;
break;
case ‘html’:
$url = str_replace(‘?’, $page,$this->parameter);
return ” . $text .
” . “n”;
break;
default:
return ” . $text .
‘%20.%20′)’
. “n”;
break;
}
}
/**
* 设置当前页面链接
*/
protected function _set_url()
{
$url =
$_SERVER[‘REQUEST_URI’].(strpos($_SERVER[‘REQUEST_URI’],’?’)?”:”?”).$this->parameter;
$parse = parse_url($url);
if(isset($parse[‘query’])) {
parse_str($parse[‘query’],$params);
unset($params[$this->page_name]);
$url = $parse[‘path’].’?’.http_build_query($params);
}
if(!empty($params))
{
$url .= ‘&’;
}
$this->url = $url;
}
/**
* 得到$page的url
* @param $page 页面
* @return string
*/
protected function _get_url($page)
{
if($this->url === NULL)
{
$this->_set_url();
}
// $lable = strpos(‘&’, $this->url) === FALSE ? ” : ‘&’;
return $this->url . $this->page_name . ‘=’ . $page;
}
/**
* 得到第一页
* @return string
*/
public function first_page($name = ‘第一页’)
{
if($this->now_page > 5)
{
return $this->_get_link(‘1’, $name);
}
return ”;
}
/**
* 最后一页
* @param $name
* @return string
*/
public function last_page($name = ‘最后一页’)
{
if($this->now_page < $this->total_pages – 5)
{
return $this->_get_link($this->total_pages, $name);
}
return ”;
}
/**
* 上一页
* @return string
*/
public function up_page($name = ‘上一页’)
{
if($this->now_page != 1)
{
return $this->_get_link($this->now_page – 1, $name);
}
return ”;
}
/**
* 下一页
* @return string
*/
public function down_page($name = ‘下一页’)
{
if($this->now_page < $this->total_pages)
{
return $this->_get_link($this->now_page + 1, $name);
}
return ”;
}
/**
* 分页样式输出
* @param $param
* @return string
*/
public function show($param = 1)
{
if($this->total_rows < 1)
{
return ”;
}
$className = ‘show_’ . $param;
$classNames = get_class_methods($this);
if(in_array($className, $classNames))
{
return $this->$className();
}
return ”;
}
protected function show_2()
{
if($this->total_pages != 1)
{
$return = ”;
$return .= $this->up_page(‘for($i =
1;$i<=$this->total_pages;$i++)
{
if($i == $this->now_page)
{
$return .= “$in”;
}
else
{
if($this->now_page-$i>=4 && $i != 1)
{
$return .=”…n”;
$i = $this->now_page-3;
}
else
{
if($i >= $this->now_page+5 && $i != $this->total_pages)
{
$return .=”…n”;
$i = $this->total_pages;
}
$return .= $this->_get_link($i, $i) . “n”;
}
}
}
$return .= $this->down_page(‘>’);
return $return;
}
}
protected function show_1()
{
$plus = $this->plus;
if( $plus + $this->now_page > $this->total_pages)
{
$begin = $this->total_pages – $plus * 2;
}else{
$begin = $this->now_page – $plus;
}
$begin = ($begin >= 1) ? $begin : 1;
$return = ”;
$return .= $this->first_page();
$return .= $this->up_page();
for ($i = $begin; $i <= $begin + $plus * 2;$i++)
{
if($i>$this->total_pages)
{
break;
}
if($i == $this->now_page)
{
$return .= “$in”;
}
else
{
$return .= $this->_get_link($i, $i) . “n”;
}
}
$return .= $this->down_page();
$return .= $this->last_page();
return $return;
}
protected function show_3()
{
$plus = $this->plus;
if( $plus + $this->now_page > $this->total_pages)
{
$begin = $this->total_pages – $plus * 2;
}else{
$begin = $this->now_page – $plus;
}
$begin = ($begin >= 1) ? $begin : 1;
$return = ‘总计 ‘ .$this->total_rows. ‘ 个记录分为 ‘
.$this->total_pages. ‘ 页, 当前第 ‘ . $this->now_page . ‘ 页
‘;
$return .= ‘,每页 ‘;
$return .= ‘ ‘;
$return .= $this->first_page().”n”;
$return .= $this->up_page().”n”;
$return .= $this->down_page().”n”;
$return .= $this->last_page().”n”;
$return .= ”;
for ($i = $begin;$i<=$begin+10;$i++)
{
if($i>$this->total_pages)
{
break;
}
if($i == $this->now_page)
{
$return .= ”.$i.”;
}
else
{
$return .= ” .$i. ”;
}
}
$return .= ”;
return $return;
}
}
?>

?php$page_info = count_page($total , PER_PAGE
);//分页参数$smarty-assign(‘page_first’ ,
$page_info[‘page_first’]);$smarty-assign(‘page_last’ ,
$page_info[‘page_last’]);$smarty-assign(‘page_str’ ,
$page_info[‘page_str’]);$sql = SELECT * FROM `news` ORDER BY
`id` DESC LIMIT {$page_info[‘offset’]} , . PER_PAGE;?

//PAGE : $total总页数 $per每页显示条数 $show 列表条数function
count_page($total = 0 , $per ){$page_out = array( ‘page_first’ = ”,
//首页 ‘page_last’ = ”, //末页 ‘page_str’ = ” , //分页 ‘now_page’ =
1 , //当前页 ‘offset’ = 0, //偏移量 );$page_count = ceil($total /
$per); //总页数if($page_count = 1){ return
$page_out;}$page_out[‘now_page’] = @$_GET[‘page’] +
0;if($page_out[‘now_page’] 1){ $page_out[‘now_page’] = 1;}
elseif($page_out[‘now_page’] $page_count){
$page_out[‘now_page’] = $page_count;}

$page_out[‘offset’] = ($page_out[‘now_page’] – 1) *
$per;//URL正则$SELF =
[url={$_SERVER[]{$_SERVER[‘HTTP_HOST’]}{$_SERVER[‘PHP_SELF'[/url]]}?;@$QUERY
= $_SERVER[‘QUERY_STRING’];$query_page =
preg_replace(array(!((|^)page=([^]+))|(page=)! ,
!(^)|[]{2,}|([]$)!) , array(” , ”) , $QUERY);$query_page = $SELF
. $query_page . ($query_page ? : );/*first
page*/$page_out[‘page_first’] = ‘1’;if($page_out[‘page_first’]
== $page_out[‘now_page’]){ $page_out[‘page_first’] = ‘li
class=previous-off首页/li’;}else{ $page_out[‘page_first’] = ‘lia
href=?page=1首页/a/li’;}/*last page*/$page_out[‘page_last’] =
$page_count;if($page_out[‘page_last’] ==
$page_out[‘now_page’]){ $page_out[‘page_last’] = ‘li
class=next-off尾页/li’;}else{ $page_out[‘page_last’] = ‘lia
href=?page=’ . $page_count. ‘尾页/a/li’;}//限制分页 2008-6-2
Edit$pageleft = $page_out[‘now_page’] = 4 ?
$page_out[‘now_page’] – 4 : 1;$pageright = $page_out[‘now_page’]

  • 4 = $page_count ? $page_out[‘now_page’] + 4 : $page_count;

for($i = $pageleft; $i = $pageright; $i++) { if($i ==
$page_out[‘now_page’]){ $page_out[‘page_str’] .= ‘li
class=active’ . $i . ‘/li’; } else { $page_out[‘page_str’] .= ‘lia
href=’ . $query_page . ‘page=’ . $i . ” . $i . ‘/a/li’; }}return
$page_out;}?

复制PHP内容到剪贴板 PHP代码:CSS 文件

/*PAGE*/#page li { border:0; margin:0; padding:0; font-size:11px;
list-style:none; /* savers */ float:left; }#page a { border:solid 1px
#9aafe5; margin-right:2px; }#page .previous-off,#page .next-off {
border:solid 1px #DEDEDE; color:#888888; display:block; float:left;
font-weight:bold; margin-right:2px; padding:3px 4px; }#page .next
a,#page .previous a { font-weight:bold; }#page .active {
background:#2e6ab1; color:#FFFFFF; font-weight:bold; display:block;
float:left; padding:4px 6px; /* savers */ margin-right:2px; }#page
a:link,#page a:visited { color:#0e509e; display:block; float:left;
padding:3px 6px; text-decoration:none; }#page a:hover{ border:solid 1px
#0e509e; }

You can leave a response, or trackback from your own site.

Leave a Reply

网站地图xml地图