Count Records WITH AND WITHOUT LIMITATION... using Codiegniter Standard... |
Hi,
$this->db->select('*'); $this->db->from('payment_transaction'); if ($searchFilter<>"") { $this->db->where("paymentMethod",$searchFilter); $this->db->or_where("paymentId",$searchFilter); $this->db->or_where("paymentState",$searchFilter); } ////////////////////////////////// HERE I NEED, THE COUNT RECRODS IN THAT TABLE, WITHOUT LIMITATION..... if ($startRec==0) { $this->db->limit($limit); } else { $this->db->limit($limit,$startRec); } $transcationQuery=$this->db->get(); ////////////////////////////////// HERE I NEED, FETCH RECORDS WITH LIMITATION..... Note: Please don't repeate the code.... But this case, not working, Please solve this problem as soon as possible...
See the MySQL Documentation on the COUNT()
What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
Query Builder Caching provides one solution.
PHP Code: $this->db I'm a fan of Method Chaining as you can see by the way it is used for calls to $this->db.
|
Welcome Guest, Not a member yet? Register Sign In |