搜索 |
<?php
header("Content-type: text/html; charset=utf8");
$serverName = "连接地址\sqlexpress, 2400"; //数据库服务器地址
$uid = "*******"; //数据库用户名
$pwd = "*********"; //数据库密码
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"xinbangong");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn == false)
{
echo "连接失败!";
die( print_r( sqlsrv_errors(), true));
}
else{
echo "连接成1功";
}
//执行有结果集的SQL语句
$rs1 = sqlsrv_query($conn,"SELECT TOP (5) [user], pawd, name, born, factory, department
FROM Users");
while($r1 =sqlsrv_fetch_array($rs1)) {
echo $r1[user].$r1[pawd];
}
?>
如果数据库中有中文表名,解决方法如下: