php 连接sqlserver
<p><strong><span style="font-family: 宋体; font-size: 14pt">1、下载sqlserver扩展</span></strong></p><p> 打开用phpinfo()；查看php版本信息。如下</p>
<div class="cnblogs_Highlighter">
<pre class="brush:php;gutter:true;"><?php
echo phpinfo();
?>
</pre>
</div>
<p> 、</p>
<p><img src="https://img2018.cnblogs.com/blog/1525170/201905/1525170-20190513092805357-1614957280.png"></p>
<p> 这里我使用的php7.2版本，sqlserver扩展的下载链接:https://github.com/Microsoft/msphpsql/releases</p>
<p>官方sqlserver扩展下载链接:https://www.microsoft.com/en-us/download/details.aspx?id=20098</p>
<p>5.x版本的sqlserver扩展下载链接:https://pan.baidu.com/s/1iXuf1ENuAmNy3F8hFAk68Q 提取码:idjm</p>
<p><span style="color: rgba(255, 0, 0, 1)">注意:下载sqlserver扩展是32位和64位不是根据电脑的系统的位数判断的，而是根据php的位数判断的。如上图的第一个红框。</span></p>
<p><strong>2、安装并配置sqlserver扩展</strong></p>
<p><strong> </strong>找到phpinfo()中使用的php版本。如D:\phpStudy\PHPTutorial\php\php-7.2.1-nts\ext，然后把我们下载的sqlserver的扩展复制在这里。如图所示：</p>
<p><img src="https://img2018.cnblogs.com/blog/1525170/201905/1525170-20190513093839775-1762502109.png"></p>
<p>找到php.ini。如图所示</p>
<p><img src="https://img2018.cnblogs.com/blog/1525170/201905/1525170-20190513093932843-1777701163.png"></p>
<div class="cnblogs_Highlighter">
<pre class="brush:php;gutter:true;">extension=php_pdo_sqlsrv_72_nts.dll
extension=php_sqlsrv_72_nts.dll
</pre>
</div>
<p> </p>
<p><img src="https://img2018.cnblogs.com/blog/1525170/201905/1525170-20190513094011948-143084345.png"></p>
<p>重启Apache，重新打开phpinfo();</p>
<p>如出现下图的红框的信息，则表示安装成功；</p>
<p><img src="https://img2018.cnblogs.com/blog/1525170/201905/1525170-20190513094116624-117837359.png"></p>
<p> </p>
<p> 3<strong>、安装msodbcsql.msi</strong></p>
<p>下载链接:https://www.microsoft.com/en-us/download/details.aspx?id=50420</p>
<p><img src="https://img2018.cnblogs.com/blog/1525170/201905/1525170-20190513094451898-791715722.png"></p>
<p><span style="color: rgba(255, 0, 0, 1)">注意:这里的x86与x64是根据电脑系统判断的，不是根据php版本</span></p>
<p><span style="color: rgba(0, 0, 0, 1)">安装过程，一直默认下一步即可。</span></p>
<p> 4<strong>、连接sqlserver</strong></p>
<p><strong> </strong>前提是sqlserver可以外网连接。</p>
<div class="cnblogs_Highlighter">
<p>$conn = sqlsrv_connect('localhost', array('Database' => 'test', 'UID' => 'sa' , 'PWD' => '123456')); </p>
<p> if( $conn == false){<br> var_dump(sqlsrv_errors());exit;<br> }</p>
<p> $sql = "SELECT * FROM users";</p>
<p> $result = @sqlsrv_query($conn, $sql);<br> while ( $re = @sqlsrv_fetch_array($result)) { <br> var_dump($re);<br> }</p>
<p> </p>
</div>
<p> host一般是ip+端口,如ip,1433 。ip与端口之间用,隔开</p>
<p> </p>
<p></audio></p><br><br>
来源：https://www.cnblogs.com/f-rt/p/10855038.html
頁:
[1]