windowsxp,php5.总提示连接出错
php.ini文件里也配置了extension=php_mssql.dll
<?php
$myServer = "(local)";
$myUser = "php";
$myPass = "php";
$myDB = "wstmain";
$conn = mssql_connect("$myServer", "$myUser", "$myPass") or die("<br>数据库连接错误<br>");
$is = mssql_select_db("$myDB", $conn) or die("<br>选择数据库错误<br>");
$query = "select getdate()";
$row = mssql_query("$query") or die("<br>query error!<br>");
while ($r = mssql_fetch_array($row)) {
echo $r[0];
} mssql_close($conn);
?>
php.ini文件里也配置了extension=php_mssql.dll
<?php
$myServer = "(local)";
$myUser = "php";
$myPass = "php";
$myDB = "wstmain";
$conn = mssql_connect("$myServer", "$myUser", "$myPass") or die("<br>数据库连接错误<br>");
$is = mssql_select_db("$myDB", $conn) or die("<br>选择数据库错误<br>");
$query = "select getdate()";
$row = mssql_query("$query") or die("<br>query error!<br>");
while ($r = mssql_fetch_array($row)) {
echo $r[0];
} mssql_close($conn);
?>
另:host最好是 127.0.0.1\实体名建议使用PDO去连接.http://cn.php.net/manual/en/ref.pdo-dblib.php#86668
我正在遇到这个情况。 推荐使用ADOdb库,可以用google搜索一下即可。另有一篇文章推荐,关于PHP的mssql的:http://ardar.5drc.com/channel/index.php?mod=art&artid=338&sortid=40