CodeIgniter database connection error: "You have not selected a database type to connect to"

Question

I am working on CodeIgniter. While connecting the database, I got following error:

You have not selected a database type to connect to.

My $db settings:

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = 'mypass';
$db['default']['database'] = 'mydatabase';
$db['default']['mysqli'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

My CodeIgniter version is 2.1.2.

I have selected the database as shown above.

hi, if you are working with ci2.1.2, first this arrar is wrong, because, below $db['default']['mysqli'] = 'mysql'; must be $db['default']['dbdriver'] = 'mysqli';`` — elddenmedio
– elddenmedio, Commented Jun 30, 2017 at 16:21

Muhammad Usman · Accepted Answer · 2017-06-30 16:26:04Z

2

you are not initializing your DB driver in your file

Try this

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'dbName';
$db['default']['dbdriver'] = 'mysqli';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

answered Jun 30, 2017 at 16:26

Muhammad Usman

1,39814 silver badges24 bronze badges

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

2 Comments

Muhammad Nadeem Over a year ago

I have the same error: You have not selected a database type to connect to.$db['default']['dbdriver'] = 'mysqli';

Muhammad Nadeem Over a year ago

basically I was trying to connect to anotherDB dynamically, querying the database table from firstDB. and that was making problem. Now its ok. thanks

Collectives™ on Stack Overflow

CodeIgniter database connection error: "You have not selected a database type to connect to"

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related