Andrey Andreev | c5536aa | 2012-11-01 17:33:58 +0200 | [diff] [blame] | 1 | <?php |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 2 | /** |
| 3 | * CodeIgniter |
| 4 | * |
Andrey Andreev | fe9309d | 2015-01-09 17:48:58 +0200 | [diff] [blame^] | 5 | * An open source application development framework for PHP |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 6 | * |
Andrey Andreev | bdb96ca | 2014-10-28 00:13:31 +0200 | [diff] [blame] | 7 | * This content is released under the MIT License (MIT) |
Andrey Andreev | 24276a3 | 2012-01-08 02:44:38 +0200 | [diff] [blame] | 8 | * |
Andrey Andreev | fe9309d | 2015-01-09 17:48:58 +0200 | [diff] [blame^] | 9 | * Copyright (c) 2014 - 2015, British Columbia Institute of Technology |
Andrey Andreev | 24276a3 | 2012-01-08 02:44:38 +0200 | [diff] [blame] | 10 | * |
Andrey Andreev | bdb96ca | 2014-10-28 00:13:31 +0200 | [diff] [blame] | 11 | * Permission is hereby granted, free of charge, to any person obtaining a copy |
| 12 | * of this software and associated documentation files (the "Software"), to deal |
| 13 | * in the Software without restriction, including without limitation the rights |
| 14 | * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell |
| 15 | * copies of the Software, and to permit persons to whom the Software is |
| 16 | * furnished to do so, subject to the following conditions: |
Derek Jones | f4a4bd8 | 2011-10-20 12:18:42 -0500 | [diff] [blame] | 17 | * |
Andrey Andreev | bdb96ca | 2014-10-28 00:13:31 +0200 | [diff] [blame] | 18 | * The above copyright notice and this permission notice shall be included in |
| 19 | * all copies or substantial portions of the Software. |
| 20 | * |
| 21 | * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR |
| 22 | * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, |
| 23 | * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE |
| 24 | * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER |
| 25 | * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, |
| 26 | * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN |
| 27 | * THE SOFTWARE. |
| 28 | * |
| 29 | * @package CodeIgniter |
| 30 | * @author EllisLab Dev Team |
darwinel | 871754a | 2014-02-11 17:34:57 +0100 | [diff] [blame] | 31 | * @copyright Copyright (c) 2008 - 2014, EllisLab, Inc. (http://ellislab.com/) |
Andrey Andreev | fe9309d | 2015-01-09 17:48:58 +0200 | [diff] [blame^] | 32 | * @copyright Copyright (c) 2014 - 2015, British Columbia Institute of Technology (http://bcit.ca/) |
Andrey Andreev | bdb96ca | 2014-10-28 00:13:31 +0200 | [diff] [blame] | 33 | * @license http://opensource.org/licenses/MIT MIT License |
| 34 | * @link http://codeigniter.com |
| 35 | * @since Version 1.0.0 |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 36 | * @filesource |
| 37 | */ |
Andrey Andreev | c5536aa | 2012-11-01 17:33:58 +0200 | [diff] [blame] | 38 | defined('BASEPATH') OR exit('No direct script access allowed'); |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 39 | |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 40 | /** |
| 41 | * Initialize the database |
| 42 | * |
| 43 | * @category Database |
Andrey Andreev | 7554611 | 2012-07-05 11:01:29 +0300 | [diff] [blame] | 44 | * @author EllisLab Dev Team |
| 45 | * @link http://codeigniter.com/user_guide/database/ |
Andrey Andreev | ae85eb4 | 2012-11-02 01:42:31 +0200 | [diff] [blame] | 46 | * |
| 47 | * @param string|string[] $params |
| 48 | * @param bool $query_builder_override |
| 49 | * Determines if query builder should be used or not |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 50 | */ |
Jamie Rumbelow | 7efad20 | 2012-02-19 12:37:00 +0000 | [diff] [blame] | 51 | function &DB($params = '', $query_builder_override = NULL) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 52 | { |
| 53 | // Load the DB config file if a DSN string wasn't passed |
Andrey Andreev | c2697db | 2012-03-26 13:05:24 +0300 | [diff] [blame] | 54 | if (is_string($params) && strpos($params, '://') === FALSE) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 55 | { |
Phil Sturgeon | 05fa611 | 2011-04-06 22:57:43 +0100 | [diff] [blame] | 56 | // Is the config file in the environment folder? |
Andrey Andreev | db529ca | 2013-01-28 11:00:02 +0200 | [diff] [blame] | 57 | if ( ! file_exists($file_path = APPPATH.'config/'.ENVIRONMENT.'/database.php') |
Andrey Andreev | c2697db | 2012-03-26 13:05:24 +0300 | [diff] [blame] | 58 | && ! file_exists($file_path = APPPATH.'config/database.php')) |
joelcox | e3da428 | 2011-01-16 15:00:04 +0100 | [diff] [blame] | 59 | { |
Andrey Andreev | 24276a3 | 2012-01-08 02:44:38 +0200 | [diff] [blame] | 60 | show_error('The configuration file database.php does not exist.'); |
joelcox | e3da428 | 2011-01-16 15:00:04 +0100 | [diff] [blame] | 61 | } |
David Behler | 07b5342 | 2011-08-15 00:25:06 +0200 | [diff] [blame] | 62 | |
joelcox | e3da428 | 2011-01-16 15:00:04 +0100 | [diff] [blame] | 63 | include($file_path); |
vkeranov | d008c97 | 2012-11-12 14:29:49 +0200 | [diff] [blame] | 64 | // Make packages contain database config files |
| 65 | foreach (get_instance()->load->get_package_paths() as $path) |
Rene Brokholm | f5a8530 | 2012-07-05 09:05:32 +0200 | [diff] [blame] | 66 | { |
| 67 | if ($path !== APPPATH) |
| 68 | { |
vkeranov | d008c97 | 2012-11-12 14:29:49 +0200 | [diff] [blame] | 69 | if (file_exists($file_path = $path.'config/'.ENVIRONMENT.'/database.php')) |
Rene Brokholm | f5a8530 | 2012-07-05 09:05:32 +0200 | [diff] [blame] | 70 | { |
vkeranov | d008c97 | 2012-11-12 14:29:49 +0200 | [diff] [blame] | 71 | include($file_path); |
Rene Brokholm | f5a8530 | 2012-07-05 09:05:32 +0200 | [diff] [blame] | 72 | } |
vkeranov | d008c97 | 2012-11-12 14:29:49 +0200 | [diff] [blame] | 73 | elseif (file_exists($file_path = $path.'config/database.php')) |
Rene Brokholm | f5a8530 | 2012-07-05 09:05:32 +0200 | [diff] [blame] | 74 | { |
vkeranov | d008c97 | 2012-11-12 14:29:49 +0200 | [diff] [blame] | 75 | include($file_path); |
Rene Brokholm | f5a8530 | 2012-07-05 09:05:32 +0200 | [diff] [blame] | 76 | } |
| 77 | } |
| 78 | } |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 79 | |
Andrey Andreev | 24276a3 | 2012-01-08 02:44:38 +0200 | [diff] [blame] | 80 | if ( ! isset($db) OR count($db) === 0) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 81 | { |
| 82 | show_error('No database connection settings were found in the database config file.'); |
| 83 | } |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 84 | |
Alex Bilbie | 48a2baf | 2012-06-02 11:09:54 +0100 | [diff] [blame] | 85 | if ($params !== '') |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 86 | { |
| 87 | $active_group = $params; |
| 88 | } |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 89 | |
Andrey Andreev | f46b16b | 2013-07-18 19:36:24 +0300 | [diff] [blame] | 90 | if ( ! isset($active_group)) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 91 | { |
Andrey Andreev | f46b16b | 2013-07-18 19:36:24 +0300 | [diff] [blame] | 92 | show_error('You have not specified a database connection group via $active_group in your config/database.php file.'); |
| 93 | } |
| 94 | elseif ( ! isset($db[$active_group])) |
| 95 | { |
| 96 | show_error('You have specified an invalid database connection group ('.$active_group.') in your config/database.php file.'); |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 97 | } |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 98 | |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 99 | $params = $db[$active_group]; |
| 100 | } |
| 101 | elseif (is_string($params)) |
| 102 | { |
vkeranov | d008c97 | 2012-11-12 14:29:49 +0200 | [diff] [blame] | 103 | /** |
| 104 | * Parse the URL from the DSN string |
| 105 | * Database settings can be passed as discreet |
| 106 | * parameters or as a data source name in the first |
| 107 | * parameter. DSNs must have this prototype: |
| 108 | * $dsn = 'driver://username:password@hostname/database'; |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 109 | */ |
Andrey Andreev | c2697db | 2012-03-26 13:05:24 +0300 | [diff] [blame] | 110 | if (($dsn = @parse_url($params)) === FALSE) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 111 | { |
| 112 | show_error('Invalid DB Connection String'); |
| 113 | } |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 114 | |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 115 | $params = array( |
Andrey Andreev | 7e96351 | 2014-02-27 15:43:24 +0200 | [diff] [blame] | 116 | 'dbdriver' => $dsn['scheme'], |
| 117 | 'hostname' => isset($dsn['host']) ? rawurldecode($dsn['host']) : '', |
| 118 | 'port' => isset($dsn['port']) ? rawurldecode($dsn['port']) : '', |
| 119 | 'username' => isset($dsn['user']) ? rawurldecode($dsn['user']) : '', |
| 120 | 'password' => isset($dsn['pass']) ? rawurldecode($dsn['pass']) : '', |
| 121 | 'database' => isset($dsn['path']) ? rawurldecode(substr($dsn['path'], 1)) : '' |
| 122 | ); |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 123 | |
vkeranov | d008c97 | 2012-11-12 14:29:49 +0200 | [diff] [blame] | 124 | // Were additional config items set? |
Andrey Andreev | c2697db | 2012-03-26 13:05:24 +0300 | [diff] [blame] | 125 | if (isset($dsn['query'])) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 126 | { |
Andrey Andreev | c2697db | 2012-03-26 13:05:24 +0300 | [diff] [blame] | 127 | parse_str($dsn['query'], $extra); |
Taufan Aditya | ee2f5d0 | 2012-03-30 06:29:11 +0700 | [diff] [blame] | 128 | |
Pascal Kriete | c3a4a8d | 2011-02-14 13:40:08 -0500 | [diff] [blame] | 129 | foreach ($extra as $key => $val) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 130 | { |
Taufan Aditya | ee2f5d0 | 2012-03-30 06:29:11 +0700 | [diff] [blame] | 131 | if (is_string($val) && in_array(strtoupper($val), array('TRUE', 'FALSE', 'NULL'))) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 132 | { |
Taufan Aditya | ee2f5d0 | 2012-03-30 06:29:11 +0700 | [diff] [blame] | 133 | $val = var_export($val); |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 134 | } |
| 135 | |
| 136 | $params[$key] = $val; |
| 137 | } |
| 138 | } |
| 139 | } |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 140 | |
Andrey Andreev | 24276a3 | 2012-01-08 02:44:38 +0200 | [diff] [blame] | 141 | // No DB specified yet? Beat them senseless... |
Andrey Andreev | e4c3019 | 2012-06-04 15:08:24 +0300 | [diff] [blame] | 142 | if (empty($params['dbdriver'])) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 143 | { |
| 144 | show_error('You have not selected a database type to connect to.'); |
| 145 | } |
| 146 | |
Jamie Rumbelow | 7efad20 | 2012-02-19 12:37:00 +0000 | [diff] [blame] | 147 | // Load the DB classes. Note: Since the query builder class is optional |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 148 | // we need to dynamically create a class that extends proper parent class |
Jamie Rumbelow | 7efad20 | 2012-02-19 12:37:00 +0000 | [diff] [blame] | 149 | // based on whether we're using the query builder class or not. |
| 150 | if ($query_builder_override !== NULL) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 151 | { |
Jamie Rumbelow | 7efad20 | 2012-02-19 12:37:00 +0000 | [diff] [blame] | 152 | $query_builder = $query_builder_override; |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 153 | } |
Andrey Andreev | d45f950 | 2012-05-24 19:31:39 +0300 | [diff] [blame] | 154 | // Backwards compatibility work-around for keeping the |
| 155 | // $active_record config variable working. Should be |
| 156 | // removed in v3.1 |
| 157 | elseif ( ! isset($query_builder) && isset($active_record)) |
| 158 | { |
| 159 | $query_builder = $active_record; |
| 160 | } |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 161 | |
Greg Aker | 3a74665 | 2011-04-19 10:59:47 -0500 | [diff] [blame] | 162 | require_once(BASEPATH.'database/DB_driver.php'); |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 163 | |
Alex Bilbie | 48a2baf | 2012-06-02 11:09:54 +0100 | [diff] [blame] | 164 | if ( ! isset($query_builder) OR $query_builder === TRUE) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 165 | { |
Jamie Rumbelow | 7efad20 | 2012-02-19 12:37:00 +0000 | [diff] [blame] | 166 | require_once(BASEPATH.'database/DB_query_builder.php'); |
Andrey Andreev | 49e68de | 2013-02-21 16:30:55 +0200 | [diff] [blame] | 167 | if ( ! class_exists('CI_DB', FALSE)) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 168 | { |
Andrey Andreev | ae85eb4 | 2012-11-02 01:42:31 +0200 | [diff] [blame] | 169 | /** |
| 170 | * CI_DB |
| 171 | * |
| 172 | * Acts as an alias for both CI_DB_driver and CI_DB_query_builder. |
| 173 | * |
| 174 | * @see CI_DB_query_builder |
| 175 | * @see CI_DB_driver |
| 176 | */ |
Jamie Rumbelow | 7efad20 | 2012-02-19 12:37:00 +0000 | [diff] [blame] | 177 | class CI_DB extends CI_DB_query_builder { } |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 178 | } |
| 179 | } |
Andrey Andreev | 49e68de | 2013-02-21 16:30:55 +0200 | [diff] [blame] | 180 | elseif ( ! class_exists('CI_DB', FALSE)) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 181 | { |
Andrey Andreev | ae85eb4 | 2012-11-02 01:42:31 +0200 | [diff] [blame] | 182 | /** |
| 183 | * @ignore |
| 184 | */ |
Andrey Andreev | 24276a3 | 2012-01-08 02:44:38 +0200 | [diff] [blame] | 185 | class CI_DB extends CI_DB_driver { } |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 186 | } |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 187 | |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 188 | // Load the DB driver |
| 189 | $driver_file = BASEPATH.'database/drivers/'.$params['dbdriver'].'/'.$params['dbdriver'].'_driver.php'; |
| 190 | |
Andrey Andreev | 7e96351 | 2014-02-27 15:43:24 +0200 | [diff] [blame] | 191 | file_exists($driver_file) OR show_error('Invalid DB driver'); |
Taufan Aditya | a8a2e33 | 2012-03-29 03:56:46 +0700 | [diff] [blame] | 192 | require_once($driver_file); |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 193 | |
| 194 | // Instantiate the DB adapter |
| 195 | $driver = 'CI_DB_'.$params['dbdriver'].'_driver'; |
Pascal Kriete | 5856002 | 2010-11-10 16:01:20 -0500 | [diff] [blame] | 196 | $DB = new $driver($params); |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 197 | |
Andrey Andreev | 3345ee5 | 2012-06-23 20:51:47 +0300 | [diff] [blame] | 198 | // Check for a subdriver |
Andrey Andreev | 754e221 | 2012-06-23 20:54:06 +0300 | [diff] [blame] | 199 | if ( ! empty($DB->subdriver)) |
Andrey Andreev | 3345ee5 | 2012-06-23 20:51:47 +0300 | [diff] [blame] | 200 | { |
Andrey Andreev | 4410777 | 2012-06-25 18:38:34 +0300 | [diff] [blame] | 201 | $driver_file = BASEPATH.'database/drivers/'.$DB->dbdriver.'/subdrivers/'.$DB->dbdriver.'_'.$DB->subdriver.'_driver.php'; |
Andrey Andreev | 3345ee5 | 2012-06-23 20:51:47 +0300 | [diff] [blame] | 202 | |
| 203 | if (file_exists($driver_file)) |
| 204 | { |
| 205 | require_once($driver_file); |
Andrey Andreev | 4410777 | 2012-06-25 18:38:34 +0300 | [diff] [blame] | 206 | $driver = 'CI_DB_'.$DB->dbdriver.'_'.$DB->subdriver.'_driver'; |
Andrey Andreev | 3345ee5 | 2012-06-23 20:51:47 +0300 | [diff] [blame] | 207 | $DB = new $driver($params); |
| 208 | } |
| 209 | } |
| 210 | |
Alex Bilbie | 48a2baf | 2012-06-02 11:09:54 +0100 | [diff] [blame] | 211 | if ($DB->autoinit === TRUE) |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 212 | { |
| 213 | $DB->initialize(); |
| 214 | } |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 215 | |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 216 | return $DB; |
Barry Mieny | dd67197 | 2010-10-04 16:33:58 +0200 | [diff] [blame] | 217 | } |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 218 | |
Derek Allard | 2067d1a | 2008-11-13 22:59:24 +0000 | [diff] [blame] | 219 | /* End of file DB.php */ |
Andrey Andreev | 7f57a01 | 2012-05-24 18:40:50 +0300 | [diff] [blame] | 220 | /* Location: ./system/database/DB.php */ |