CodeIgniter connection to database

Question

I decided end my cooperation with Doctrine 2.3 and now I would like to make connection to database using only CodeIgniter have you got idea where is problem with my code?

This Error I get:

A PHP Error was encountered

Severity: Notice

Message: Undefined property: Hello::$db

Filename: core/Model.php

Line Number: 51

Database.php

$db['default']['hostname'] = 'localhost:8080';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'ci_doctrine';
$db['default']['dbdriver'] = 'mysql';

Controller

<?php
    // system/application/controllers/hello.php

    class Hello extends CI_Controller {

        public function __construct()
        {
             parent::__construct();
        }
       function world() {
            echo "Hello CodeIgniter!";
        }

        function user_test() {

            $this->load->model('user');

            $this->user->save_User('username','password','first_name','last_name');

       }
}

?>

Model - table name in database "user"

<?php
    // system/application/models/user.php

    class User extends CI_Model {

            function __construct()
            {
                // Call the Model constructor
                parent::__construct();
            }

             function save_User($username,$password,$fName,$lName)  {

                $this->username   = $username; 
                $this->password = $password;
                $this->first_name    = $fName;
                $this->last_name    = $lName;
                $this->db->insert('user', $this);
              }

    }
?>

@raheel shan but if I will remove this port I`m not able to connect to website. My port 80 have Skype and WAMP have 8080. — Rafał Developer
– Rafał Developer, Commented Feb 2, 2013 at 18:28

mallix · Accepted Answer · 2013-02-02 18:33:29Z

4

You need to load the database library:

config/autoload.php

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

answered Feb 2, 2013 at 18:33

mallix

1,4392 gold badges22 silver badges45 bronze badges

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

5 Comments

Rafał Developer Over a year ago

you mean this -> $autoload['config'] = database.php; ??

Muhammad Raheel Over a year ago

yes are you loading database class? you haven't mentioned it in question.

mallix Over a year ago

No I mean $autoload['libraries'] = array('database'); Folder application/config file autoload.php :)

Rafał Developer Over a year ago

I get this -> A Database Error Occurred Unable to connect to your database server using the provided settings. Filename: C:\wamp\www\nauka\system\database\DB_driver.php Line Number: 124

mallix Over a year ago

Now you have another error on your application/config/database.php file. Change you specs to correct ones, in order to connect to your database.

Muhammad Raheel · Accepted Answer · 2013-02-02 18:32:36Z

3

The problem is that you are not loading database class

$this->load->database();

Here is the Codeigniter User Guide

Without connecting you can not use database class therefore it is saying undefined property db.

answered Feb 2, 2013 at 18:32

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

1 Comment

Muhammad Raheel Over a year ago

try to free post edit for wamp by going to Skype->tool->settings->advance->connection and uncheck use port 80 and 443 then restart wamp and skype

Dipu Raj · Accepted Answer · 2016-11-03 07:57:55Z

1

For manual connection
Use this in your controller file

$this->load->database();

For automate connection in database

Go to Controller then in autoload.php make the following changes

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

edited Nov 3, 2016 at 7:57

Dipu Raj

1,8944 gold badges33 silver badges39 bronze badges

answered Nov 3, 2016 at 6:01

hassan javaid

8213 bronze badges

Comments

Preetika Kaur · Accepted Answer · 2016-11-04 07:06:44Z

0

You need to load the database library:

config/autoload.php

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

Try it .

edited Nov 4, 2016 at 7:06

Preetika Kaur

2,0312 gold badges18 silver badges23 bronze badges

answered Nov 4, 2016 at 6:10

hassan javaid

8213 bronze badges

Collectives™ on Stack Overflow

CodeIgniter connection to database

4 Answers 4

5 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related