php和mysql投票系统小弟的心血.doc

前台代码：index.php无标题文档 题目： input name=SType type=hidden id=SType value= / input name=ObjID type=hidden id=ObjID value= / 查看结果 ?php $Sql=select * from tselect where ObjID=.$ObjID.; $Result=mysql_query($Sql); while($Arr=mysql_fetch_array($Result) if($SType=0) echo .$ArrSName. ; elseif($SType=1) echo .$ArrSName. ; ? result.php无标题文档?php$IP=$_SERVERREMOTE_ADDR;$SType=$_POSTSType;$Sel=$_POSTSel;$SelArr=$_POSTSelArr;$opt=$_POSTopt;$ObjID=$_POSTObjID;$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($ArrIPNum=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) values (.$IP.,.$ObjID.); echo alert(投票成功，感谢您的参与！); else echo alert(投票失败，请您重新投票，感谢您的参与！); 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(mysql_query($Sql) mysql_query(insert into IPTable (IP,ObjID) values (.$IP.,.$ObjID.); echo alert(投票成功，感谢您的参与！); else echo alert(投票失败，请您重新投票，感谢您的参与！); else echo alert(您已经投过票，不需要再次投票！); $Sql=select * from tobject where ID=.$ObjID.;$Result=mysql_query($Sql);$Arr=mysql_fetch_array($Result);$OJBName=$ArrOJBName;$SType=$ArrSType;? 题目： 选项 比例 票数 img src=images/per.gif width= height=20 align=absmiddle / () public.jsfunction selectAll(obj) for(var i = 0;iobj.elements.length;i+)if(obj.elementsi.type = checkbox)obj.elementsi.checked = true;function selectOther(obj) for(var i = 0;iobj.elements.length;i+)if(obj.elementsi.type = checkbox ) if(!obj.elementsi.checked) obj.elementsi.checked = true; else obj.elementsi.checked = false;function objedit(page,f,id)f.opt.value=edit;f.ID.value=id;f.action=page;f.submit();function Objadd(page,f)f.opt.value=add;f.action=page;f.submit();function objdel(page,f,id)if(confirm(您确认要删除这个项目吗？)f.opt.value=del;f.ID.value=idf.action=page;f.submit();function Objdelsel(page,f)if(confirm(您确认要删除这些项目吗？) f.opt.value=delsel;f.action=page;f.submit();function objselect(page,f,id)f.opt.value=list;f.ObjID.value=id;f.action=page;f.submit();function lookresult(page,f,opt)f.opt.value=opt;f.action=page;f.submit();conn.phpstyle.css.font1 font-family:宋体; font-size:12px; line-height:23px; font-weight:bold;.font2 font-family:宋体; font-size:12px; line-height:23px;.font3 font-family:宋体; font-size:12px;.td1 border:1px solid #FFF;后台代码：index.php无标题文档 编号 类别 项目 操作 input name=IDArr type=checkbox id=IDArr value= / a href=javascript:objedit(objopt.php,document.form1,)编辑a href=javascript:objdel(objopt.php,document.form1,)删除a href=javascript:objselect(select.php,document.form1,)选项 全选反选增加删除 objopt.php无标题文档?php$opt=$_POSTopt;$ID=$_POSTID;$IDArr=$_POSTIDArr;switch ($opt)case add: $OptName=添加新项目;$OptStr=int;break;case int: $Sql=insert into tobject (OJBName,SType) values(.$_POSTOJBName.,.$_POSTSType.);if(mysql_query($Sql) echo alert(添加成功!);window.location.href=index.php; exit; else echo alert(添加失败!);window.location.href=index.php; exit; break;case edit: $OptName=编辑项目;$OptStr=upd;$Sql=select * from tobject where ID=.$ID.;$Result=mysql_query($Sql);$Arr=mysql_fetch_array($Result);$OJBName=$ArrOJBName;$SType=$ArrSType;break;case upd: $Sql=update tobject set OJBName=.$_POSTOJBName.,SType=.$_POSTSType. where ID=.$ID.;if(mysql_query($Sql) echo alert(编辑成功!);window.location.href=index.php; exit; else echo alert(编辑失败!);window.location.href=index.php; exit; break;case del: $Sql=delete from tobject where ID=.$ID.;if(mysql_query($Sql) echo alert(删除成功!);window.location.href=index.php; exit; else echo alert(删除失败!);window.location.href=index.php; exit; break;case delsel: $Count=count($IDArr);if($Count0) $SqlStr=; for($i=0;$i$Count;$i+) $SqlStr.= ID=.$IDArr$i. or ; $SqlStr=substr($SqlStr,0,strlen($SqlStr)-4); $Sql=delete from tobject where .$SqlStr; if(mysql_query($Sql) echo alert(删除成功!);window.location.href=index.php; exit; else echo alert(删除失败!);window.location.href=index.php; exit; else echo alert(提交参数错误，没有选择任何要删除的项目!);window.location.href=index.php; break;? 项目名称： input name=OJBName type=text class=font3 id=OJBName value= size=70 / 项目类型： input name=SType type=radio value=0 / 单选 input type=radio name=SType value=1 / 多选 input name=opt type=hidden id=opt value= / input name=ID type=hidden id=ID value= / select.php无标题文档 编号 投票数 input name=ObjID type=hidden id=ObjID value= / 选项 操作 input name=IDArr type=checkbox id=IDArr value= / a href=javascript:objedit(selopt.php,document.form1,)编辑a href=javascript:objdel(selopt.php,document.form1,)删除 全选反选增加删除返回 selopt.php无标题文档?php$opt=$_POSTopt;$ID=$_POSTID;$IDArr=$_POSTIDArr;switch ($opt)case add: $OptName=添加新选项;$OptStr=int;break;case int: $Sql=insert into tselect (ObjID,SName,Num) values(.$_POSTObjID.,.$_POSTSName.,0);if(mysql_query($Sql) echo alert(添加成功!);window.location.href=select.php?ObjID=.$_POSTObjID.; exit; else echo alert(添加失败!);window.location.href=select.php?ObjID=.$_POSTObjID.; exit; break;case edit: $OptName=编辑选项;$OptStr=upd;$Sql=select * from tselect where ID=.$ID.;$Result=mysql_query($Sql);$Arr=mysql_fetch_array($Result);$SName=$ArrSName;break;case upd: $Sql=update tselect set ObjID=.$_POSTObjID.,SName=.$_POSTSName. where ID=.$ID.;if(mysql_query($Sql) echo alert(编辑成功!);window.location.href=select.php?ObjID=.$_POSTObjID.; exit; else echo alert(编辑失败!);window.location.href=select.php?ObjID=.$_POSTObjID.; exit; break;case del: $Sql=delete from tselect where ID=.$ID.;if(mysql_query($Sql) echo alert(删除成功!);window.location.href=select.php?ObjID=.$_POSTObjID.; exit; else echo alert(删除失败!);window.location.href=select.php?ObjID=.$_POSTObjID.; exit; break;case delsel: $Count=count($IDArr);if($Count0) $SqlStr=; for($i=0;$i$Count;$i+) $SqlStr.= ID=.$IDArr$i. or ; $SqlStr=substr($SqlStr,0,strlen($SqlStr)-4); $Sql=delete from tselect where