Teach you step by step how to quickly connect to SqlServer using PHP

This article will introduce to you the issues related to PHP connecting to SqlServer. Even a novice can easily understand it! The following will give you a detailed introduction to the specific steps of connecting SqlServer with PHP. I hope it will be helpful to friends in need~

PHP Connecting with SqlServer

1. Download

1. SqlServer ODBC Driver

(1) Check the SqlServer database version supported by the SqlServer ODBC Driver

https://docs.microsoft.com/en-us/sql/connect/odbc/windows/system-requirements-installation-and-driver-files?view=sql-server-ver16

(2), download SqlServer ODBC Driver

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

2, php_sqlsrv.dll and php_pdo_sqlsrv.dll extensions

(1), check the PHP extension version supported by the SqlServer ODBC Driver driver

https://docs.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver?redirectedfrom=MSDN&view=sql-server-ver16

(2), php_pdo_sqlsrv.dll

Download address: pecl.php.net/package/pdo_sqlsrv

(3), php_sqlsrv.dll

Download address: pecl .php.net/package/sqlsrv

[Recommended learning: PHP video tutorial]

2. Configuration

1 , copy these two dlls to the ext directory of php

2, and then add the following code at the bottom of php.ini

extension=php_pdo_sqlsrv.dll
extension=php_sqlsrv.dll

After configuration, restart apache or nginx server

3. Test

1. Create the index.php file in the localhost directory and write the following content

<?php
echo phpinfo();

2. Open the browser and visit localhost, you will see the interface output by phpinfo

Then search for sqlsrv and pdo_sqlsrv. If they can be found, it means that the sqlserver extension is installed successfully

The above is the detailed content of Teach you step by step how to quickly connect to SqlServer using PHP. For more information, please follow other related articles on the PHP Chinese website!