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 vote229 views1 answer
Laravel seeding with relationships
PHP Laravel
5 votes180 views2 answers
Laravel groupby and latest
PHP
0 vote187 views1 answer
Laravel: Validation unique on update
PHP
0 vote235 views1 answer
Many to many relationship in laravel example stackoverflow
PHP Laravel
0 vote212 views1 answer
Check if variable is set and not empty laravel
PHP Laravel
10 votes227 views2 answers
Laravel collection toArray
PHP Laravel
16 votes183 views6 answers
How to get array key in php
PHP
1 vote168 views1 answer
Php invert boolean
PHP
2 votes209 views1 answer
Laravel Call to a member function diffForHumans() on string
PHP Laravel
0 vote209 views1 answer
Rename matomo php
PHP