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

0 vote149 views1 answer
Fibers - PHP 8.1
PHP
1 vote134 views2 answers
Laravel add attribute to model
PHP
0 vote165 views1 answer
Laravel create new file if not exists
PHP Laravel
0 vote137 views2 answers
Notice: Trying to get property 'NAME' of non-object in
PHP
0 vote145 views2 answers
Upload Webp to Wordpress
PHP Wordpress
2 votes136 views1 answer
Php array map cast to int
PHP
0 vote195 views1 answer
Laravel Excel numbers formatted as text still appearing as number
PHP Laravel
0 vote150 views1 answer
How to put multiple string in one echo in php
PHP
4 votes158 views2 answers
Laravel collection random
PHP Laravel
15 votes161 views2 answers
Error: Cannot find module 'webpack/lib/rules/DescriptionDataMatcherRulePlugin
PHP