Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter: Friendly pagination with search system - View Page
#1

[eluser]ronald_allan_rivera[/eluser]
Can someone help me create the VIEW page for the following library and controller.

I got this source code on http://www.vrusso.com.br/blog/2009/01/co...anguage=en


library/Pagination_search.php

Code:
<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Pagination_search {

    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        = '&nbsp;<b>';
    var $cur_tag_close        = '</b>';
    var $next_tag_open        = '&nbsp;';
    var $next_tag_close        = '&nbsp;';
    var $prev_tag_open        = '&nbsp;';
    var $prev_tag_close        = '';
    var $num_tag_open        = '&nbsp;';
    var $num_tag_close        = '';
    var $page_query_string    = FALSE;
    var $query_string_segment = 'per_page';

    /**
     * Constructor
     *
     * @access    public
     * @param    array    initialization parameters
     */
    function Pagination_search($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($search='') {
    
        if ($search!='') $search = '/'.$search;
        
        // 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->config->item('enable_query_strings') === TRUE OR $this->page_query_string === TRUE){
            if ($CI->input->get($this->query_string_segment) != 0){
                $this->cur_page = $CI->input->get($this->query_string_segment);    
                // Prep the current page - no funny business!
                $this->cur_page = (int) $this->cur_page;
            }
        } else {
            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;
            }
        }
        
        if ( ! is_numeric($this->cur_page)) {
            $this->cur_page = 0;
        }
        
        if ($this->cur_page==0) {
            $this->cur_page = 1;
        }
#2

[eluser]ronald_allan_rivera[/eluser]
library/Pagination_search.php continuation
Code:
// 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;
        
        // 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;
        

        // Is pagination being used over GET or POST?  If get, add a per_page query
        // string. If post, add a trailing slash to the base URL if needed
        if ($CI->config->item('enable_query_strings') === TRUE OR $this->page_query_string === TRUE) {
            $this->base_url = rtrim($this->base_url).'&amp;'.$this->query_string_segment.'=';
        } else {
            $this->base_url = rtrim($this->base_url, '/') .'/';
        }
        
        // And herwe go...
        $output = '';
        
        // Render the "First" link
        if ($this->cur_page > $this->num_links) {
            $output .= $this->first_tag_open.'<a >base_url.'1'.$search.'">'.$this->first_link.'</a>'.$this->first_tag_close;
        }
        
        // Render the "previous" link
        if (($this->cur_page - $this->num_links) >= 0) {
            $i = $this->cur_page - 1;
            if ($i == 0) $i = '';
            $output .= $this->prev_tag_open.'<a >base_url.$i.$search.'">'.$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) ? '1' : $loop;
                    $output .= $this->num_tag_open.'<a >base_url.$n.$search.'">'.$loop.'</a>'.$this->num_tag_close;
                }
            }
        }
        
        // Render the "next" link
        if ($this->cur_page < $num_pages) {
            $output .= $this->next_tag_open.'<a >base_url.($this->cur_page + 1).$search.'">'.$this->next_link.'</a>'.$this->next_tag_close;
        }
        
        // Render the "Last" link
        if (($this->cur_page + $this->num_links) < $num_pages) {
            $i = $num_pages;
            $output .= $this->last_tag_open.'<a >base_url.$i.$search.'">'.$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

/* End of file Pagination.php */
/* Location: ./system/libraries/Pagination.php */
?&gt;
#3

[eluser]ronald_allan_rivera[/eluser]
controllers/domain.php
Code:
&lt;?

class Domain extends Controller{
  
function index() { // Forcing the use of page function…

          redirect('domain/page/1');

      }


      function search() {

          $terms = array();

  

          if ($this->uri->segment(3)!='') {

    

              $search = $this->uri->segment(3);

              $search = str_replace(' ','-',$search);

              //valid_char_only($search); // Function to remove accents and invalid characters, use any function

              // Preparando array

              $aux = explode('-',$search);

              foreach($aux as $key => $valor) {

                  $terms[] = $valor;

              }

          } else {

        


              $search = $this->input->post('keyword');

              $search = str_replace(' ','-',$search);

            

              // Preparando array

              $aux = explode('-',$search);

              foreach($aux as $key => $valor) {

                  $terms[] = $valor;

              }

          }

        

          /

          redirect('domain/page/1/'.$search);

        

      }

      

      function page($page='',$terms='') {

          

          if ($page=='') {

              redirect('domain/page/1');

          }

        

          

          if ($this->uri->segment(4)!='') {

              $terms = $this->uri->segment(4);

          }

        

          $this->load->library('pagination_search');

        

          $limit = 20;

          $offset = ($page-1)*$limit;

      

          if ($terms=='') {


              $this->db->limit($limit, $offset);

              $query = $this->db->get('domain');

              $data['total'] = $query->num_rows();

          } else {

            

              $search = str_replace(' ','-',$terms);

              // Preparing array

              $mysearch = array();

              $aux = explode('-',$search);

              foreach($aux as $key => $valor) {

                  $mysearch[] = $valor;

              }

            

            

              $this->db->like('domain_name', $mysearch[0]);

              //$this->db->or_like('id', $mysearch[0]);

              //$this->db->or_like('description', $mysearch[0]);

            

              $tt = count($mysearch);

              if ($tt>0) {

                  for ($j=1;$j<$tt;$j++) {

                      $this->db->or_like('domain_name', $mysearch[$j]);

                      //$this->db->or_like('id', $mysearch[$j]);

                      //$this->db->or_like('description', $mysearch[$j]);

                  }

              }

            

              

              $query_tt = $this->db->get('domain');

      

              $this->db->like('domain_name', $mysearch[0]);

            

      

              $tt = count($mysearch);

              if ($tt>0) {

                  for ($j=1;$j<$tt;$j++) {

                      $this->db->or_like('domain_name', $mysearch[$j]);


                  }

              }

            

              $this->db->limit($limit, $offset);

              $query = $this->db->get('domain');

              $data['total'] = $query_tt->num_rows();
              
        

          }

      


          $config['base_url']= site_url() . '/domain/page/';
          

          $config['total_rows'] = $data['total'];

          $config['per_page'] = $limit;

          $config['uri_segment'] = 3;

          $config['num_links'] = 5;

        

          $this->pagination_search->initialize($config);

        

          $data['num_of_pages'] = round($data['total'] / $limit);

          $data['domain'] = $query;
          
          $data['links']=$this->pagination_search->create_links($search);

          $data['search'] = $search;
        

          $this->load->view('domain',$data);

      }
      
}
?&gt;




Theme © iAndrew 2016 - Forum software by © MyBB