Configuring database in CodeIgniter

To connect your application with the database, you need to set the database connection details in the database.php file. You can store more than one connection details in this file.

Configuring database in CodeIgniter – Setting connection details

You can set the database connection details in the database.php file located under root_folder_of_your_project->config folder.

Modify the database.php file as shown below:

$active_group = 'default';
$query_builder = TRUE;
$db['default'] = array(
    'dsn'   => '',
    'hostname' => 'localhost', //server..
    'username' => 'root', //database username
    'password' => '', //database password
    'database' => 'cisite', //Your database name here
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => FALSE
);

Values used