Home > Backend Development > PHP Tutorial > Xi'an Railway Vocational and Technical College professional code Use the following code to connect and test under PHP

Xi'an Railway Vocational and Technical College professional code Use the following code to connect and test under PHP

WBOY
Release: 2016-07-29 08:37:51
Original
1504 people have browsed it

复制代码 代码如下:


$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 "

" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned 

";    
while($row = mssql_fetch_array($result))    
{    
echo "
  • " . $row["Employee"] . "
  • ";    
    }     

    以上就介绍了西安铁路职业技术学院专业代码 php下使用以下代码连接并测试,包括了西安铁路职业技术学院专业代码方面的内容,希望对PHP教程有兴趣的朋友有所帮助。

    source:php.cn
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Popular Tutorials
    More>
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template