123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 |
- <?php namespace System\DB;
- class Connector {
-
- public static $options = array(
- \PDO::ATTR_CASE => \PDO::CASE_LOWER,
- \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION,
- \PDO::ATTR_ORACLE_NULLS => \PDO::NULL_NATURAL,
- \PDO::ATTR_STRINGIFY_FETCHES => false,
- );
-
- public static function connect($config)
- {
-
-
-
- if ($config->driver == 'sqlite')
- {
-
-
-
-
-
-
- if (file_exists($path = APP_PATH.'db/'.$config->database.'.sqlite'))
- {
- return new \PDO('sqlite:'.$path, null, null, static::$options);
- }
- elseif (file_exists($config->database))
- {
- return new \PDO('sqlite:'.$config->database, null, null, static::$options);
- }
- }
-
-
-
- elseif ($config->driver == 'mysql' or $config->driver == 'pgsql')
- {
- $connection = new \PDO($config->driver.':host='.$config->host.';dbname='.$config->database, $config->username, $config->password, static::$options);
- if (isset($config->charset))
- {
- $connection->prepare("SET NAMES '".$config->charset."'")->execute();
- }
- return $connection;
- }
- throw new \Exception('Database driver '.$config->driver.' is not supported.');
- }
- }
|