AJAX Pagination with CI Pagination Library

1 of 2

Gin2

Posted: 19 March 2008 02:26 PM

[ Ignore ]

Summer Student

Total Posts: 8

Joined 03-19-2008

I have modified CI Pagination library into an ajax based pagination. Check here

Signature

Devil with Mac
Gin2[Kronika]

Profile

Gin2

Posted: 19 March 2008 04:21 PM

[ Ignore ] [ # 1 ]

Summer Student

Total Posts: 8

Joined 03-19-2008

Check the update. Open Wiki, find ‘AJAX Pagination’

Signature

Devil with Mac
Gin2[Kronika]

Profile

wiredesignz

Posted: 19 March 2008 04:27 PM

[ Ignore ] [ # 2 ]

Sr. Research Associate

Total Posts: 2612

Joined 06-10-2007

You might want to throw some [ code ] tags into your submission Gin2, its quite difficult to read without them.

Signature

URI Language Identifier | Modular Extensions - PHP5 | Modular Separation - PHP5 | Widget plugin | Access Control library

Profile

Gin2

Posted: 19 March 2008 05:26 PM

[ Ignore ] [ # 3 ]

Summer Student

Total Posts: 8

Joined 03-19-2008

Oooppsss sorryyyy!! It’a done ( with !!! Thanks wireddesignz!

Signature

Devil with Mac
Gin2[Kronika]

Profile

Too Pixel

Posted: 19 March 2008 06:08 PM

[ Ignore ] [ # 4 ]

Research Assistant

Total Posts: 825

Joined 04-20-2006

It’s look like it’s missing the informations about witch JS library should be used with your script or I misunderstood something ? Maybe a full real world using DB example should be nice too ?

Signature

All CodeIgniter resources into one place?
http://www.codeigniterdirectory.com

Buildon.net - The PHP Frameworks Showcase - Add your links!
http://www.buildon.net

My website: Création de sites Genève, Too Pixel

Profile

Gin2

Posted: 19 March 2008 07:10 PM

[ Ignore ] [ # 5 ]

Summer Student

Total Posts: 8

Joined 03-19-2008

Can this sample help you?
CONTROLLER: my_data_page.php

<? class My_data_page extends Controller{
    function My_data_page(){
       parent::Controller();
       $this->load->library('table');
       $this->load->library('Ajax_pagination');
    }
    function index(){
        $data['makeColumns'] = $this->makeColumns();
        $data['getTotalData'] = $this->getTotalData();
        $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(){
         $contact = $this->getData();
         foreach($contact as $cont):
         $data[] = $cont->name;
         endforeach;
         return  $this->table->make_columns($data, 6); //6 colums maximum
    }
} 
?> 

VIEW: my_data_page.php

<s\cript type="text/javascript" src="path-to-prototype.js"></s\cript>
<div id="content">
<?
$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);
?> 
</div> 

Signature

Devil with Mac
Gin2[Kronika]

Profile

Too Pixel

Posted: 19 March 2008 07:15 PM

[ Ignore ] [ # 6 ]

Research Assistant

Total Posts: 825

Joined 04-20-2006

Yeah that’s cool. But for the JS side, what I must do exactly ?
Do you have a sample snippet of code using Jquery or Scriptaculous ? (or any other web 2.0 JS lib)

Signature

All CodeIgniter resources into one place?
http://www.codeigniterdirectory.com

Buildon.net - The PHP Frameworks Showcase - Add your links!
http://www.buildon.net

My website: Création de sites Genève, Too Pixel

Profile

Gin2

Posted: 19 March 2008 07:22 PM

[ Ignore ] [ # 7 ]

Summer Student

Total Posts: 8

Joined 03-19-2008

Addition: Initialize my_data_page in your page loader (i.e: my_page_data_loader.php)
————————————————————
CONTROLLER: my_data_page_loader.php

<? class My_data_page_loader extends Controller{
   My_data_page_loader(){
    parent::Controller;
  }
  function index(){
    $this->load->view('my_data_page_loader');
  }
} 

VIEW: my_data_page_loader.php

<s\cript type="text/javascript" src="path/to/prototype.js"></s\cript>

<div id="content">your my_data_page will be displayed here</div>

<div id="response" style="display:none">ajax response</div>

<sc\ript type="text/javascrpt>">new Ajax.Updater('content','index.php/my_data_page',{onLoading:function(request){Element.show('response')}, onComplete:function(request){Element.hide('response')}, method: 'post', parameters:{nothing:'todo'}, evalScripts:true});</sc\ript

Signature

Devil with Mac
Gin2[Kronika]

Profile

Gin2

Posted: 19 March 2008 07:25 PM

[ Ignore ] [ # 8 ]

Summer Student

Total Posts: 8

Joined 03-19-2008

before and after ‘new Ajax.Updater ....’ please insert javas\cript opening and closing tag;

Signature

Devil with Mac
Gin2[Kronika]

Profile

Gin2

Posted: 19 March 2008 07:57 PM

[ Ignore ] [ # 9 ]

Summer Student

Total Posts: 8

Joined 03-19-2008

bye for now, it’s morning in Indonesia. And, i have to sleep..

Signature

Devil with Mac
Gin2[Kronika]

Profile

hotmeteor

Posted: 31 March 2008 02:53 PM

[ Ignore ] [ # 10 ]

Summer Student

Total Posts: 24

Joined 12-12-2007

Can you please post your JS for us?

Profile

1 of 2

‹‹ Verifier Library - 0.3 Lucene search engine ››

Username		Remember Me?
Password		forgot password?

Post Marker Legend
	New posts	Hot Topic with new posts	New Poll	Moved Topic	Sticky topic
	No new posts	Hot Topic with no new posts	Old Poll	Closed Topic	Announcements

Visitor Statistics
The most visitors ever was 721, on January 06, 2010 09:38 AM
Total Registered Members:	115017	Total Logged-in Users:	56
Total Topics:	122449	Total Anonymous Users:	2
Total Replies:	647332	Total Guests:	559
Total Posts:	769781