Get result count codeigniter

public function record_count() {
   return $this->db->count_all("tablename");
}

Codeigniter count rows

$this->db
  ->where(['field'=>'foo'])
  ->from("tablename")
  ->count_all_results();

//OR 
$this->db
  ->where(['field'=>'foo'])
  ->count_all_results("tablename");

Count all results codeigniter

$this->db->select('id');
$this->db->from('table');
$this->db->where($your_conditions);
$num_results = $this->db->count_all_results();

Source: stackoverflow.com

Similar codes

0 vote213 views1 answer
Laravel routes return view in web.php
PHP
47 votes236 views6 answers
How to add new column in laravel migration
PHP
0 vote218 views2 answers
Php infinite loop
PHP
1 vote213 views2 answers
Laravel blade dump
PHP
4 votes204 views2 answers
Laravel blade errors all
PHP
0 vote231 views1 answer
Laravel change string to text
PHP Laravel
0 vote243 views1 answer
Get user id trougt user code
PHP
1 vote203 views1 answer
Laravel change post request before save
PHP
0 vote221 views1 answer
Php curl detect 404
PHP
22 votes244 views4 answers
Laravel orWhere
PHP Laravel