用php7.1 连接sqlserver2008r2 如何测试成功并做简单查询,代码怎么写。
举例
$host = '11.11.11.6,3000';
$user = 'abc';
$password = '123456';
$dbname = 'kk';
表里面有两个字段 一个是a 一个是b 就是根据a查询出a=1对应的b内容
<?phpheader("Content-type: text/html; charset=utf-8");
$serverName = "192.168.0.1"; //数据库服务器地址
$uid = "site_user"; //数据库用户名
$pwd = "zkJ1246g"; //数据库密码
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"db_site");
$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);
}?>