Jump to content

Archived

This topic is now archived and is closed to further replies.

hamza

CoDE igneter pagination help

Recommended Posts

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;
    }

Share this post


Link to post
Share on other sites

Sure, read this.  Do you actually have a problem or error?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

 

:D

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.