Loading model in CodeIgniter is not automatically executing the index() method in that class

Question

I am trying to insert data into a table named class_record in a MySQL database. My controller class aadd_record is written in my add_record.php file.

class Add_record extends CI_Controller
{
    function __construct()
    {
        parent::__construct();
    }
        
    function index()
    {
        $this->load->model('add_record_model');
    }
}

My model add_record_model is as below:

class add_record_model extends CI_Model
{
    function __construct()
    {
        parent::__construct();
    }

    function index()
    {
        $data = array(
            'roll_number' => 15,
            'student_name' => 'Dhrubajyoti Baishya',
            'branch_code' => 'CS'
        );
        
        $this->db->insert('class_record', $data);
    }
}

But when I type http://localhost/codeigniter/index.php/add_record in the url, data is not inserted into the database. What is the problem?

When you open the said URL, does the page open or no page appears at all? Maybe the problem is with URL — M. Ahmad Zafar
– M. Ahmad Zafar, Commented Oct 31, 2012 at 1:59
Are you sure your code is run? What if you put die('foo bar'); in the model's index method and see if it's output? — zerkms
– zerkms, Commented Oct 31, 2012 at 2:01
OK..maybe the url problem ! I put die('foo bar'); in the model's index and the page is blank !. what can be the problem? sorry I am only 3rd day to CI — Nitish
– Nitish, Commented Oct 31, 2012 at 2:04

Rick Calder · Accepted Answer · 2012-10-31 02:05:34Z

You're not actually doing anything in the controller and models don't have index functions the way you're thinking.

You want something like this:

class Add_record extends CI_Controller
{
    function __construct()
    {
        parent::__construct();
    }

    function index()
    {
        $this->load->model('add_record_model');
        $this->add_record_model->insertRecords();
    }
}



class add_record_model extends CI_Model{

function __construct(){
    parent::__construct();
}
function insertRecords(){
    $data = array(

        'roll_number' => 15,
        'student_name' => 'Dhrubajyoti Baishya',
        'branch_code' => 'CS'
    );

    $this->db->insert('class_record',$data);
}
}

The controller does what it says it controls things. By loading the model all you are doing is exposing the models functions to the controller to use directly. Honestly you would pass the data to the model from the controller as well, the function you have is a good little test function but does nada really. How you really want to be doing it is something along these lines.

class Add_record extends CI_Controller
{
    function __construct()
    {
        parent::__construct();
    }

    function index()
    {
        $data = array(

        'roll_number' => 15,
        'student_name' => 'Dhrubajyoti Baishya',
        'branch_code' => 'CS'
    );
        $this->load->model('add_record_model');     
        $this->add_record_model->insertRecords($data);
    }
}



class add_record_model extends CI_Model{

function __construct(){
    parent::__construct();
}
function insertRecords($data){       

    $this->db->insert('class_record',$data);
}
}

Thank you very much Rick Calder. Special thanks for the explanation. Helped me a lot.

Collectives™ on Stack Overflow

Loading model in CodeIgniter is not automatically executing the index() method in that class

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related