Login

12-31-2007, 04:32 AM

[eluser]Jst4Fun[/eluser]
Hi,
I am quite new to CI. I am trying to create a list with pagination. I am using CI's pagination class to accomplish the same. I was following this Pagination tutorial to implement pagination in my project. I am having certain requirements while displaying the results. Even though there are five fields in the database table I only require data of two fields. They are Name and address. The results should also contain two other col which contains link like edit and delete. So resulting html table should be as follows (sorry the alignment is not correct):

SlNo | Name | Address | Edit | Delete
_________________________________________________________
1 | Test 1 | This is Test |Edit | Delete

So I need to display a serial number (Not from database. Automatically incremented by 1). Name and Description from the database (I was able to display those data successfully), Edit is supposed to be a link which would be directed to index.php/userslist/edit/<id> and delete would also be a link like index.php/userslist/delete/<id>. I am not sure how to add SlNo, edit and delete to the paginated results. Here is the code I have done

controller

Code:
&lt;?php

    $config['base_url'] = base_url().'index.php/users/index/';

        $config['total_rows'] = $this->db->count_all('users');

        $config['per_page'] = '10';

        $config['full_tag_open'] = '<p>';

        $config['full_tag_close'] = '</p>';

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

        $this->load->model('admin_model');

        $data['results'] = $this->admin_model->get_users_list($config['per_page'],$this->uri->segment(3));

        $this->table->set_heading('No', 'Name', 'Address', 'Action');

        $this->load->view('admin/users',$data);

?&gt;

model

Code:
public function get_users_list($num, $offset){

        $this->db->select('name, address');

        $query = $this->db->get('users', $num, $offset);    

        return $query;

    }

view

Code:
&lt;?php echo $this->table->generate($results); ?&gt;

&lt;?php echo $this->pagination->create_links(); ?&gt;

I hope someone would help me. Thanks