row count in codeigniter
$this->db->where('EmpID >=', 5);
$query = $this->db->get('Employees');
echo $query->num_rows();
// Outputs, 4row count in codeigniter
$this->db->where('EmpID >=', 5);
$query = $this->db->get('Employees');
echo $query->num_rows();
// Outputs, 4codeigniter 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();get result count codeigniter
public function record_count() {
return $this->db->count_all("tablename");
}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;
}Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
