在php+mssql环境下连接服务器测试成功

在php+mssql环境下测试成功

 

<?php
echo "mssql服务器链接测试.<br>";
$msServer = "lee"; //主机
$msUser = "sa"; //用户名
$msPass = "123456"; //密码
$msDB = "test";  //msSQL库名
mssql_connect($msServer, $msUser, $msPass)
or die("Couldn't connect to SQL Server on $msServer");

 

mssql_select_db("mytest");

 

$query = "SELECT top 3  *  from student order by Sno "; 

 

$result = mssql_query($query);

 

echo "学号\t姓名\t年龄\t性别<br>";
 
while($row=mssql_fetch_array($result))
{ echo "<li>" . $row["Sno"]."\t".$row["Sname"]."\t".$row["Sage"].$row["Ssex"] ."</li>";
}

 

?>

 

在php+mssql环境下测试成功