Razican | 114ab09 | 2011-04-25 17:26:45 +0200 | [diff] [blame] | 1 | <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 2 | /* |
| 3 | | ------------------------------------------------------------------- |
| 4 | | DATABASE CONNECTIVITY SETTINGS |
| 5 | | ------------------------------------------------------------------- |
| 6 | | This file will contain the settings needed to access your database. |
| 7 | | |
Derek Allard | b76fedd | 2010-08-12 16:14:10 -0400 | [diff] [blame] | 8 | | For complete instructions please consult the 'Database Connection' |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 9 | | page of the User Guide. |
| 10 | | |
| 11 | | ------------------------------------------------------------------- |
| 12 | | EXPLANATION OF VARIABLES |
| 13 | | ------------------------------------------------------------------- |
| 14 | | |
| 15 | | ['hostname'] The hostname of your database server. |
| 16 | | ['username'] The username used to connect to the database |
| 17 | | ['password'] The password used to connect to the database |
| 18 | | ['database'] The name of the database you want to connect to |
Razican | 114ab09 | 2011-04-25 17:26:45 +0200 | [diff] [blame] | 19 | | ['dbdriver'] The database type. ie: mysql. Currently supported: |
| 20 | | mysql, mysqli, postgre, odbc, mssql, sqlite, oci8 |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 21 | | ['dbprefix'] You can add an optional prefix, which will be added |
Razican | 114ab09 | 2011-04-25 17:26:45 +0200 | [diff] [blame] | 22 | | to the table name when using the Active Record class |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 23 | | ['pconnect'] TRUE/FALSE - Whether to use a persistent connection |
| 24 | | ['db_debug'] TRUE/FALSE - Whether database errors should be displayed. |
| 25 | | ['cache_on'] TRUE/FALSE - Enables/disables query caching |
| 26 | | ['cachedir'] The path to the folder where cache files should be stored |
| 27 | | ['char_set'] The character set used in communicating with the database |
| 28 | | ['dbcollat'] The character collation used in communicating with the database |
Derek Jones | 6ae70cc | 2011-04-19 16:13:48 -0500 | [diff] [blame] | 29 | | NOTE: For MySQL and MySQLi databases, this setting is only used |
Derek Jones | 3b9f88d | 2011-05-20 10:25:13 -0500 | [diff] [blame^] | 30 | | as a backup if your server is running PHP < 5.2.3 or MySQL < 5.0.7 |
| 31 | | (and in table creation queries made with DB Forge). |
Derek Jones | 6ae70cc | 2011-04-19 16:13:48 -0500 | [diff] [blame] | 32 | | There is an incompatibility in PHP with mysql_real_escape_string() which |
| 33 | | can make your site vulnerable to SQL injection if you are using a |
| 34 | | multi-byte character set and are running versions lower than these. |
| 35 | | Sites using Latin-1 or UTF-8 database character set and collation are unaffected. |
Derek Jones | ad1171a | 2010-03-10 14:18:38 -0600 | [diff] [blame] | 36 | | ['swap_pre'] A default table prefix that should be swapped with the dbprefix |
| 37 | | ['autoinit'] Whether or not to automatically initialize the database. |
Derek Allard | b76fedd | 2010-08-12 16:14:10 -0400 | [diff] [blame] | 38 | | ['stricton'] TRUE/FALSE - forces 'Strict Mode' connections |
Derek Jones | c34e578 | 2010-03-02 17:35:55 -0600 | [diff] [blame] | 39 | | - good for ensuring strict SQL while developing |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 40 | | |
| 41 | | The $active_group variable lets you choose which connection group to |
Razican | 114ab09 | 2011-04-25 17:26:45 +0200 | [diff] [blame] | 42 | | make active. By default there is only one group (the 'default' group). |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 43 | | |
| 44 | | The $active_record variables lets you determine whether or not to load |
| 45 | | the active record class |
| 46 | */ |
| 47 | |
Derek Allard | b76fedd | 2010-08-12 16:14:10 -0400 | [diff] [blame] | 48 | $active_group = 'default'; |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 49 | $active_record = TRUE; |
| 50 | |
Derek Allard | b76fedd | 2010-08-12 16:14:10 -0400 | [diff] [blame] | 51 | $db['default']['hostname'] = 'localhost'; |
| 52 | $db['default']['username'] = ''; |
| 53 | $db['default']['password'] = ''; |
| 54 | $db['default']['database'] = ''; |
| 55 | $db['default']['dbdriver'] = 'mysql'; |
| 56 | $db['default']['dbprefix'] = ''; |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 57 | $db['default']['pconnect'] = TRUE; |
| 58 | $db['default']['db_debug'] = TRUE; |
| 59 | $db['default']['cache_on'] = FALSE; |
Derek Allard | b76fedd | 2010-08-12 16:14:10 -0400 | [diff] [blame] | 60 | $db['default']['cachedir'] = ''; |
| 61 | $db['default']['char_set'] = 'utf8'; |
| 62 | $db['default']['dbcollat'] = 'utf8_general_ci'; |
| 63 | $db['default']['swap_pre'] = ''; |
Derek Jones | ad1171a | 2010-03-10 14:18:38 -0600 | [diff] [blame] | 64 | $db['default']['autoinit'] = TRUE; |
Derek Jones | c34e578 | 2010-03-02 17:35:55 -0600 | [diff] [blame] | 65 | $db['default']['stricton'] = FALSE; |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 66 | |
| 67 | |
| 68 | /* End of file database.php */ |
Derek Jones | f0b3994 | 2010-03-25 10:08:20 -0500 | [diff] [blame] | 69 | /* Location: ./application/config/database.php */ |