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

2 votes146 views1 answer
Wp_options siteURL new wordpress
PHP
3 votes119 views2 answers
2 decimal round using php
PHP
1 vote136 views2 answers
Carbon date minus days
PHP
0 vote134 views1 answer
Register sidebar wordpress
PHP Wordpress
0 vote141 views2 answers
The media must not be greater than 12288 kilobytes in laravel
PHP Laravel
0 vote129 views1 answer
How to return custom error message from controller method validation
PHP
0 vote136 views1 answer
Php set status code
PHP
0 vote130 views1 answer
Créer projet laravel
PHP Laravel
37 votes132 views4 answers
Foreign key in laravel migration
PHP Laravel
0 vote122 views1 answer
German locale php
PHP