Codeigniter count rows

Get result count codeigniter

public function record_count() {
   return $this->db->count_all("tablename");
}

Row count in codeigniter

$this->db->where('EmpID >=', 5);
$query = $this->db->get('Employees');
echo $query->num_rows();

// Outputs, 4

Source: kodingmadesimple.com

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

Get number of rows in codeigniter model

function data_model() {
    $this->db->select('*');
    $this->db->from('news_data');
    $id = $this->db->get()->num_rows();
    return $id;
}

Source: stackoverflow.com

Similar codes

2 votes341 views1 answer
Category name wp query
PHP
0 vote288 views1 answer
Php strict mopde
PHP
0 vote299 views1 answer
Laravel collection zip
PHP
1 vote337 views1 answer
Wordpress if is in categroy
PHP Wordpress
0 vote383 views1 answer
Php get time past midnight
PHP
0 vote302 views1 answer
Php print array source code
PHP
10 votes327 views4 answers
Is users logged in laravel blade
PHP
28 votes309 views4 answers
String remove last two characters php
PHP
0 vote355 views1 answer
Laravel override eloquent all function
PHP Laravel
0 vote300 views1 answer
Sub menu for post type in wordpress
PHP