| 755 |
lars |
1 |
<?php
|
|
|
2 |
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
3 |
|
|
|
4 |
/*
|
|
|
5 |
| -------------------------------------------------------------------
|
|
|
6 |
| DATABASE CONNECTIVITY SETTINGS
|
|
|
7 |
| -------------------------------------------------------------------
|
|
|
8 |
| This file will contain the settings needed to access your database.
|
|
|
9 |
|
|
|
|
10 |
| For complete instructions please consult the 'Database Connection'
|
|
|
11 |
| page of the User Guide.
|
|
|
12 |
|
|
|
|
13 |
| -------------------------------------------------------------------
|
|
|
14 |
| EXPLANATION OF VARIABLES
|
|
|
15 |
| -------------------------------------------------------------------
|
|
|
16 |
|
|
|
|
17 |
| ['dsn'] The full DSN string describe a connection to the database.
|
|
|
18 |
| ['hostname'] The hostname of your database server.
|
|
|
19 |
| ['username'] The username used to connect to the database
|
|
|
20 |
| ['password'] The password used to connect to the database
|
|
|
21 |
| ['database'] The name of the database you want to connect to
|
|
|
22 |
| ['dbdriver'] The database driver. e.g.: mysqli.
|
|
|
23 |
| Currently supported:
|
|
|
24 |
| cubrid, ibase, mssql, mysql, mysqli, oci8,
|
|
|
25 |
| odbc, pdo, postgre, sqlite, sqlite3, sqlsrv
|
|
|
26 |
| ['dbprefix'] You can add an optional prefix, which will be added
|
|
|
27 |
| to the table name when using the Query Builder class
|
|
|
28 |
| ['pconnect'] TRUE/FALSE - Whether to use a persistent connection
|
|
|
29 |
| ['db_debug'] TRUE/FALSE - Whether database errors should be displayed.
|
|
|
30 |
| ['cache_on'] TRUE/FALSE - Enables/disables query caching
|
|
|
31 |
| ['cachedir'] The path to the folder where cache files should be stored
|
|
|
32 |
| ['char_set'] The character set used in communicating with the database
|
|
|
33 |
| ['dbcollat'] The character collation used in communicating with the database
|
|
|
34 |
| NOTE: For MySQL and MySQLi databases, this setting is only used
|
|
|
35 |
| as a backup if your server is running PHP < 5.2.3 or MySQL < 5.0.7
|
|
|
36 |
| (and in table creation queries made with DB Forge).
|
|
|
37 |
| There is an incompatibility in PHP with mysql_real_escape_string() which
|
|
|
38 |
| can make your site vulnerable to SQL injection if you are using a
|
|
|
39 |
| multi-byte character set and are running versions lower than these.
|
|
|
40 |
| Sites using Latin-1 or UTF-8 database character set and collation are unaffected.
|
|
|
41 |
| ['swap_pre'] A default table prefix that should be swapped with the dbprefix
|
|
|
42 |
| ['encrypt'] Whether or not to use an encrypted connection.
|
|
|
43 |
|
|
|
|
44 |
| 'mysql' (deprecated), 'sqlsrv' and 'pdo/sqlsrv' drivers accept TRUE/FALSE
|
|
|
45 |
| 'mysqli' and 'pdo/mysql' drivers accept an array with the following options:
|
|
|
46 |
|
|
|
|
47 |
| 'ssl_key' - Path to the private key file
|
|
|
48 |
| 'ssl_cert' - Path to the public key certificate file
|
|
|
49 |
| 'ssl_ca' - Path to the certificate authority file
|
|
|
50 |
| 'ssl_capath' - Path to a directory containing trusted CA certificats in PEM format
|
|
|
51 |
| 'ssl_cipher' - List of *allowed* ciphers to be used for the encryption, separated by colons (':')
|
|
|
52 |
| 'ssl_verify' - TRUE/FALSE; Whether verify the server certificate or not ('mysqli' only)
|
|
|
53 |
|
|
|
|
54 |
| ['compress'] Whether or not to use client compression (MySQL only)
|
|
|
55 |
| ['stricton'] TRUE/FALSE - forces 'Strict Mode' connections
|
|
|
56 |
| - good for ensuring strict SQL while developing
|
|
|
57 |
| ['ssl_options'] Used to set various SSL options that can be used when making SSL connections.
|
|
|
58 |
| ['failover'] array - A array with 0 or more data for connections if the main should fail.
|
|
|
59 |
| ['save_queries'] TRUE/FALSE - Whether to "save" all executed queries.
|
|
|
60 |
| NOTE: Disabling this will also effectively disable both
|
|
|
61 |
| $this->db->last_query() and profiling of DB queries.
|
|
|
62 |
| When you run a query, with this setting set to TRUE (default),
|
|
|
63 |
| CodeIgniter will store the SQL statement for debugging purposes.
|
|
|
64 |
| However, this may cause high memory usage, especially if you run
|
|
|
65 |
| a lot of SQL queries ... disable this to avoid that problem.
|
|
|
66 |
|
|
|
|
67 |
| The $active_group variable lets you choose which connection group to
|
|
|
68 |
| make active. By default there is only one group (the 'default' group).
|
|
|
69 |
|
|
|
|
70 |
| The $query_builder variables lets you determine whether or not to load
|
|
|
71 |
| the query builder class.
|
|
|
72 |
*/
|
|
|
73 |
$active_group = 'default';
|
|
|
74 |
$query_builder = TRUE;
|
|
|
75 |
|
|
|
76 |
$db['default'] = array(
|
|
|
77 |
'dsn' => '',
|
|
|
78 |
'hostname' => 'localhost',
|
|
|
79 |
'username' => 'root',
|
|
|
80 |
'password' => 'NcC2007',
|
|
|
81 |
'database' => $GLOBALS['INI']['dbConnect']['database'],
|
|
|
82 |
'dbdriver' => 'mysqli',
|
|
|
83 |
'dbprefix' => '',
|
|
|
84 |
'pconnect' => TRUE,
|
|
|
85 |
'db_debug' => (ENVIRONMENT !== 'production'),
|
|
|
86 |
'cache_on' => FALSE,
|
|
|
87 |
'cachedir' => '',
|
|
|
88 |
'char_set' => 'utf8',
|
|
|
89 |
'dbcollat' => 'utf8_general_ci',
|
|
|
90 |
'swap_pre' => '',
|
|
|
91 |
'encrypt' => FALSE,
|
|
|
92 |
'compress' => FALSE,
|
|
|
93 |
'stricton' => FALSE,
|
|
|
94 |
'failover' => array(),
|
|
|
95 |
'save_queries' => TRUE
|
|
|
96 |
);
|
|
|
97 |
|
|
|
98 |
$db['order_db'] = array(
|
|
|
99 |
'dsn' => '',
|
|
|
100 |
'hostname' => 'localhost',
|
|
|
101 |
'username' => 'root',
|
|
|
102 |
'password' => 'NcC2007',
|
|
|
103 |
'database' => $GLOBALS['INI']['dbConnect']['order_db'],
|
|
|
104 |
'dbdriver' => 'mysqli',
|
|
|
105 |
'dbprefix' => '',
|
|
|
106 |
'pconnect' => TRUE,
|
|
|
107 |
'db_debug' => (ENVIRONMENT !== 'production'),
|
|
|
108 |
'cache_on' => FALSE,
|
|
|
109 |
'cachedir' => '',
|
|
|
110 |
'char_set' => 'utf8',
|
|
|
111 |
'dbcollat' => 'utf8_general_ci',
|
|
|
112 |
'swap_pre' => '',
|
|
|
113 |
'encrypt' => FALSE,
|
|
|
114 |
'compress' => FALSE,
|
|
|
115 |
'stricton' => FALSE,
|
|
|
116 |
'failover' => array(),
|
|
|
117 |
'save_queries' => TRUE
|
|
|
118 |
);
|
|
|
119 |
|
|
|
120 |
$db['db_red'] = array(
|
|
|
121 |
'dsn' => '',
|
|
|
122 |
'hostname' => 'localhost',
|
|
|
123 |
'username' => 'content_managem',
|
|
|
124 |
'password' => 'k-dp-u',
|
|
|
125 |
'database' => 'content_management',
|
|
|
126 |
'dbdriver' => 'mysqli',
|
|
|
127 |
'dbprefix' => '',
|
|
|
128 |
'pconnect' => TRUE,
|
|
|
129 |
'db_debug' => (ENVIRONMENT !== 'production'),
|
|
|
130 |
'cache_on' => FALSE,
|
|
|
131 |
'cachedir' => '',
|
|
|
132 |
'char_set' => 'utf8',
|
|
|
133 |
'dbcollat' => 'utf8_general_ci',
|
|
|
134 |
'swap_pre' => '',
|
|
|
135 |
'encrypt' => FALSE,
|
|
|
136 |
'compress' => FALSE,
|
|
|
137 |
'stricton' => FALSE,
|
|
|
138 |
'failover' => array(),
|
|
|
139 |
'save_queries' => TRUE
|
|
|
140 |
);
|