请教高手，以下是什么问题，服务器端的还是……？？？

[xulei]

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 32

Warning: MySQL: A link to the server could not be established in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 32

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 35

Warning: MySQL: A link to the server could not be established in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 35

Warning: Supplied argument is not a valid MySQL result resource in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 36

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 40

Warning: MySQL: A link to the server could not be established in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 40

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 49

Warning: MySQL: A link to the server could not be established in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 49

Warning: Supplied argument is not a valid MySQL result resource in /info8/newinfo/s/h/i/shidai/www/sg/luntan/header.php on line 50

[zxyufan]

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

我觉得好象不是代码的问题~~而是服务器的问题~~

[xulei]

我是新手，这是PHP代码，不知是不是可以这样用！

很急！希望赐教！！！

<?
$updatevisit="UPDATE $visit_table SET visit=visit+1 WHERE id=1";
mysql_db_query($dbname,$updatevisit);

$sqlvisit="SELECT * FROM $visit_table WHERE id=1";
$result_sqlvisit=mysql_db_query($dbname,$sqlvisit);
$row_visit=mysql_fetch_array($result_sqlvisit);

if ($row_visit[today]<>$sdate):
$sql_setday="UPDATE $visit_table SET today=$sdate,todayview=0 WHERE id=1";
mysql_db_query($dbname,$sql_setday);

else:
$sql_setview="UPDATE $visit_table SET todayview=todayview+1 WHERE id=1";
mysql_db_query($dbname,$sql_setview);

endif;

$sqlvisit="SELECT * FROM $visit_table WHERE id=1";
$result_sqlvisit=mysql_db_query($dbname,$sqlvisit);
$row_visit=mysql_fetch_array($result_sqlvisit);

?>

[wd_318]

下面的句子有问题：
mysql_db_query($dbname,$updatevisit);
参照如下先建立连接并选择数据库:

$conn=@mysql_connect($db_server,$db_user,$db_password);
if(! $conn)
{
echo "<P align=center>数据库连接出错</P>";
exit(0);
}

$flag=@mysql_select_db($db_name,$conn);
if(! $flag)
{
echo "<P align=center>选择数据库出错</P>";
exit(0);
}

然后再执行:
mysql_db_query($updatevisit,$conn);

其他mysql_db_query也是一样的错误

[xulei]

可是为什么我在W2K下运行就一点问题都没有呢？

而且别的页面这么用也没出什么问题啊

是不是还有其他的原因？

[bombshell]

好像没有连接数据库。
$concent=mysql_connect("yourhost","username","password");
mysql_select_db("yourdb","$connect");
$updatevisit="UPDATE $visit_table SET visit=visit+1 WHERE id=1";
$result=mysql_query($updatevisit);
......

[xulei]

$dbhost = "xxxxxx"; // 数据库主机名
$dbuser = "xxxxxx"; // 数据库用户名
$dbpasswd = "xxxxxx"; // 数据库密码
$dbname = "xxxxxx"; // 数据库名


这样定义过了

header.php只是一个包含文件

mysql_connect($dbhost,$dbuser,$dbpasswd) or die ("数据库连接失败");

[qsnake]

mysql没有安装设置好

[wd_318]

但从你提供的错误提示上看，应该是因为连接没建立好

[xulei]

感谢各位！

终于调通了，确实是与数据库连接的问题

我当时以为在主文件里执行连接了，被包含的文件就不用了；可却少的正是这句：

mysql_connect($dbhost,$dbuser,$dbpasswd) or die ("数据库连接失败");

但是，又一个问题来了

为什么在本机W2K环境下就没有这个问题呢？


我正在调试的是刚做的一个论坛，仿照乐趣的样式来的，这是要求！
大体可以了，刚传上去就出现了那么多的问题！
呵呵！

http://www.shidaiguocui.com/sg/luntan

[xulei]

没错就是连接没建立好

[xulei]

改成这样就好了！

体会颇深……

<?
mysql_connect($dbhost,$dbuser,$dbpasswd) or die ("数据库连接失败");

$updatevisit="UPDATE $visit_table SET visit=visit+1 WHERE id=1";
mysql_db_query($dbname,$updatevisit);

$sqlvisit="SELECT * FROM $visit_table WHERE id=1";
$result_sqlvisit=mysql_db_query($dbname,$sqlvisit);
$row_visit=mysql_fetch_array($result_sqlvisit);

if ($row_visit[today]<>$sdate):
$sql_setday="UPDATE $visit_table SET today='$sdate',todayview=0 WHERE id=1";
mysql_db_query($dbname,$sql_setday);

else:
$sql_setview="UPDATE $visit_table SET todayview=todayview+1 WHERE id=1";
mysql_db_query($dbname,$sql_setview);

endif;

$sqlvisit="SELECT * FROM $visit_table WHERE id=1";
$result_sqlvisit=mysql_db_query($dbname,$sqlvisit);
$row_visit=mysql_fetch_array($result_sqlvisit);

?>

[xulei]

东网的数据库

不过东网的数据库出过好几次问题可是真的

没配置好,有可能!

不然的话,......

不过这个问题回去由于忙也没有深究,这两天再看看书啦

[zxyufan]

万网的mysql倒是经常出这毛病~~~我就怀疑是服务器的问题`~打电话让他们reboot了一次就ok了~~