php如何与 mssql连接
php如何与 mssql连接
在php wadhwahitesh的windows,ms sql server的,php脚本语言,php和
标签:php中,mssql,wamp的
我已经成功连接的mssql使用php,但是我得到下列警告和系统死亡。请让我知道这个问题尽快解决。谢谢
warning: mssql_query(): supplied argument is not a valid ms sql-link resource in c:wampwwwtestsql2005index. on line 11
warning: mssql_fetch_array(): supplied argument is not a valid ms sql-result resource in c:wampwwwtestsql2005index.php on line 12
line 11 : $qry = mssql_query($sql1,$dblink);
line 12 : while ($row = mssql_fetch_array($qry)){
$server = 'divine-2953ff11,';
$server = 'divine-2953ff11sqlexpress';
$db='';
$dbuser = '';
$dbpass = '';
$link = mssql_connect($server, $dbuser, $dbpass) or die(cannot connect to server);
$dblink = mssql_select_db($db, $link) or die(cannot connect to database);
$sql1 = select firstname from dbo.persons;
$qry = mssql_query($sql1,$dblink);
while ($row = mssql_fetch_array($qry)){
echo $row[firstname];
}
mssql_close($link);