Using Model in codeigniter

Other topics

Creating Model

Go to application/model

File name - Home_model.php
Inside the file

class Home_model extends CI_Model {

    public $variable;

    public function __construct()
    { 
        parent::__construct();
    }

    public function get_data()
    {
        $query = $this->db->get('table_name', 10);
        return $query->result_array();
    }
}

And when you need to load this model:

$this->load->model('home_model');
$this->home_model->get_data();

Or If you would like your model assigned to a different object name you can specify it like this:

$this->load->model('home_model', 'home');
$this->home->get_data();

Loading Model

Syntax - $this->load->model('model_name');
Practice - $this->load->model('home_model');

If you would like your model assigned to a different object name you can specify it via the second parameter of the loading method:

Syntax -

  $this->load->model('model_name', 'foobar');
  $this->foobar->method(); 

Practice -

 $this->load->model('home_model', 'home'); 
 $this->home->get_data(); 

Calling Model function

Syntax

$this->load->model('model_name');
$this->model_name->method_name();

Practice

$this->load->model('home_model');
$this->home_model->get_data();

Passing data to model

Syntax

$array = array(
    '' => , 
    ); # can pass array 
$singelData  = ''; # something just a filed value
$this->load->model('model_name');
$this->model_name->method_name($singelData, $array);

Practice

$array = array(
    'name' => 'codeigniter', 
    'version' => '3.0', 
    'isArray' => 'yes', 
    );
$singelData  = 'using model'; # something just a filed value
$this->load->model('home_model');
$this->home_model->get_data($singelData, $array);

Receiving data from controller

public function method_name($single, $array)
{
    echo $single;
    print_r($array);
}

Beware with the order which pass from controller to model.

Return Data to Controller

public function get_username($uid)
{
            $query = 
            $this->db->select('id')
             ->select('name')
             ->from('user_table')
             ->where('id', $uid)
             ->get();
        return $query->result_array();
}

this will return the result with matched id and username to the controller.

Contributors

Topic Id: 3777

Example Ids: 13060,13061,13062,13063,13064,31844

This site is not affiliated with any of the contributors.