splitOptions($driverOptions); return new Connection( $this->_constructPdoDsn($params, $connectionOptions), $username, $password, $driverOptions ); } /** * Constructs the Sqlsrv PDO DSN. * * @param mixed[] $params * @param string[] $connectionOptions * * @return string The DSN. */ private function _constructPdoDsn(array $params, array $connectionOptions) { $dsn = 'sqlsrv:server='; if (isset($params['host'])) { $dsn .= $params['host']; } if (isset($params['port']) && ! empty($params['port'])) { $dsn .= ',' . $params['port']; } if (isset($params['dbname'])) { $connectionOptions['Database'] = $params['dbname']; } if (isset($params['MultipleActiveResultSets'])) { $connectionOptions['MultipleActiveResultSets'] = $params['MultipleActiveResultSets'] ? 'true' : 'false'; } return $dsn . $this->getConnectionOptionsDsn($connectionOptions); } /** * Separates a connection options from a driver options * * @param int[]|string[] $options * * @return int[][]|string[][] */ private function splitOptions(array $options) : array { $driverOptions = []; $connectionOptions = []; foreach ($options as $optionKey => $optionValue) { if (is_int($optionKey)) { $driverOptions[$optionKey] = $optionValue; } else { $connectionOptions[$optionKey] = $optionValue; } } return [$driverOptions, $connectionOptions]; } /** * Converts a connection options array to the DSN * * @param string[] $connectionOptions */ private function getConnectionOptionsDsn(array $connectionOptions) : string { $connectionOptionsDsn = ''; foreach ($connectionOptions as $paramName => $paramValue) { $connectionOptionsDsn .= sprintf(';%s=%s', $paramName, $paramValue); } return $connectionOptionsDsn; } /** * {@inheritdoc} */ public function getName() { return 'pdo_sqlsrv'; } }