PHP Function SQLSRV_Close

Article about php function sqlsrv_close

The php sqlsrv_close() function closes the mysqli class object used to create and open a database connection. The mysqli class is used to connect to a Microsoft SQL Server database using the SQLSRV driver. It replaces the mssql functions of earlier versions of PHP with better error handling and support for a wider range of SQL Server configuration settings.

SQLSRV is a free and open source database interface for PHP. The library is based on the Microsoft SQL Server ODBC API and supports native Microsoft SQL Server connections and SQLSRV-specific features such as field property metadata and row-level locking.

The SQLSRV library is available in the PHP 5.3 and up distribution. It requires the Microsoft SQL Server ODBC driver to be installed on the machine hosting PHP.

This article explains how to use the php function sqlsrv_close() in a script.

sqlsrv_begin_transaction() - Begin a transaction on the current connection. This is only required if the transaction is a result of an INSERT or UPDATE query executed in transaction mode. This function should be called together with sqlsrv_commit() and sqlsrv_rollback() to commit or roll back the transaction respectively.

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

sqlsrv_close example

public function reconnect()
    {
        $this->close();
        $this->initialize();
    }

    /** * Close the database connection. */
    protected function _close()
    {
        sqlsrv_close($this->connID);
    }

    /** * Platform-dependant string escape */
    protected function _escapeString(string $str): string
    {
        return str_replace("'", "''", remove_invisible_characters($str, false));
    }

    /** * Insert ID */
Home | Imprint | This part of the site doesn't use cookies.