php 连接 sqlserver 的问题 $Host = "localhost";$User = "123";$Passwd = "123";$db_Name = "tempdb";把这部分放到函数里面吧。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 你那上面的$result变量是从哪得来的呢?把$host改为你的服务的计算机名试试!<?php $Host = "SERVERNAME";$User = "123";$Passwd = "123";$db_Name = "tempdb";function db_connect() //连接数据库{ global $Host,$User,$Passwd,$db_Name; $db = mssql_connect($Host,$User,$Passwd); if(!$db) { echo "无法与数据库连接"; exit; } $db_default = mssql_select_db($db_Name,$db); if(!$db_default) { echo "无法选定$db_Name数据库"; exit; } return $db;}$d=db_connect();$query=mssql_query("SELECT * from sysusers"); $urows=mssql_num_rows($query);echo $urows;?> <?php $Host = "localhost";$User = "123";$Passwd = "123";$db_Name = "tempdb";$db = mssql_connect($Host,$User,$Passwd);$db_default = mssql_select_db($db_Name);?>看看有会有什么提示? 把你的语句改成如下:<?php function db_connect() //连接数据库{ global $Host,$User,$Passwd,$db_Name; $Host = "localhost"; $User = "123"; $Passwd = "123"; $db_Name = "tempdb"; $db = mssql_connect($Host,$User,$Passwd); if(!$db) { echo "无法与数据库连接"; exit; } $db_default = mssql_select_db($db_Name,$db); if(!$db_default) { echo "无法选定$db_Name数据库"; exit; } return $db;}$d = db_connect();$sql = "SELECT * from sysusers "; $result=mssql_Query($sql);$urows = mssql_num_rows($result,$d);echo $urows;?> 关于while循环里为什么数据只显示最后一条呢? 请教 如何将转义字符存入数据库。 求一个最简单的代理代码 求一款开源的门户站 mysql直接执行sql和php中用mysql_query()取得的数据不一样 怎么可获取文本框的值 php.ini文件? 奇怪的问题 祝各位明年少遇到些提变态需求的客户... php是否支持access,paradox数据库 数据转移 HELP ME!
把$host改为你的服务的计算机名试试!
<?php
$Host = "SERVERNAME";
$User = "123";
$Passwd = "123";
$db_Name = "tempdb";
function db_connect() //连接数据库
{
global $Host,$User,$Passwd,$db_Name;
$db = mssql_connect($Host,$User,$Passwd);
if(!$db)
{
echo "无法与数据库连接";
exit;
}
$db_default = mssql_select_db($db_Name,$db);
if(!$db_default)
{
echo "无法选定$db_Name数据库";
exit;
}
return $db;
}
$d=db_connect();
$query=mssql_query("SELECT * from sysusers");
$urows=mssql_num_rows($query);
echo $urows;
?>
$Host = "localhost";
$User = "123";
$Passwd = "123";
$db_Name = "tempdb";
$db = mssql_connect($Host,$User,$Passwd);
$db_default = mssql_select_db($db_Name);
?>
看看有会有什么提示?
<?php function db_connect() //连接数据库
{
global $Host,$User,$Passwd,$db_Name;
$Host = "localhost";
$User = "123";
$Passwd = "123";
$db_Name = "tempdb";
$db = mssql_connect($Host,$User,$Passwd);
if(!$db)
{
echo "无法与数据库连接";
exit;
}
$db_default = mssql_select_db($db_Name,$db);
if(!$db_default)
{
echo "无法选定$db_Name数据库";
exit;
}
return $db;
}
$d = db_connect();
$sql = "SELECT * from sysusers ";
$result=mssql_Query($sql);
$urows = mssql_num_rows($result,$d);
echo $urows;
?>