Shulou(Shulou.com)06/02 Report--

This article shows you how to connect to the sql server database in php. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

1. Environment

Phpstudy

VS Code

Php7.3.4nts

Note: nts > > Thread unsafe ts > > Thread Safety

two。 Download and configure connection sql server needs to download something

Download SQLSRV58.EXE [1] this thing does not need to be installed, after decompression is such a bunch of things: the above things should be chosen according to their own environment, please read on.

Send a php script to your local site to take a look at the message. (use phpstudy to build a station)

This is my environment. So for my sqlsrv, I have to choose 7.3 sqlsrv. Note: choose your own version, and if you don't have it in sqlsrv58, download another version of NTS. Copy these two things to the corresponding php version folder. Then add the following to php.ini

Extension=php_sqlsrv_73_nts_x64extension=php_pdo_sqlsrv_73_nts_x64

3. Connection test

1. Restart apache

The above content is how to connect to the sql server database in php. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.