# z- E) w( T, y1 }' a6 b. a" M x 8 \6 Z7 j O. r4 Y, N0 E* d' b$myconn=sql_connect($url,$name,$pwd);& [" L1 h: M# m$ _/ y% U/ P
mysql_select_db($db,$myconn);5 I4 h# u, t" n; L: R& T n# a
: B$ `2 I" y4 H* A$ A% O) g/ dif(strlen($delnote))#处理删除单个访问者命令 + o. w' |' z( }' N{1 l6 c9 J: t7 k) K7 X. M( `
$strSql="delete from pollvote where pollvoteid='$delnote'"; ) M+ O8 v6 g4 c7 I P* Fmysql_query($strSql,$myconn); % S3 j/ E1 }: K2 h}- V6 S# o$ k H% G: Y' z& D9 l
if(strlen($delete))#处理删除投票的命令4 c* W' h9 l( e5 Q
{ 0 v8 X% f( y! k1 @5 p' i$strSql="delete from poll where pollid='$id'";! S7 w' v7 g4 r# j4 V2 ]) E2 O
mysql_query($strSql,$myconn);5 q# v, ]( q5 e, @+ N/ H
} 1 w, H" W4 o- Sif(strlen($note))#处理投票记录的命令% I0 c5 f' Z% r0 c8 W
{$strSql="select * from pollvote where pollid='$id' order by votedate desc"; 4 X8 V$ V' ]9 r1 \% m) Z$result=mysql_query($strSql,$myconn); 0 M* s& T1 J S+ s$row=mysql_fetch_array($result); * F. V) q8 ~! h3 ]echo "<table border=\"1\" cellspacing=\"1\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"550\"><tr><td colspan=5>投票题目:<font color=\"ff0000\">$row[votequestion]</font> 注:按投票时间降序排列</td></tr>";1 q2 N( ]2 N6 L; ^7 K0 E
$x=1; , W3 t6 l$ H# {% T5 uwhile($row)( \, l8 k) D7 K
{ 0 Z2 m' ~* n+ G0 f- U# S$time=date("于Y年n月d日H时I分投票",$row[votedate]); ( r6 |2 e2 o' ] |7 G
echo "<tr><td>$x</td><td> 选择的结果:$row[votenumber]</td><td>来自IP:$row[userip]</td><td>$time</td><td><a href=\"".$phpself."?id=$row[pollid]&user=$user&password=$password&admin=1¬e=on&delnote=$row[pollvoteid]\">删除这条记录</a></td></tr>";4 V% }/ e% }/ j! u5 a8 i7 y3 Q$ z
$row=mysql_fetch_array($result);$x++; 0 [7 ^0 [, A9 R} " {5 @& Z; k$ \. Mecho "</table><br>";* `: ^% a W5 ]% c
}" |( x% S; i+ v# ^2 A# h
. j1 l. \ n$ N1 J- r2 T$strSql="select * from poll"; % S" T. `, Y! i* O. F9 A$result=mysql_query($strSql,$myconn);& R) O' i0 N, z9 v) J8 r; B
$i=mysql_num_rows($result); ) T/ I4 [( B: }. J, F# }7 ?$color=1;$z=1;# e3 Q% Q- t0 d: T1 t. a% }
echo "<div align=\"left\">目前有".$i."个投票主题<table width=\"550\" cellspacing=\"1\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" >";' ?' ~" Q$ U* ~* {. s
while($rows=mysql_fetch_array($result)); q8 X6 b0 P) W6 Q* \* c
{9 C# e8 n2 Q, @0 ~$ B# G
if($color==1) / {. t; I r( V' n1 U# t{ $colo="#e2e2e2";$color++;} 8 L. }0 z& n: s3 w' ^& `8 @else 1 }6 u7 p$ A! e7 J$ Y2 S6 u. U{ $colo="#e9e9e9";$color--;} : Y$ D! Z" Z7 L9 c G6 r! mecho "<tr><td width=\"5%\" align=\"center\" bgcolor=\"$colo\">$z</td><td width=\"55%\" bgcolor=\"$colo\">$rows[question]</td><td width=\"10%\" bgcolor=\"$colo\"><a href=\"".$phpself."?id=$rows[pollid]&user=$user&password=$password&admin=1&delete=on\">删除投票</a></td><td width=\"10%\" bgcolor=\"$colo\"><a href=\"".$phpself."?id=$rows[pollid]&user=$user&password=$password&admin=1¬e=on\" >投票记录</a></td><td width=\"10%\" bgcolor=\"$colo\"> ! j- C' T/ d* |' n' o. E# v<a href=\"toupiao.php?id=$rows[pollid]&toupiao=-1\" target=\"_blank\">查看结果</a></td></tr>";$z++;5 b$ q" A7 y8 r$ V$ H& \' Q4 g0 c
} 6 V6 P3 U$ o3 d! t
" L; p& X, e4 F( h8 a2 `echo "<tr><td colspan=4 align=\"right\"></td></tr></table>"; 8 N. w( m Q1 o' }; E9 W! E zmysql_close();7 N/ o) T7 P" S& R- j
