PHP Function SQLSRVConnect

The php function sqlsrv_connect is an API function for connecting to a Microsoft SQL Server database using the sqlsrv driver. It is an alternative to the mssql drivers that were deprecated in PHP 5.3. The sqlsrv driver requires the Microsoft SQL Server Native Client be installed on your server, which is not included by default in the PHP package.

The sqlsrv_connect function accepts an associative array of key/value pairs that configure connection options. These are used to set the default database (USE dbName), authentication method and other connection properties. The SQLSRV driver also supports connection pooling which can improve performance by allowing multiple connections to be established and shared amongst scripts. To enable it, include 'UID' and 'PWD' in the $connectionOptions array.

Unlike the mssql functions, sqlsrv_connect does not require that you use double quotation marks around your SQL strings. However, it is recommended that you do so for clarity and to avoid potential security vulnerabilities.

Note: sqlsrv_connect() can be called either with or without the 'use' argument, depending on your needs. If the 'use' argument is not used, a new SQLSRV connection will be created for each call to the function. If it is, the current SQLSRV connection will be used for all subsequent queries.

This extension is only available in PHP versions up to 5.3 and has reached EOL. The EasyApache 4 distribution does not support this extension anymore and we recommend you to install the pdo_sqlsrv or pdo_odbc extensions instead.

Andreas Behr - CTO of DesertCoderz
You are a developer and looking for Shopware projects?
Apply Now!

sqlsrv_connect example

// If the username and password are both empty, assume this is a         // 'Windows Authentication Mode' connection.         if (empty($connection['UID']) && empty($connection['PWD'])) {
            unset($connection['UID'], $connection['PWD']);
        }

        if (strpos($this->hostname, ',') === false && $this->port !== '') {
            $this->hostname .= ', ' . $this->port;
        }

        sqlsrv_configure('WarningsReturnAsErrors', 0);
        $this->connID = sqlsrv_connect($this->hostname, $connection);

        if ($this->connID !== false) {
            // Determine how identifiers are escaped             $query = $this->query('SELECT CASE WHEN (@@OPTIONS | 256) = @@OPTIONS THEN 1 ELSE 0 END AS qi');
            $query = $query->getResultObject();

            $this->_quoted_identifier = empty($query) ? false : (bool) $query[0]->qi;
            $this->escapeChar         = ($this->_quoted_identifier) ? '"' : ['[', ']'];

            return $this->connID;
        }

        
Home | Imprint | This part of the site doesn't use cookies.