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

15 votes202 views6 answers
Laravel migration default value
PHP Laravel
37 votes167 views6 answers
Php time
PHP
1 vote200 views1 answer
Get user with role laravel
PHP Laravel
0 vote228 views1 answer
Get datetime of excel cell in codeigniter
PHP
17 votes195 views6 answers
Php migrate
PHP
0 vote173 views1 answer
Wordpress loop over posts but exclude current post
PHP
3 votes230 views2 answers
Laravel Migrations from an existing database
PHP Laravel
0 vote217 views1 answer
Pure Intersection Types - PHP 8.1
PHP
1 vote190 views1 answer
Install php linux nginx command line
PHP
1 vote306 views1 answer
Install symfony ubuntu
PHP Symfony