明輝手游網(wǎng)中心:是一個(gè)免費(fèi)提供流行視頻軟件教程、在線學(xué)習(xí)分享的學(xué)習(xí)平臺(tái)!

下載文件的點(diǎn)擊數(shù)回填

[摘要]需要名稱為book的mysql數(shù)據(jù)庫(kù)表 表中含有下列字段: id 下載的文件的唯一標(biāo)識(shí) downnum 點(diǎn)擊數(shù) first.php <?while(myrow = @mysql_fetch_array(result)) ?> <TR> <TD> <...
需要名稱為book的mysql數(shù)據(jù)庫(kù)表
表中含有下列字段:
id   下載的文件的唯一標(biāo)識(shí)
downnum  點(diǎn)擊數(shù)

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");
?>