php下使用以下代码连接并测试
2015-01-24信息快讯网
php连接mysql数据库效果
<?php $myServer = "localhost"; //主机 $myUser = "sa"; //用户名 $myPass = "password"; //密码 $myDB = "Northwind";? //MSSQL库名 $s = @mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); $d = @mssql_select_db($myDB, $s) or die("Couldn't open database $myDB"); $query = "SELECT TitleOfCourtesy+' '+FirstName+' '+LastName AS Employee "; $query .= "FROM Employees "; $query .= "WHERE Country='USA' AND Left(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>"; }