Database Configuration¶

Codingox has a config file that lets you store your database connection values (username, password, database name, etc.). The config file is located at config/database.php.

The config settings are stored in a multi-dimensional array with this prototype:

$db['default'] = array(
        'hostname' => 'localhost',
        'username' => 'root',
        'password' => '',
        'database' => 'database_name',
        'driver'   => 'mysqli',
);

The reason we use a multi-dimensional array rather than a more simple one is to permit you to optionally store multiple sets of connection values. If, for example, you run multiple environments (development, production, test, etc.) under a single installation, you can set up a connection group for each, then switch between groups as needed. For example, to set up a “test” environment you would do this:

$db['test'] = array(
        'hostname' => 'localhost',
        'username' => 'root',
        'password' => '',
        'database' => 'database_name',
        'driver'   => 'mysqli',
);