复制代码 代码如下:
<?php
$myServer="localhost";//主机
$myUser="sa";//用户名
$myPass="password";//密码
$myDB="Northwind";?//MSSQL库名
$s=@mssql_connect($myServer,$myUser,$myPass)
ordie("Couldn'tconnecttoSQLServeron$myServer");
$d=@mssql_select_db($myDB,$s)
ordie("Couldn'topendatabase$myDB");
$query="SELECTTitleOfCourtesy+''+FirstName+''+LastNameASEmployee";
$query.="FROMEmployees";
$query.="WHERECountry='USA'ANDLeft(HomePhone,5)='(206)'";
$result=mssql_query($query);
$numRows=mssql_num_rows($result);
echo"<h1>".$numRows."Row".($numRows==1?"":"s")."Returned</h1>";
while($row=mssql_fetch_array($result))
{
echo"<li>".$row["Employee"]."</li>";
}
网站建设 IT知识 IT知识教程 php下使用以下代码连接并测试 
最新文章
热门文章
猜你喜欢
