creating table in mysql database with codeigniter

Question

I try to create a table with codeigniter in mysql DB with following code:

$posts_fields=array(
        'id'=>array('type' => 'INT','constraint' => 5,'unsigned' => TRUE),
        'title'=>array('type' =>'VARCHAR','constraint' => 100),
        'content'=>array('type'=>'text'),
        'create_time'=>array('type'=>'INT','constraint'=>12));

    $this->dbforge->add_field($posts_fields);
    $this->dbforge->create_table('posts');

but anytime get error "NO DATABASE SELECTED".

how can I select a database to create tables in it?? (this database is not default database)

I try to create table in a database that is not default database. — mojtaba.sln
– mojtaba.sln, Commented Aug 22, 2015 at 8:21

Community · Accepted Answer · 2017-05-23 10:33:44Z

3

You can have a look at Codeigniter showing error: No database selected

If you are using different database then use following,

$this->db->query('use db2');

and then put your code.

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Aug 22, 2015 at 10:15

Disha V.

1,8641 gold badge13 silver badges21 bronze badges

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

1 Comment

Disha V. Over a year ago

glad, i could help :)

Deepak pant · Accepted Answer · 2021-09-01 09:12:51Z

1

database.php Declare database name in the database.php

This may solve your error!

answered Sep 1, 2021 at 9:12

Deepak pant

113 bronze badges

2 Comments

Community Over a year ago

Please add further details to expand on your answer, such as working code or documentation citations.

helvete Over a year ago

Please post your code as text, not as an image. Look here why it's not a good idea to use images or screenshots.

Collectives™ on Stack Overflow

creating table in mysql database with codeigniter

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related