codeigniter 看一看 (2) 翻页控件改编版

最新推荐文章于 2021-03-17 02:05:50 发布

jiang664

最新推荐文章于 2021-03-17 02:05:50 发布

阅读量85

点赞数

分类专栏： CodeIgniter 文章标签： MySQL PHP Access Go UP

CodeIgniter 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

由于有一个翻页的需求，原来做的翻页比较垃圾，所以就改装下Pagination了。目前完成的，没有留出数据库的交互的参数，基于在很少改动原来程序的情况下，实现翻页，代码如下：

<?php
/**
* Pagination Class
*
* @category Pagination
* @author Martin
* @link This class is based on the file from codeigniter
*/
class Pagination {
var $base_url = ''; // The page we are linking to
var $total_rows = ''; // Total number of items (database results)
var $per_page = 3; // Max number of items you want shown per page
var $num_links = 4; // Number of "digit" links to show before/after the currently viewed page
var $cur_page = 0; // The current page being viewed
var $first_link = '&lsaquo; First';
var $next_link = '>';
var $prev_link = '<';
var $last_link = 'Last &rsaquo;';
var $full_tag_open = '';
var $full_tag_close = '';
var $first_tag_open = '';
var $first_tag_close = ' ';
var $last_tag_open = ' ';
var $last_tag_close = '';
var $cur_tag_open = ' <b>';
var $cur_tag_close = '</b>';
var $next_tag_open = ' ';
var $next_tag_close = ' ';
var $prev_tag_open = ' ';
var $prev_tag_close = '';
var $num_tag_open = ' ';
var $num_tag_close = '';
var $url_params = null;
/**
* Constructor
*
* @access public
* @param array initialization parameters
*/
function Pagination($params = array())
{
if (count($params) > 0)
{
$this->initialize($params);
}
}
// --------------------------------------------------------------------
/**
* Initialize Preferences
*
* @access public
* @param array initialization parameters
* @return void
*/
function initialize($params = array())
{
if (count($params) > 0)
{
foreach ($params as $key => $val)
{
if (isset($this->$key))
{
$this->$key = $val;
}
}
}
$this->url_params = $_GET;
}
// --------------------------------------------------------------------
/**
*
*
* @param array initialization parameters
* @return string
*/
function getUrl()
{
$linkUrl = $this->base_url . "?";
foreach ($this->url_params as $key => $value)
{
$linkUrl.= $key . "=".$value."&";
}
return $linkUrl;
}
function setCurrentPage($currentpage)
{
$this->url_params['cp'] = $currentpage;
}
function setPerPage($perpage)
{
$this->url_params['pp'] = $currentpage;
}
// --------------------------------------------------------------------
/**
* Generate the pagination links
*
* @access public
* @return string
*/
function create_links()
{
if( !$this->url_params['pp'] )
{
$this->setPerPage($this->per_page);
}
// If our item count or per-page total is zero there is no need to continue.
if ($this->total_rows == 0 OR $this->per_page == 0)
{
return '';
}
// Calculate the total number of pages
$num_pages = ceil($this->total_rows / $this->per_page);
// Is there only one page? Hm... nothing more to do here then.
if ($num_pages == 1)
{
return '';
}
if ( ! is_numeric($this->cur_page))
{
$this->cur_page = 0;
}
// Is the page number beyond the result range?
// If so we show the last page
if ($this->cur_page > $this->total_rows)
{
$this->cur_page = ($num_pages - 1) * $this->per_page;
}
$uri_page_number = $this->cur_page;
$this->cur_page = floor(($this->cur_page/$this->per_page) + 1);
// Calculate the start and end numbers. These determine
// which number to start and end the digit links with
$start = (($this->cur_page - $this->num_links) > 0) ? $this->cur_page - ($this->num_links - 1) : 1;
$end = (($this->cur_page + $this->num_links) < $num_pages) ? $this->cur_page + $this->num_links : $num_pages;
// Add a trailing slash to the base URL if needed
//$this->base_url = preg_replace("/(.+?)/*$/", "\1/", $this->base_url);
echo $this->base_url;
// And here we go...
$output = '';
// Render the "First" link
if ($this->cur_page > $this->num_links)
{
$output .= $this->first_tag_open.'<a href="'.$this->base_url.'">'.$this->first_link.'</a>'.$this->first_tag_close;
}
// Render the "previous" link
if (($this->cur_page - $this->num_links) >= 0)
{
$i = $uri_page_number - $this->per_page;
if ($i == 0) $i = '';
$this->setCurrentPage($i);
$output .= $this->prev_tag_open.'<a href="'.$this->getUrl().'">'.$this->prev_link.'</a>'.$this->prev_tag_close;
}
// Write the digit links
for ($loop = $start -1; $loop <= $end; $loop++)
{
$i = ($loop * $this->per_page) - $this->per_page;
if ($i >= 0)
{
if ($this->cur_page == $loop)
{
$output .= $this->cur_tag_open.$loop.$this->cur_tag_close; // Current page
}
else
{
$n = ($i == 0) ? '' : $i;
$this->setCurrentPage($n);
$output .= $this->num_tag_open.'<a href="'.$this->getUrl().'">'.$loop.'</a>'.$this->num_tag_close;
}
}
}
// Render the "next" link
if ($this->cur_page < $num_pages)
{
$this->setCurrentPage($this->cur_page * $this->per_page);
$output .= $this->next_tag_open.'<a href="'.$this->getUrl().'">'.$this->next_link.'</a>'.$this->next_tag_close;
}
// Render the "Last" link
if (($this->cur_page + $this->num_links) < $num_pages)
{
$i = (($num_pages * $this->per_page) - $this->per_page);
$this->setCurrentPage($i);
$output .= $this->last_tag_open.'<a href="'.$this->getUrl().'">'.$this->last_link.'</a>'.$this->last_tag_close;
}
// Kill double slashes. Note: Sometimes we can end up with a double slash
// in the penultimate link so we'll kill all double slashes.
$output = preg_replace("#([^:])//+#", "\1/", $output);
// Add the wrapper HTML if exists
$output = $this->full_tag_open.$output.$this->full_tag_close;
return $output;
}
}
// END Pagination Class
?>

例子如下：

$currentPage = $_GET['cp'];
$perPage = $_GET['pp'];
$query = "SELECT * table";
$result = mysql_query($query,$GLOBALS['db']);
$hitCount = mysql_num_rows ($result);
$offset = '0,';
$limit = '3';
if($currentPage)
{
$offset = $currentPage.",";
}
if($perPage)
{
$limit = $perPage;
}
$query .= " LIMIT ".$offset.$limit;
//now you can print your content
...
//disaply the pagination hyperlinker
$pageTest = new Pagination();
$pageTest->initialize( array(
'base_url' => 'testPagination.php',
'total_rows' => $hitCount,
'per_page' => $limit,
'cur_page' => $currentPage,
'full_tag_open' => '<p>',
'full_tag_close' => '</p>'
)
);
echo $pageTest->create_links();

好了，放心使用吧，当然如果你有需要还可以根据需要扩展下数据的绑定，样式等

jiang664

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
codeigniter 看一看 (2) 翻页控件改编版

由于有一个翻页的需求，原来做的翻页比较垃圾，所以就改装下Pagination了。目前完成的，没有留出数据库的交互的参数，基于在很少改动原来程序的情况下，实现翻页，代码如下： &lt;?php /** * Pagination Class * * @category Pagination * @aut...
复制链接

扫一扫