Question

php如何连接到SQL SERVER 2000 数据库 总是出错

Answer 1

php.ini中要配置的
extension=php_mssql.dll
前迟纳的‘；’去了吗？
<?php

//(1)打开并选择数据库皮衡

$connection

=mssql_connect(
"sql

server

name
",
"databas

user

name
",
"password
");

mssql_select_db(
"database

name
",$connection);

//(2)通过连接，在database

name上运行查询

$result

=

mssql_query(
"select

*

from

tablename
",connection);

//(3)当有结果集中还码握没有行时

while($row

=

mssql_fetch_row($result))

{

(4)输出行中每个属性

for($i=0;$i

<

mssql_num_fields($result);$i++)

echo

$row[$i]

.

"

";

}

//(5)关闭数据库连接

mssql_close($connection);
?>