codeigniter count rows

135

row count in codeigniter -

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

// Outputs, 4

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 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;
}

Comments

Submit
0 Comments