📄 voteadmin.php
字号:
<?php
include("pwdsuper.php");
include("connect.inc.php");
include("char.inc.php");
if (isset($flag)){
switch ($op){
case "add":
$poll_timestamp = time();
$title = addslashes($title);
if(!mysql_query("INSERT INTO polls (polltitle, timestamp,pollsdate) VALUES ('$title', '$poll_timestamp',CURDATE())", $conn)) echo mysql_errno(). ": ".mysql_error(). "<br>";
$recordid=mysql_insert_id($conn);
//$poll_result = mysql_query("SELECT pollid FROM polls WHERE pollTitle='$title'", $conn);
//if(!$poll_result)
//{
// echo mysql_errno(). ": ".mysql_error(). "<br>";
// return;
//}
// fetch ID field
//$poll_object = mysql_fetch_object($poll_result);
//$poll_id = $poll_object->pollID;
// create option records in data table
for($i = 1; $i <= 10; $i++)
{
$pfield="textfield".$i;
if($$pfield != "")
{
//echo $$pfield."<br>";
$$pfield = addslashes($$pfield);
$optionstr=$$pfield;
if(!mysql_query("INSERT INTO pollsdata (pollid, optiontext, optioncount, voteid) VALUES ($recordid, '$optionstr', 0, $i)", $conn))echo mysql_errno(). ": ".mysql_error(). "<br>";
}
}
break;
case "delete":
$conn=mysql_pconnect('localhost','root','');
$select=mysql_select_db('test',$conn);
$poll_result = mysql_query("DELETE FROM polls WHERE pollid=$pollsid", $conn);
if(!$poll_result)echo mysql_errno(). ": ".mysql_error(). "<br>";
$poll_result = mysql_query("DELETE FROM pollsdata WHERE pollid=$pollsid", $conn);
if(!$poll_result)echo mysql_errno(). ": ".mysql_error(). "<br>";
$poll_result = mysql_query("DELETE FROM pollsip WHERE pollid=$pollsid", $conn);
if(!$poll_result)echo mysql_errno(). ": ".mysql_error(). "<br>";
// $poll_result = mysql_query("DELETE FROM $poll_logTableName WHERE pollID=$poll_id", $conn);
// if(!$poll_result)echo mysql_errno(). ": ".mysql_error(). "<br>";
// echo "Done.";
break;
default:
break;
}
}
//#######################
$pagesize=15; //一页显示记录数
$classbcquery=mysql_query('select * from polls ORDER BY pollsdate DESC, pollid desc',$conn);
$recordcount = mysql_num_rows($classbcquery);
$pagecount = bcdiv($recordcount+$pagesize-1,$pagesize,0); //算出总页数
if(!isset($page)) $page = 1; //如果没有指定显示页码，缺省为显示第一页
if($page<1) $page = 1; //如果页码比1小，则显示第一页
if($page>$pagecount) $page = $pagecount; //如果页码比总页数大，则显示最后一页
if($pagecount>0){
if($page>0){ //页码比0大，表示有数据
$firstimage='<a href="' . $PHP_SELF . '?page=1"><img name="listbm_r3_c4" src="images/listbm_r3_c4.gif" width="16" height="16" border="0" title="首页" alt="首页"></a>';
if($page>1){
$pimage='<a href="' . $PHP_SELF . '?page='. ($page-1) . '"><img name="listbm_r3_c6" src="images/listbm_r3_c6.gif" width="16" height="16" border="0" title="前页" alt="前页"></a>';
}else{
$pimage='<img name="listbm_r3_c6" src="images/listbm_r3_c6.gif" width="16" height="16" border="0" title="前页" alt="前页">';
}
if($page<$pagecount){
$nimage='<a href="' . $PHP_SELF . '?page='. ($page+1) . '"><img name="listbm_r3_c8" src="images/listbm_r3_c8.gif" width="16" height="16" border="0" title="后页" alt="后页"></a>';
}else{
$nimage='<img name="listbm_r3_c8" src="images/listbm_r3_c8.gif" width="16" height="16" border="0" title="后页" alt="后页">';
}
$lastimage='<a href="' . $PHP_SELF . '?page=' . $pagecount . '"><img name="listbm_r3_c10" src="images/listbm_r3_c10.gif" width="16" height="16" border="0" title="最后页" alt="最后页"></a>';
$pageinfo=$pagesize.'条/页 共'.$recordcount.'条 页数:'.$page.'/'.$pagecount.'页 ';
}
}
?>
<html>
<head>
<script language="javascript">
<!--
function disppub(vid) {
window.open('viewvote.php?pollid='+vid,'showvote','resizable=1,scrollbars=1,width=410,height=340');
}
function openw(url,n,w,h) {
window.open(url,n,'resizable=1,scrollbars=1,width='+w+',height='+h)
}
function high(which2){
theobject=which2
highlighting=setInterval("highlightit(theobject)",50)
}
function low(which2){
clearInterval(highlighting)
which2.filters.alpha.opacity=60
}
function highlightit(cur2){
if (cur2.filters.alpha.opacity<100)
cur2.filters.alpha.opacity+=10
else if (window.highlighting)
clearInterval(highlighting)
}
function ok_onclick(){
var text=""
var text2=""
var count=0
if (form1.textfield1.value=="") count=count+1
if (form1.textfield2.value=="") count=count+1
if (form1.textfield3.value=="") count=count+1
if (form1.textfield4.value=="") count=count+1
if (form1.textfield5.value=="") count=count+1
if (form1.textfield6.value=="") count=count+1
if (form1.textfield7.value=="") count=count+1
if (form1.textfield8.value=="") count=count+1
if (form1.textfield9.value=="") count=count+1
if (form1.textfield10.value=="") count=count+1
if(count>8) text="至少要填写两个选择字段！"
if (form1.title.value=="") text=text+"你没有填写标题！"
if(form1.title.value=="" || (count>8)) alert(text)
if(form1.title.value!="" && (count<=8)) form1.submit()
}
//-->
</script>
<style type="text/css">
<!--
td{font-size:12px;line-height:17px;}
a:active {text-decoration: none;}
a:link {text-decoration: none;}
a:hover{text-decoration: underline;}
a:visited {text-decoration: none;}
BODY{font-size:12px;line-height:17px;SCROLLBAR-FACE-COLOR: #83d160; SCROLLBAR-HIGHLIGHT-COLOR: #CCFF00; SCROLLBAR-SHADOW-COLOR: #CCFF00; SCROLLBAR-3DLIGHT-COLOR: #009900; SCROLLBAR-ARROW-COLOR: #006600; SCROLLBAR-TRACK-COLOR: ##99FF00; SCROLLBAR-DARKSHADOW-COLOR: #009900; }
-->
</style>
<title>::::集中营调查管理::::</title>
<meta http-equiv="Content-Type" content="text/html;">
<!-- Fireworks 4.0 Dreamweaver 4.0 target. Created Wed Mar 20 14:48:27 GMT+0800 (?D1ú±ê×?ê±??) 2002-->
</head>
<body bgcolor="#dcf6ce" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" text="#666600" link="#009900" alink="#00FF00" vlink="#006600">
<table border="0" cellpadding="0" cellspacing="0" width="621">
<!-- fwtable fwsrc="无标题" fwbase="right.gif" fwstyle="Dreamweaver" fwdocid = "742308039" fwnested="0" -->
<tr>
<td><img src="images/spacer.gif" width="5" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="15" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="5" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="2" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="38" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="55" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="82" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="96" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="87" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="115" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="65" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="30" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="5" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="15" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="6" height="1" border="0"></td>
<td><img src="images/spacer.gif" width="1" height="1" border="0"></td>
</tr>
<tr>
<td colspan="15" bgcolor="#dcf6ce"><img src="images/spacer.gif" width="621" height="5" border="0"></td>
<td><img src="images/spacer.gif" width="1" height="5" border="0"></td>
</tr>
<tr>
<td colspan="4" bgcolor="#dcf6ce"><img src="images/spacer.gif" width="27" height="19" border="0"></td>
<td colspan="3"><img name="right_r2_c5" src="images/right_r2_c5.gif" width="175" height="19" border="0"></td>
<td colspan="8" bgcolor="#dcf6ce"><div align="right">::::集中营调查管理:::: </div></td>
<td><img src="images/spacer.gif" width="1" height="19" border="0"></td>
</tr>
<tr>
<td rowspan="9" bgcolor="#dcf6ce"><img src="images/spacer.gif" width="5" height="425" border="0"></td>
<td colspan="3"><img name="right_r3_c2" src="images/right_r3_c2.gif" width="22" height="16" border="0"></td>
<td colspan="2" bgcolor="#83d160"><img src="images/spacer.gif" width="93" height="16" border="0"></td>
<td><img name="right_r3_c7" src="images/right_r3_c7.gif" width="82" height="16" border="0"></td>
<td><img name="right_r3_c8" src="images/right_r3_c8.gif" width="96" height="16" border="0"></td>
<td><img name="right_r3_c9" src="images/right_r3_c9.gif" width="87" height="16" border="0"></td>
<td><img name="right_r3_c10" src="images/right_r3_c10.gif" width="115" height="16" border="0"></td>
<td colspan="3"><img name="right_r3_c11" src="images/right_r3_c11.gif" width="100" height="16" border="0"></td>
<td><img name="right_r3_c14" src="images/right_r3_c14.gif" width="15" height="16" border="0"></td>
<td rowspan="9" bgcolor="#dcf6ce"><img src="images/spacer.gif" width="6" height="425" border="0"></td>
<td><img src="images/spacer.gif" width="1" height="16" border="0"></td>
</tr>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -