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

10 votes281 views1 answer
Maximum memory limit in wordpress
PHP Wordpress
0 vote263 views1 answer
Require and include difference in laravel
PHP Laravel
0 vote250 views1 answer
Invalid_taxonomy
PHP
1 vote222 views2 answers
Php bulk insert mysql
PHP
1 vote226 views1 answer
Laravel 8: seed users + Jetstream teams
PHP
0 vote250 views3 answers
Laravel postgres deadlock
PHP
0 vote235 views1 answer
Php client enable short tags
PHP
1 vote273 views2 answers
Woocommerce redirect shop page
PHP
2 votes237 views1 answer
Php read zip file without extracting
PHP
49 votes262 views6 answers
Laravel when
PHP Laravel