<?php <br><br>$myServer = "localhost"; //主机 <BR>$myUser = "sa"; //用户名 <BR>$myPass = "password"; //密码 <BR>$myDB = "Northwind";? //MSSQL库名 <br><br>$s = @mssql_connect($myServer, $myUser, $myPass) <BR>or die("Couldn't connect to SQL Server on $myServer"); <br><br>$d = @mssql_select_db($myDB, $s) <BR>or die("Couldn't open database $myDB"); <br><br>$query = "SELECT TitleOfCourtesy+' '+FirstName+' '+LastName AS Employee "; <BR>$query .= "FROM Employees "; <div style="color:transparent">本&文来源gaodai^.ma#com搞#代!码网</div><strong>搞gaodaima代码</strong> <BR>$query .= "WHERE Country='USA' AND Left(HomePhone, 5) = '(206)'"; <br><br>$result = mssql_query($query); <BR>$numRows = mssql_num_rows($result); <br><br>echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>"; <br><br>while($row = mssql_fetch_array($result)) <BR>{ <BR>echo "<li>" . $row["Employee"] . "</li>"; <BR>} <br><br><BR>
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：php下使用以下代码连接并测试_php基础
转载请注明原文链接：php下使用以下代码连接并测试_php基础
