PHP sqlserver 扩展下载地址:https://www.microsoft.com/en-us/download/details.aspx?id=20098
用于php连接微软数据库mssql。
php连接mssql测试代码如下:
实例
<?php header("Content-type: text/html; charset=utf-8"); $serverName = "localhost"; //数据库服务器地址 $uid = "foodcert"; //数据库用户名 $pwd = "foodcert"; //数据库密码 $connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"FoodCert"); $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn == false) { echo "连接失败!"; die( print_r( sqlsrv_errors(), true)); }else{ echo "连接成功!"; } $query = sqlsrv_query($conn, "select * from 数据库表"); while($row = sqlsrv_fetch_array($query)) { print_r($row); } ?>
运行实例 »
点击 "运行实例" 按钮查看在线实例