hamza Posted November 21, 2008 Share Posted November 21, 2008 Please tell me how i use pagination in short paging to get 20 records per page what i have done is all shown below config , model , controller , n actuall page all code is below thanks if any help is replies pagination.php config file ======================= [/code] <?php $config['base_url'] = 'http://localhost/working/CodeIgniter_1.6.3/index.php/Admin/users/'; $config['total_rows'] = '300'; $config['per_page'] = '20'; ?> [/code] controller ‘Admin’ have function ==================== function users() { $data['userdata'] = $this->Madmin->getAllUsers(); $data['usersStatus'] = $this->Madmin->getAllUsersStatus(); $data['title']='Users Lists'; $data['heading']='Users List '; $this->load->view('admin/users',$data); } view name is : users ==================== <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title><?php echo $title;?></title> </head> <body> <?php $data_ADD = array( 'src' => 'asset/newobject.gif' ,'title'=>'Add User' , 'border' => '0');?> <?php $data1 = array( 'src' => 'asset/non.gif' ,'title'=>'Delete User' , 'border' => '0');?> <?php $data_EDIT = array( 'src' => 'asset/edit.gif', 'title'=>'Edit User' , 'border' => '0');?> <?php echo $this->load->view('admin/header'); ?> <?php echo br().'<hr>'; ?> <?php echo anchor('User/register',img($data_ADD).'Add New'); echo br(); echo 'Total registered Users :: '.$this->db->count_all('register'); echo br(); if( empty($userdata) ) { //if no recored found echo $msg = 'No Recored Found'; }else { $this->table->add_row('<b>ID', '<b>NAME' , '<b>COUNTRY', '<b>EMAIL','<b>Status','<b>Actions'); //$this->table->add_row( anchor('User/register',img($data_ADD)) ); $num=1; $statusCount=0; foreach($userdata as $records) { $color = ($num%2==0)? '#00CCCC': '#00CCCC'; echo '<p style=background-color:'.$color.'>'; $status = ( $usersStatus[$statusCount]=='yes')? 'Active' :'InActive'; $this->table->add_row( $records['id'] , $records['name'] , $records['country'] , $records['email'] , $status ,anchor('Admin/delete/'.$records['id'].'',img($data1)) , anchor('Admin/editUser/'.$records['id'],img($data_EDIT)) ); echo '</p>'; $num++; $statusCount++; } echo $this->table->generate(); }//if end echo $this->pagination->create_links(); ?> </body> </html> And the model i have is this => ‘Madmin’ function getAllUsers() { $dbData = array(); $this->db->select('*'); $this->db->limit(''); $query = $this->db->get('register'); foreach( $query->result_array() as $records ) { $dbData[] = $records; } return $dbData; } function getAllUsersStatus() { $dbData = array(); $this->db->select('status'); $query = $this->db->get('login'); foreach( $query->result_array() as $records ) { $dbData[] = $records; } return $dbData; } Quote Link to comment Share on other sites More sharing options...
Maq Posted November 21, 2008 Share Posted November 21, 2008 Sure, read this. Do you actually have a problem or error? Quote Link to comment Share on other sites More sharing options...
awpti Posted November 24, 2008 Share Posted November 24, 2008 Uh, better yet. Read this - the proper documentation for the CI Framework. The pagination content laid out on phpfreaks.com will not help in with this framework. All of your questions can be answered there regarding functionality. Quote Link to comment Share on other sites More sharing options...
Maq Posted November 25, 2008 Share Posted November 25, 2008 Uh, better yet. Read this - the proper documentation for the CI Framework. The pagination content laid out on phpfreaks.com will not help in with this framework. All of your questions can be answered there regarding functionality. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.