Skip to content

AJAX Pagination with CI Pagination Library

Jump to bottom Edit New page
World Wide Web Server edited this page Jul 4, 2012 · 19 revisions

Ajax_pagination.php : put in system/libraries/ [code] <?php if (!defined('BASEPATH')) exit('No direct script access allowed'); /**

// ------------------------------------------------------------------------

/**

  • 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 = ' '; var $cur_tag_close = ''; 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 Ajax_pagination($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.'base_url.'">'.$this->first_link.''.$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.'base_url.$i.'">'.$this->prev_link.''.$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;
         $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.'base_url.($this->cur_page * $this->per_page).'">'.$this->next_link.''.$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.'base_url.$i.'">'.$this->last_link.''.$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;

      return $output;
      }

    function my_link_to_remote($url, $text, $div, $pars=array()){ if($pars !== NULL): foreach($pars as $k=>$v): $par = $k.":".$v; endforeach;

     $html = "&lt;a href=\"#\"  onclick=\"new Ajax.Updater('$div','$url',{method: 'post', parameters:{".$par."}, evalScripts:true}); return false;\" /&gt;$text</a>";
 else:
 $html = "&lt;a href=\"#\"  onclick=\"new Ajax.Updater('$div','$url',{method: 'post', evalScripts:true}); return false;\" /&gt;$text</a>";
 endif;

    return $html; } } // END Pagination Class ?> [/code]

//CONTROLLER: my_data_page.php [code] <? class My_data_page extends Controller{ function My_data_page(){ parent::Controller(); $this->load->library('table'); $this->load->helper('html'); $this->load->library('Ajax_pagination'); } function index(){ $data['makeColums'] = $this->makeColums(); $data['getTotalData'] = $this->getTotaData(); $data['perPage'] = $this->perPage(); $this->load->view('my_data_page', $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 name FROM contact LIMIT ".$offset.", ".$this->perPage();
    $q = $this->db->query($sql);
    return $q->result();
}
function getTotalData(){
  $sql = "SELECT * FROM people";
  $q = $this->db->query($sql);
  return $q->num_rows();
}

function perPage(){
     return 10; //define total records per page
  }

//Generate table from array
function makeColumns(){
     $peoples = $this->getData();
     foreach($peoples as $pep):
     $data[] = $pep->name;
     endforeach;
     return  $this->table->make_columns($data, 6);
}

} ?> [/code] VIEW: my_data_page.php [code] <s\cript type="text/javascript" src="path/to/prototype.js"></s\cript>

<? $config['first_link'] = 'First'; $config['div'] = 'content'; //Div tag id $config['base_url'] = 'index.php/my_data_page'; $config['total_rows'] = $getTotalData; $config['per_page'] = $perPage; $config['postVar'] = 'page';

$this->ajax_pagination->initialize($config); print $this->ajax_pagination->create_links(); //PRINT TABLE print $this->table->generate($makeColumns); ?>

[/code]

Category:Contributions::Libraries::Pagination

Add a custom footer
Clone this wiki locally