Pagination automated

[eluser]JoostV[/eluser]
Hi Dine,

First off, this lib is intended for use with default CI URI's, that is: not including a query string (like ?keywords=&search_type=all), so you should expect to find some problems there.

Having said that, I think the problem here is that you switch between manual sql and active record in your queries. I'm not sure if that is at all possible. I think not. This is probably why limit is not in your query.

Code:

$query = "select SQL_CALC_FOUND_ROWS * from tbl_users where 1=1 ";
// (...)
$this->db->limit($config['per_page'], $this->pagination->offset);
$sql = $this->db->query($query);

Try to write the entire query in active record format, for instance

Code:

// Set up SQL
$this->db->where("(name LIKE '%mike%' OR address LIKE '%mike%')");
$this->db->limit($config['per_page'], $this->pagination->offset);
$query = $this->db->get('tbl_users');
// Fetch results
$result = $query->num_rows() > 0 ? query->result_array() : array();