下載文件的點擊數回填
發(fā)表時間:2024-06-11 來源:明輝站整理相關軟件相關文章人氣:
[摘要]需要名稱為book的mysql數據庫表 表中含有下列字段: id 下載的文件的唯一標識 downnum 點擊數 first.php <?while(myrow = @mysql_fetch_array(result)) ?> <TR> <TD> <...
需要名稱為book的mysql數據庫表
表中含有下列字段:
id 下載的文件的唯一標識
downnum 點擊數
first.php
<?while($myrow = @mysql_fetch_array($result))
{
?>
<TR>
<TD>
<?if(empty($myrow["downnum"])) echo "0"; else echo $myrow["downnum"]; ?>
</TD>
<TD>
<a href="ddload.php?purl=downfileurl&dnnum=<?echo $myrow['downnum'] ?>&id=<?echo $myrow['id']?>">click here download </a>
</TD>
</TR>
<?};?>
ddload.php
<?
include("data.inc.php");
if($incerror)
{
echo $incerror;
exit;
}
if(empty($dnnum)) $dnnum = 1;
else $dnnum ++;
$sql = "update book set downnum ='$dnnum' where id =$id";
mysql_query($sql);
mysql_close($connect);
header("location:$purl");
?>