-
Notifications
You must be signed in to change notification settings - Fork 7.6k
AJAX Pagination with CI Pagination Library
Sheryar Ahmed edited this page Aug 19, 2017
·
2 revisions
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
/**
* CodeIgniter
*
* An open source application development framework for PHP 4.3.2 or newer
*
* @package CodeIgniter
* @author ExpressionEngine Dev Team
* @copyright Copyright (c) 2006, EllisLab, Inc.
* @license http://codeigniter.com/user_guide/license.html
* @link http://codeigniter.com
* @since Version 1.0
* @filesource
*/
// ------------------------------------------------------------------------
/**
* Pagination Class
*
* @package CodeIgniter
* @subpackage Libraries
* @category Pagination
* @author ExpressionEngine Dev Team
* @link http://codeigniter.com/user_guide/libraries/pagination.html
*/
class Ajax_pagination {
var $base_url = ''; // The page we are linking to
var $total_rows = ''; // Total number of items (database results)
var $per_page = 10; // Max number of items you want shown per page
var $num_links = 2; // Number of "digit" links to show before/after the currently viewed page
var $cur_page = 0; // The current page being viewed
var $first_link = '‹ First';
var $next_link = '>';
var $prev_link = '<';
var $last_link = 'Last ›';
var $uri_segment = 3;
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 = '';
//ADDED BY GIN2
var $div = '';
var $postVar = '';
/**
* Constructor
*
* @access public
* @param array initialization parameters
*/
function __construct($params = array())
{
if (count($params) > 0)
{
$this->initialize($params);
}
log_message('debug', "Pagination Class Initialized");
}
// --------------------------------------------------------------------
/**
* 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;
}
}
}
}
// --------------------------------------------------------------------
/**
* Generate the pagination links
*
* @access public
* @return string
*/
function create_links()
{
// 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 '';
}
// Determine the current page number.
//$CI =& get_instance();
// if ($CI->uri->segment($this->uri_segment) != 0)
// {
// $this->cur_page = $CI->uri->segment($this->uri_segment);
//
// // Prep the current page - no funny business!
// $this->cur_page = (int) $this->cur_page;
// }
//Modified
// Determine the current page number.
$CI =& get_instance();
$var = 0;
if($CI->input->post($this->postVar)):
$var = $CI->input->post($this->postVar);
settype($var, "integer");
endif;
if ($var !== 0)
{
$this->cur_page = $var;
// Prep the current page - no funny business!
$this->cur_page = (int) $this->cur_page;
}
$this->num_links = (int)$this->num_links;
if ($this->num_links < 1)
{
show_error('Your number of links must be a positive number.');
}
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 = rtrim($this->base_url, '/') .'/';
// And here we go...
$output = '';
// Render the "First" link
if ($this->cur_page > $this->num_links)
{
$link = $this->my_link_to_remote($this->base_url, $this->first_link, $this->div, NULL);
//$output .= $this->first_tag_open.'<a >base_url.'">'.$this->first_link.'</a>'.$this->first_tag_close;
$output .= $this->first_tag_open.$link.$this->first_tag_close;
}
// Render the "previous" link
if ($this->cur_page != 1)
{
$i = $uri_page_number - $this->per_page;
if ($i == 0){
$i = '';
$pars = NULL;
} else {
$pars = array($this->postVar=>$i);
}
$link = $this->my_link_to_remote($this->base_url, $this->prev_link, $this->div, $pars);
//$output .= $this->prev_tag_open.'<a >base_url.$i.'">'.$this->prev_link.'</a>'.$this->prev_tag_close;
$output .= $this->prev_tag_open.$link.$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;
if($n !== ''){
$pars = array($this->postVar=>$n);
} else {
$pars = NULL;
}
$link = $this->my_link_to_remote($this->base_url, $loop, $this->div, $pars);
//$output .= $this->num_tag_open.'<a >base_url.$n.'">'.$loop.'</a>'.$this->num_tag_close;
//no problem checked
$output .= $this->num_tag_open.$link.$this->num_tag_close;
}
}
}
// Render the "next" link
if ($this->cur_page < $num_pages)
{
$pars = array($this->postVar=>($this->cur_page * $this->per_page));
$link = $this->my_link_to_remote($this->base_url, $this->next_link, $this->div, $pars);
//$output .= $this->next_tag_open.'<a >base_url.($this->cur_page * $this->per_page).'">'.$this->next_link.'</a>'.$this->next_tag_close;
$output .= $this->next_tag_open.$link.$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);
$pars = array($this->postVar=>$i);
$link = $this->my_link_to_remote($this->base_url, $this->last_link, $this->div, $pars);
//$output .= $this->last_tag_open.'<a >base_url.$i.'">'.$this->last_link.'</a>'.$this->last_tag_close;
$output .= $this->last_tag_open.$link.$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;
// die($output);
return $output;
}
function my_link_to_remote($url, $text, $div, $pars=array()){
if($pars !== NULL):
foreach($pars as $k=>$v):
$par = $k.":".$v;
endforeach;
//onclick='new Ajax.Updater('$div','$url',{method: 'post', parameters:{'.$par.'}, evalScripts:true}); return false;'
$html = "<a href='' onclick='new Ajax.Updater(\"$div\",\"$url\",{method: \"post\", parameters:{\"page\":\"$v\"}, evalScripts:true});return false;'>$text</a>";
else:
$html = "<a href='' onclick='new Ajax.Updater(\"$div\",\"$url\",{method: \"post\", evalScripts:true}); return false;' >$text</a>";
endif;
return $html;
}
}
// END Pagination Class
?>###controller
<?php class My_data_page extends CI_Controller{
function __construct() {
parent::__construct();
$this->load->library('table');
$this->load->helper('html');
$this->load->library('Ajax_pagination');
$this->load->database();
$this->load->library('javascript');
}
function index(){
$data['makeColums'] = $this->makeColumns();
$data['getTotalData'] = $this->getTotalData();
$data['perPage'] = $this->perPage();
$this->load->view('my_data_page2', $data);
}
//Pull 'name' field records from table 'contact'
function getData(){
$page = $this->input->post('page'); //Look at $config['postVar']
if(!$page):
$offset = 0;
else:
$offset = $page;
endif;
$sql = "SELECT * FROM registration LIMIT ".$offset.", ".$this->perPage();
$q = $this->db->query($sql);
return $q->result();
}
function getTotalData(){
$sql = "SELECT * FROM registration";
$q = $this->db->query($sql);
return $q->num_rows();
}
function perPage(){
return 5; //define total records per page
}
//Generate table from array
function makeColumns(){
$peoples = $this->getData();
foreach($peoples as $pep):
$data[] = $pep->id;
$data[] = $pep->email;
$data[] = $pep->password;
$data[] = $pep->last_login;
$data[] = $pep->name;
endforeach;
return $this->table->make_columns($data, 5);
}
}
?>###View
<script type="text/javascript" src="<?php echo base_url(); ?>login/js/prototype.js"></script>
<div id="content">
<?php
$config['first_link'] = 'First';
$config['div'] = 'content'; //Div tag id
$config['base_url'] = "http://localhost/login/index.php/my_data_page/index";
$config['total_rows'] = $getTotalData;
$config['per_page'] = $perPage;
$config['postVar'] = 'page';
$this->ajax_pagination->initialize($config);
echo $this->ajax_pagination->create_links();
//PRINT TABLE
print $this->table->generate($makeColums);
?>
</div>