1234567891011121314151617181920212223242526272829303132333435363738 |
- <?php namespace Laravel\Database\Connectors; use PDO;
- class SQLServer extends Connector {
- /**
- * The PDO connection options.
- *
- * @var array
- */
- protected $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,
- );
- /**
- * Establish a PDO database connection.
- *
- * @param array $config
- * @return PDO
- */
- public function connect($config)
- {
- extract($config);
- // Format the SQL Server connection string. This connection string format can
- // also be used to connect to Azure SQL Server databases. The port is defined
- // directly after the server name, so we'll create that and then create the
- // final DSN string to pass to PDO.
- $port = (isset($port)) ? ','.$port : '';
- $dsn = "sqlsrv:Server={$host}{$port};Database={$database}";
- return new PDO($dsn, $username, $password, $this->options($config));
- }
- }
|