[eluser]zombica[/eluser]
Hey guys i am doing pagination and i am unable to resolve this thing. I am getting the value of $this->uri->segment(4) for my offset but it returns nothing.
class Users extends Controller {
function Users(){
parent::Controller();
$this->load->model('usermodel');
$this->load->library('pagination');
$this->load->library('session');
$this->load->helper('url');
$this->load->helper('form');
$this->load->helper('date');
$this->load->library('validation');
$this->load->library('email');
}
function users_view(){
/// set page title
$this->data['title'] = 'View Users Records ';
$this->load->vars($this->data);
/******Paginating Records********/
$rows=$this->db->count_all("tms_user");
$base=base_url();
$config['base_url'] =base_url().$this->config->item('index_page').'/'.'users/users_view';
$config['total_rows'] = $rows;
$config['per_page'] = '5';
$config['uri_segment'] = 4;
$config['num_links'] = 4;
$config['first_link'] = '«';
$config['last_link'] = '»';
$config['next_link'] = '>';
$config['prev_link'] = '<';
$this->pagination->initialize($config);
/*******************************/
$data=$this->load_leftmenu();
$user_id = $_SESSION['user_id'];
$data['alluserList'] = $this->usermodel->get_all_user($config['per_page'],$this->uri->segment(4),$user_id); //
$this->load->view('users_view',$data);
exit;
}
A Database Error Occurred
SELECT * from tms_user where userId <> 1 and deleted='0' order by username LIMIT 5,
Regards,
Thanx in advance.....