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 vote171 views1 answer
Db raw update laravel
PHP Laravel
0 vote143 views1 answer
Laravel price database
PHP
24 votes165 views3 answers
Difference of two dates in seconds php
PHP
6 votes144 views2 answers
Create migration model and seeder laravel at once
PHP
5 votes166 views2 answers
Laravel encrypt decrypt
PHP Laravel
3 votes164 views2 answers
Laravel where condition on relationship
PHP Laravel
0 vote258 views1 answer
Yii2 gridview action change urls
PHP Yii
0 vote157 views1 answer
Css en linea php
PHP
30 votes146 views3 answers
Random key generator php
PHP
0 vote150 views1 answer
Php curl detect 404
PHP