我用的是XP,PHP版本是5.2.6,MSSQL版本是2005版。<?php
$ser="LENOVO-D713F2AD";
$user="test";
$pass="123456789";
//$con=mssql_connect("LENOVO-D713F2AD","test","123456789");
$con=mssql_connect($ser,$user,$pass);
echo $con;
if(!$con)
echo "<br/>连接成功";
else
echo "连接失败";
echo "<br/>又一次测试";//前面运行后显示成功,但后面的不显示,看了网上很多信息,感觉我的PHP.ini文件中的配置没有问题$dbname = mssql_select_db("AdventureWorks",$con);
// or die("数据库不存在或不可用".mssql_error());
$sql = "select * from person.address";
$result = mssql_query($sql);echo "<table border=1>";
while($row = mssql_fetch_array($result)) //循环输出
{
$address1 = $row[1];
$city = $row[3];
$postalcode = $row[5];
echo "<tr>";
echo "<td>$address1</td>";
echo "<td>$city</td>";
echo "<td>$postalcode</td>";
echo "</tr>";
}
echo "</table>";
?>
$ser="LENOVO-D713F2AD";
$user="test";
$pass="123456789";
//$con=mssql_connect("LENOVO-D713F2AD","test","123456789");
$con=mssql_connect($ser,$user,$pass);
echo $con;
if(!$con)
echo "<br/>连接成功";
else
echo "连接失败";
echo "<br/>又一次测试";//前面运行后显示成功,但后面的不显示,看了网上很多信息,感觉我的PHP.ini文件中的配置没有问题$dbname = mssql_select_db("AdventureWorks",$con);
// or die("数据库不存在或不可用".mssql_error());
$sql = "select * from person.address";
$result = mssql_query($sql);echo "<table border=1>";
while($row = mssql_fetch_array($result)) //循环输出
{
$address1 = $row[1];
$city = $row[3];
$postalcode = $row[5];
echo "<tr>";
echo "<td>$address1</td>";
echo "<td>$city</td>";
echo "<td>$postalcode</td>";
echo "</tr>";
}
echo "</table>";
?>
echo " <br/>连接成功";
!$con是成功吗?
person.address 是什么意思?
$sql = "select * from person";
或者
$sql = "select * from address"; 试试
echo('连接成功');
mssql_select_db("AdventureWorks") or die("数据库不存在或不可用");
echo('选择数据库成功');
$sql = "select * from person.address";
$result = mssql_query($sql);
……看看输出是什么
看看数据库名,跟表名有没有错
echo('选择数据库成功")
这样写比较好一点
$dbname = mssql_select_db("AdventureWorks",$con) or die("数据库不存在或不可用");$sql = "select * from person.address"; // 表名没有这样写的!
$result = mssql_query($sql);
persion是数据库名的话就错误的。我假设下address表是someone这个人创建的吧
那么 "select * from AdventureWorks.someone.address"或者"select * from someone.address"都行,但是确认下 你的persion是创建者。
当然你上面的if(!conn)也错了
另外,如果你的查询是写在一个存储过程内部的话 记得commit,不然没数据。
$ser="LENOVO-D713F2AD";
$user="test";
$pass="123456789";
$my_data="AdventureWorks";
$con=mssql_connect($ser,$user,$pass)or die("Couldn't connect to SQL Server on $ser");
$dbname = mssql_select_db($my_data,$con)or die("Couldn't open database $dbname");
$sql = "select * from person.address";
$result = mssql_query($sql);
echo "<table border=1>";
while($row = mssql_fetch_array($result)) //循环输出
{
$address1 = $row[1];
$city = $row[3];
$postalcode = $row[5];
echo "<tr>";
echo "<td>$address1</td>";
echo "<td>$city</td>";
echo "<td>$postalcode</td>";
echo "</tr>";
}
echo "</table>";
?>
$ser="LENOVO-D713F2AD";//这里换成ip地址试试
$user="test";
$pass="123456789";
$my_data="AdventureWorks";
$con=mssql_connect($ser,$user,$pass)or die("Couldn't connect to SQL Server on $ser");
$dbname = mssql_select_db($my_data,$con)or die("Couldn't open database $dbname");
$sql = "select * from person.address";
$result = mssql_query($sql);
echo "<table border=1>";
while($row = mssql_fetch_array($result)) //循环输出
{
$address1 = $row[1];
$city = $row[3];
$postalcode = $row[5];
echo "<tr>";
echo "<td>$address1</td>";
echo "<td>$city</td>";
echo "<td>$postalcode</td>";
echo "</tr>";
}
echo "</table>";
?>