Fatal database error on insert() with CodeIgniter

Question

I am getting this error and I don't know what to do:

A PHP Error was encountered
Severity: Notice
Message: Undefined property: Welcome::$db
Filename: core/Model.php
Line Number: 52
Fatal error: Call to a member function insert() on null in C:\xampp\htdocs\site\application\models\account_model.php on line 38

Controller:

public function register()//function register in the controller
{
        $this->load->model('account_model');
        $this->account_model->create_account(); 
}

Model:

function create_account()//function insert.
{
    $insertdata = array('id' =>'',
        'firstname' => $this->input->post('fname'),
        'username' => $this->input->post('email'),
        'username' => $this->input->post('username'),
        'password' => $this->input->post('pass'),
        'role' => '1',
        'status' => 'Active');

    $insert = $this->db->insert('account', $insertdata);
    return $insert; 
}

Konstantin Rachev · Accepted Answer · 2015-09-22 09:24:04Z

1

You need to load the database library into your autoload configuration file, have you already done that?

It is located in ../application/config/autoload.php, search for:

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

and add the database library like this:

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

answered Sep 22, 2015 at 9:24

Konstantin Rachev

3103 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Glenn Over a year ago

Big help Konstantin. However after i change it, another error appeared. Your application/config/database.php file does not appear to contain a valid configuration array.

Glenn Over a year ago

Sorry my bad. this is the error. --- Unable to connect to your database server using the provided settings. Filename: C:\xampp\htdocs\site\system\database\DB_driver.php Line Number: 125

Abdulla Nilam · Accepted Answer · 2015-09-22 09:21:39Z

0

In config/autoload.php, load database library

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

answered Sep 22, 2015 at 9:21

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

5 Comments

Glenn Over a year ago

I got this error . Your application/config/database.php file does not appear to contain a valid configuration array.

Glenn Over a year ago

Sorry my bad. this is the error. --- Unable to connect to your database server using the provided settings. Filename: C:\xampp\htdocs\site\system\database\DB_driver.php Line Number: 125

Abdulla Nilam Over a year ago

Check your database.php and provide your db details

Glenn Over a year ago

@adulla thanks for the big help. I already figured out what's the problem. Till next time! have a good day.

Abdulla Nilam Over a year ago

@Glenn ok ok. Enjoy coding :)

Collectives™ on Stack Overflow

Fatal database error on insert() with CodeIgniter

2 Answers 2

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related