[ganeshamoorthi]

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...

[InsiteFX]

See the MySQL Documentation on the COUNT()

[dave friend]

Query Builder Caching provides one solution.

PHP Code:

$this->db
  ->start_cache()
  ->select('*')
  ->from('payment_transaction');
if(!empty($searchFilter))
{
    $this->db
      ->where("paymentMethod", $searchFilter)
      ->or_where("paymentId", $searchFilter)
      ->or_where("paymentState", $searchFilter);
}

//count the reccords the above returns
$total_records = $this->db->get()->num_rows();

// It is assumed you are using $total_records to determine $startRec 
// your logic should allow the value to be zero if needed. Then...
$transcationQuery = $this->db
  ->limit($limit, $startRec)
  ->get();
$this->db
  ->stop_cache()
  ->flush_cache(); 


I'm a fan of Method Chaining as you can see by the way it is used for calls to $this->db.

[yogadiprasetyo]

Please check your MySQL on the count()