PHP+MySql 简单投票系统代码(包括前台、后台) 2008 年 06 月 10 日 星期二 下午 05:03 前台代码: index.php
result.php <
HTML XMLNS="W3.ORG xhtml? 1999>
$SelArr=$_POST['SelArr']; $opt=$_POST['opt']; $ObjID=$_POST['ObjID']; $Sql="select count(1) as IPNum from IPTable where IP='".$IP."' and ObjID='".$ObjID."'"; $Result=mysql_query($Sql); $Arr=mysql_fetch_array($Result); if($opt=="vote") { if($Arr['IPNum']<=0) { if($SType=="0") { $Sql="update tselect set `Num`=`Num`+1 where ID='".$Sel."'"; if(mysql_query($Sql)) { mysql_query("insert into IPTable (IP,ObjID) v
alues ('".$IP."','".$ObjID."')"); echo "
"; } else { echo "
"; } } elseif($SType=="1") { $Count=count($SelArr); for($i=0;$i<$Count;$i++) { $SqlStr.=" ID=".$SelArr[$i]." or "; } $SqlStr=substr($SqlStr,0,strlen($SqlStr)-4); $Sql="update tselect set `Num`=`Num`+1 where ".$SqlStr; if(my
sql_query($Sql)) {
mysql_query("insert into IPTable (IP,ObjID) values ('".$IP."','".$ObjID."')"); echo "
"; } else { echo "
"; } } } else { echo "
"; } } $Sql="select * from tobject where ID='".$ObjID."'"; $Result=mysql_query($Sql); $Arr=mysql_fetch_array($Result); $OJBName=$Arr['OJBName']