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

4 votes210 views2 answers
Laravel sum column values
PHP Laravel
0 vote239 views1 answer
Count column eloquent laravel
PHP
1 vote160 views3 answers
Laravel syncwithoutdetaching
PHP
0 vote174 views1 answer
Php artisan key:generate error
PHP
0 vote236 views1 answer
Htaccess post max size
PHP
0 vote232 views1 answer
Symfony clear cache
PHP Symfony
0 vote182 views1 answer
How to migrate new column without empty the table in laravel
PHP
0 vote186 views2 answers
Php check undefined offset
PHP
1 vote169 views1 answer
Where () mayor que laravel Eloquent
PHP Laravel
1 vote265 views1 answer
E: Unable to locate package php7.2-mbstring
PHP