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

In this issue, Xiaobian will bring you about how to use thinkPHP3.2.3 to connect sqlserver. The article is rich in content and analyzes and narrates from a professional perspective. After reading this article, I hope you can gain something.

php configuration load open php.ini search extension add the following please see the location of php.ini

extension=php_pdo_sqlsrv_55_nts.dllextension=php_pdo_sqlsrv_55_ts.dllextension=php_sqlsrv_55_nts.dllextension=php_sqlsrv_55_ts.dll

Restart the service. If you don't restart it, you should be able to identify it.

Use phpinfo() function to check whether it is loaded

Here are screenshots of success

Then write a TP 3.2.3 directly for testing.

public function abc(){ $User = M('info','dbo. ','sqlsrv://sa:jkll1234@XXX-PC\MSSQL/xxx'); $s = $User ->select(); dump($s); }

database table presentation

Visit: http://localhost:8080/index.php/Home/Category/abc.html

The above is how to use thinkPHP3.2.3 to connect sqlserver, if there is a similar doubt, may wish to refer to the above analysis to understand. If you want to know more about it, please pay attention to 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.