Fatal error: Call to a member function get() on a non-object in[Codigniter]

Question

Homemodel.php

    <?php

/* 
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
class HomeModel extends CI_Model{

    private $DB1, $DB2;

    function __construct()
    {
        parent::__construct();
        $this->DB1 = $this->load->database('sample');
    }

    public function getData(){

        /* @var $query type */
        $query  = $this->DB1->get('employee');
        return $query->result(); // Standard Query With Multiple Results (Object Version)

    }

}//class 

Home.php(Controller)

    <?php

/* 
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
class  Home extends CI_Controller{

//    private $View;

    public function index(){

        $this->load->model('HomeModel');
        $db_data['eduData'] = $this->HomeModel->getData();  

        $this->load->view('View', $db_data);
    }
}

I have tried above way to fetch data from db, but i got error as

Fatal error: Call to a member function get() on a non-object in D:\xampp\htdocs\Codeigniter\application\models\HomeModel.php on line 21

how to fix that error? and also i have another doubt for Controller Home.php file , i have defined index() call default, and i have tried to change that function name i got error how to fix that error also?

Answer 1

You need to load the database first. CodeIgniter won't load it by default for you.

You can either add it to /config/autoload.php like so

$autoload['libraries'] = array('database');

Or you can load it on demand whenever you want by calling

$this->load->database();

Answer 2

You are missing the db in your code.

Change This

$query  = $this->DB1->get('employee');

To This

$query  = $this->DB1->db->get('employee');

Because you have specified sample as a database group you need to make sure it is set up in database.php

Multiple database

$active_group = 'default';
$query_builder = TRUE;

$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => '',
    'database' => 'project-1',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);


$db['sample'] = array(
    'dsn'   => '',
    'hostname' => 'localhost',
    'username' => 'root',
    'password' => '',
    'database' => 'project-2',
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
);

And you have named your model wrong should be named with first letter only upper case.

Model

http://www.codeigniter.com/user_guide/general/models.html#anatomy-of-a-model

Filename Home_model.php

<?php

class Home_model extends CI_Model {

    private $DB1;
    private $DB2;

    public function __construct() {
        parent::__construct();
        $this->DB1 = $this->load->database('sample');
    }

    public function getData() {
        $query  = $this->DB1->db->get('employee');

        if ($query->num_rows() > 0) {
            return $query->result();
        } else {
            return false;
        }
    }

}

Controller

http://www.codeigniter.com/user_guide/general/controllers.html#let-s-try-it-hello-world

Filename Home.php

<?php

class Home extends CI_Controller {

    public function __construct() {
       parent::__construct();
       $this->load->model('home_model');
    }

    public function index() {

        $db_data['eduData'] = $this->home_model->getData();  

        $this->load->view('View', $db_data);
    }
}