我是新手,这是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);?>
$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);?>
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也是一样的错误
$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);
......
$dbuser = "xxxxxx"; // 数据库用户名
$dbpasswd = "xxxxxx"; // 数据库密码
$dbname = "xxxxxx"; // 数据库名
这样定义过了header.php只是一个包含文件mysql_connect($dbhost,$dbuser,$dbpasswd) or die ("数据库连接失败");
我正在调试的是刚做的一个论坛,仿照乐趣的样式来的,这是要求!
大体可以了,刚传上去就出现了那么多的问题!
呵呵!http://www.shidaiguocui.com/sg/luntan
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);?>