How to Replace Deprecated MSSQL with SQLSRV Extension in PHP?

Getting SQLSRV Extension Working with PHP: An Alternate to Deprecated MSSQL

The removal of mssql support in PHP 5.3 has prompted many users to seek alternatives. One such option is the SQLSRV extension from Microsoft. Here's a comprehensive guide to get SQLSRV working with your PHP installation:

• Download the SQLSRV Drivers:

  • Visit the Microsoft SQLSRV driver download page and choose the driver file compatible with your PHP version, compiler, and thread-safety requirements.

• Extract and Place the Files:

  • Extract the downloaded driver file and copy it to your PHP extension directory (e.g., ext in Linux or php_extension in Windows).

• Edit php.ini:

  • Open your php.ini file and add the following line at the end:

    extension=php_sqlsrv_53_nts_vc9.dll  (for PHP 5.3, non-thread-safe, VC9 compiler)

• Restart Web Server:

  • For Windows users, restart the web server (e.g., IIS).

Additional Notes:

• For other PHP versions and settings, refer to the official Microsoft documentation for specific driver file names.
• SQLSRV can also be used with PDO, providing database abstraction.
• The PHP manual offers detailed instructions for installation and usage of the SQLSRV extension.
• System requirements, getting started guide, programming guide, and API reference can be found on the Microsoft Drivers for PHP for SQL Server page.

The above is the detailed content of How to Replace Deprecated MSSQL with SQLSRV Extension in PHP?. For more information, please follow other related articles on the PHP Chinese website!