页面代码如下!<?php counter(); function counter(){ $db=mysql_connect("localhost","root","") or die ("无法连接MYSQL主机"); mysql_select_db("countdata") or die ("无法打开数据库"); $sql="select * from count_table"; $result=mysql_query($sql,$db); while($thisrow=mysql_fetch_array($result){ $countnum==$thisrow[count]; } $sql="update count_table set count=".($count+1). "where site=1"; mysql_query($sql,$db); mysql_close($db); return $count+1; } ?>
<?php echo counter(); function counter(){ $db=mysql_connect("localhost","root","") or die ("无法连接MYSQL主机"); mysql_select_db("countdata") or die ("无法打开数据库"); $sql="select * from count_table where site=1"; $result=mysql_query($sql,$db); if($thisrow=mysql_fetch_array($result)){ $countnum=$thisrow[count]; $sql="update count_table set count=count+1 where site=1"; }else{ $countnum=0; $sql="insert into count_table(count,site) values(1,1)"; } mysql_query($sql,$db); mysql_close($db); return $countnum+1; } ?>
counter();
function counter(){
$db=mysql_connect("localhost","root","") or die ("无法连接MYSQL主机");
mysql_select_db("countdata") or die ("无法打开数据库");
$sql="select * from count_table";
$result=mysql_query($sql,$db);
while($thisrow=mysql_fetch_array($result){
$countnum==$thisrow[count];
}
$sql="update count_table set count=".($count+1). "where site=1";
mysql_query($sql,$db);
mysql_close($db);
return $count+1;
}
?>
把上面这行改为:
$countnum=$thisrow[count];
改为:
$countnum=$thisrow["count"];
mysql_query($sql,$db);
mysql_close($db);
return $countnum+1; //应该是$countnum 不是 $count
我试了,提示一样的呀!
$countnum==$thisrow[count];
改为:
$countnum=$thisrow["count"];不是这个原因吧!
$countnum==$thisrow[count];
}
改為 :
while($thisrow=mysql_fetch_array($result)){
$countnum==$thisrow[count];
}
也不对.改成
$countnum=$thisrow[count];
mysql_select_db('admreqs');
$query = "insert into requests(date, request, email, priority,status) values (NOW(),'$description', '$email', '$priority', 'NEW')";
$res = mysql_query($query, $dbh);
$query = "select max(id) from requests";
$res = mysql_query($query, $dbh);
你可以 把第一句改為
echo counter();
另外 ,你的 $counter 變量 和 $countnum 變量是怎麼回事 ?計數器不增加 ,請檢查你的 sql 語句的 where 條件 .
echo counter();
function counter(){
$db=mysql_connect("localhost","root","") or die ("无法连接MYSQL主机");
mysql_select_db("countdata") or die ("无法打开数据库");
$sql="select * from count_table where site=1";
$result=mysql_query($sql,$db);
if($thisrow=mysql_fetch_array($result)){
$countnum=$thisrow[count];
$sql="update count_table set count=count+1 where site=1";
}else{
$countnum=0;
$sql="insert into count_table(count,site) values(1,1)";
}
mysql_query($sql,$db);
mysql_close($db);
return $countnum+1;
}
?>