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

-1 vote213 views4 answers
Include blade file in laravel
PHP Laravel
1 vote204 views1 answer
Php counting number of chars excluding newlines
PHP
0 vote175 views1 answer
Get text field value in php
PHP
0 vote196 views1 answer
How to select specific id in laravel using isset
PHP
0 vote178 views1 answer
Php if simple
PHP
0 vote252 views1 answer
Get node id in twig drupal
PHP Drupal
8 votes266 views6 answers
Laravel transaction
PHP Laravel
1 vote214 views1 answer
Docx file validation laravel 8
PHP Laravel
0 vote195 views1 answer
Query builder laravel getmedia undefined method
PHP Laravel
0 vote173 views2 answers
Wordpress wp_logout_url redirect
PHP