Codeigniter showing error: No database selected

Question

I am using Codeigniter's DBForge class to create a database and table within that database.

Here is code:

if ($this->dbforge->create_database('new_db')) {
     $fields = array(
         'blog_id' => array(
              'type' => 'INT',
              'constraint' => 5,
              'unsigned' => TRUE,
              'auto_increment' => TRUE
          ),
          'blog_title' => array(
              'type' => 'VARCHAR',
              'constraint' => '100',
          ),
          'blog_author' => array(
              'type' => 'VARCHAR',
              'constraint' => '100',
              'default' => 'King of Town',
          ),
          'blog_description' => array(
              'type' => 'TEXT',
              'null' => TRUE,
          ),
     );
     $this->dbforge->add_field($fields);
     $this->dbforge->add_key('blog_id', TRUE);
     $this->dbforge->create_table('blog', TRUE);
}

The above mentioned code is written inside index function of controller. When the following code is executed, it shows error as, No database selected. Does anyone have ant idea why it is happening. Any help is appreciated.

Igor S. · Accepted Answer · 2013-05-06 06:12:30Z

7

You need to specify

 $db['default']['database'] = "new_db";

in database.php

answered May 6, 2013 at 6:12

Igor S.

3,3501 gold badge27 silver badges33 bronze badges

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

Comments

Amaan Iqbal · Accepted Answer · 2017-07-12 12:31:29Z

1

Just refer to database.php file inside application/config folder. Make sure you have proper values for database name and other things in the following lines present in database.php file

$db['default'] = array(
'dsn'   => '',
'hostname' => 'localhost',
'username' => 'your username', //By default it is root
'password' => 'your password', //By default this field is empty
'database' => 'database name',//The error that you are getting is because of this only. Specify your database name here
'dbdriver' => 'mysqli',

Hope it helps

answered Jul 12, 2017 at 12:31

Amaan Iqbal

7592 gold badges9 silver badges25 bronze badges

Comments

Steve Lukis · Accepted Answer · 2018-12-17 04:08:35Z

0

If you have set the default database in config/database.php and it is still not working, you probably should save the file in case you forget to do that.

answered Dec 17, 2018 at 4:08

Steve Lukis

4695 silver badges12 bronze badges

Collectives™ on Stack Overflow

Codeigniter showing error: No database selected

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related