How Select and view count rows from database with Codeigniter

Question

This is my controller : Admin

class Admin extends CI_Controller {

public function index()
{
    $data['jumlah_instansi'] = $this->Dash_model->jml_instansi()->result(); 
    $this->load->view('Admin_view',$data);
}
}

This my model : Dash_model

public function jml_instansi()
{       
    $query = $this->db->query("SELECT * FROM instansi");
    return $query->num_rows();
}}

This my view : Admin_view

<?php echo $jumlah_instansi; ?>

Please help me, sorry newbie..Thank you..

Thats show error Message: Undefined property: Admin::$Dash_model Filename: controllers/Admin.php and Message: Call to a member function jml_instansi() on a non-object

Answer 1

You must first load a model before accessing it, e.g.

public function index()
{
    $this->load->model('Dash_model');
    $data['jumlah_instansi'] = $this->Dash_model->jml_instansi()->result(); 
    // ...
}

See Loading a Model for more.