Sistem pengundian mudah dibangunkan dengan PHP dan modul fungsi pentadbir yang lengkap
Kami telah memecahkan fungsi setiap modul pada halaman pentadbir
Ubah suai tajuk
Ubah suai dan padam item yang dipilih
Tambah projek baharu
Dalam bahagian ini kami akan menyepadukan semua fungsi dan mencipta admin.php untuk memaparkan sepenuhnya semua fungsi.
<?php
ob_start(); //打開緩沖區(qū)
session_start();
header("Content-type:text/html;charset=utf-8");
$link = mysqli_connect('localhost','username','password','test');
mysqli_set_charset($link, "utf8");
if (!$link) {
die("連接失敗:".mysqli_connect_error());
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PHP+mysql開發(fā)的簡(jiǎn)單投票系統(tǒng)</title>
<style type="text/css">
/*全局樣式*/
body { font-family: "宋體"; font-size: 12pt; color: #333333; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;background-color: #d4d4d4;}
table { font-family: "宋體"; font-size: 9pt; line-height: 20px; color: #333333}
/*全局樣式結(jié)束*/
</style>
<script language="javascript">
function selectAll()
{
node=window.document.frm.itm;
for(i=0;i<node.length;i++)
{
node[i].checked=true;
}
}
function cancelAll()
{
node=frm.itm;
for(i=0;i<node.length;i++)
{
node[i].checked=false;
}
}
function del()
{
node=frm.itm;
id="";
for(i=0;i<node.length;i++)
{
if(node[i].checked)
{
if(id=="")
{
id=node[i].value
}
else
{
id=id+","+node[i].value
}
}
}
if(id=="")
{
alert("您沒有選擇刪除項(xiàng)");
}
else
{
location.href="?type=del&id="+id
}
}
</script>
</head>
<body>
<?php
if(isset($_GET['tj']) == 'out'){
session_destroy();//刪除當(dāng)前用戶對(duì)應(yīng)的session文件以及釋放session
echo "<script language=javascript>alert('退出成功！');window.location='index.php'</script>";
}
?>
<?php
if(isset($_POST['Submit10'])){
if($_POST['pwd']=='admin'){
$_SESSION['pwd']=2;
echo "<script language=javascript>alert('登陸成功！');window.location='admin.php'</script>";
}else{
echo "<script language=javascript>alert('登陸失敗,請(qǐng)檢查您的密碼！');window.location='admin.php'</script>";
}
}
?>
<?php if($_SESSION['pwd']<>2){ ?>
<form action="" method="post">
<table width="365" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C2C2C2">
<tr>
<td height="30" align="right" bgcolor="#FFFFFF"><label>輸入密碼：</label></td>
<td align="left" bgcolor="#FFFFFF"><input name="pwd" type="text" id="pwd" /></td>
</tr>
<tr>
<td height="30" colspan="2" align="center" bgcolor="#FFFFFF"><label>
<input name="Submit10" type="submit" id="Submit10" value="登陸" />
</label>
<label>
<input type="reset" name="Submit5" value="重置" />
</label></td>
</tr>
<tr>
<td height="30" colspan="2" align="center" bgcolor="#FFFFFF">
軟件版本：<script type="text/javascript" src="http://www.04ie.com/net/phpvote1_1.js"></script></td>
</tr>
</table>
</form>
<?php }else{ ?>
<?php
if(isset($_POST["Submit"]))
{
$title=$_POST["title"];
$sql="update votetitle set votetitle='$title'";
mysqli_query($link,$sql);
?>
<script language="javascript">
alert("修改成功");
</script>
<?php
}
if(isset($_POST["Submit2"]))
{
$newitem=$_POST["newitem"];
$sql="insert into vote (titleid,item,count) values (1,'$newitem',1)";
mysqli_query($link,$sql);
}
?>
<form id="frm" name="frm" method="post" action="" style="margin-bottom:3px;">
<table width="365" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C2C2C2">
<tr>
<td colspan="4" bgcolor="#FFFFFF"><label>
<?php
$sql="select * from votetitle";
$rs=mysqli_query($link,$sql);
$rows=mysqli_fetch_assoc($rs);
?>
<input name="title" type="text" id="title" size="35" value="<?php echo $rows["votetitle"]?>" />
</label></td>
<td width="68" align="center" bgcolor="#FFFFFF"><label>
<input type="submit" name="Submit" value="修改標(biāo)題" />
</label></td>
</tr>
<tr>
<th width="30" bgcolor="#FFFFFF">編號(hào)</th>
<th width="45" bgcolor="#FFFFFF">項(xiàng)目</th>
<th width="52" bgcolor="#FFFFFF">票數(shù)</th>
<th width="50" align="center" bgcolor="#FFFFFF">修改</th>
<th align="center" bgcolor="#FFFFFF">刪除</th>
</tr>
<?php
$sql="select * from vote order by count desc";
$rs=mysqli_query($link,$sql);
while($rows=mysqli_fetch_assoc($rs))
{
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input type="checkbox" name="itm" value="<?php echo $rows["id"]?>" /><?php echo $rows["id"]?></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows["item"]?></td>
<td align="center" bgcolor="#FFFFFF"><?php echo $rows["count"]?></td>
<td align="center" bgcolor="#FFFFFF"><input type="button" value="修改" onclick="location.href='?type=modify&id=<?php echo $rows["id"]?>'" /></td>
<td align="center" bgcolor="#FFFFFF"><input type="button" value="刪除" onclick="location.href='?type=del&id=<?php echo $rows["id"]?>'" /></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF">
<input type="button" value="選擇全部" onclick="selectAll()" />
<input type="button" value="取消全部" onclick="cancelAll()" />
<input type="button" value="刪除所選" onclick="del()" /> </td>
</tr>
<tr>
<td colspan="3" bgcolor="#FFFFFF"><label>
<input name="newitem" type="text" id="newitem" />
</label></td>
<td colspan="2" bgcolor="#FFFFFF"><label>
<input type="submit" name="Submit2" value="添加新項(xiàng)" />
</label>
<a href="?tj=out">退出管理</a></td>
</tr>
</table>
</form>
<?php
$type = isset($_GET["type"])?$_GET["type"]:"";
if($type =="modify"){
$id=$_GET["id"];
if(isset($_POST["Submit3"]))
{
$item=$_POST["itm"];
$count=$_POST["count"];
$sql="update vote set item='$item',count=$count where id=$id";
mysqli_query($link,$sql);
echo "<script language=javascript>alert('修改成功！');window.location='admin.php'</script>";
}
$sql="select * from vote where id=$id";
$rs=mysqli_query($link,$sql);
$rows=mysqli_fetch_assoc($rs);
?>
<form id="form1" name="form1" method="post" action="" style="margin-top:2px;">
<table width="365" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C2C2C2">
<tr>
<th colspan="2" bgcolor="#FFFFFF">修改投票項(xiàng)目</th>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">名稱:</td>
<td bgcolor="#FFFFFF"><label>
<input name="itm" type="text" id="itm" value="<?php echo $rows["item"]?>" />
</label></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">票數(shù)：</td>
<td bgcolor="#FFFFFF"><label>
<input name="count" type="text" id="count" value="<?php echo $rows["count"]?>" />
</label></td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#FFFFFF"><label>
<input type="submit" name="Submit3" value="修改" />
<input type="reset" name="Submit" value="重置" />
</label></td>
</tr>
</table>
</form>
<?php
}
?>
<?php
$type = isset($_GET["type"])?$_GET["type"]:"";
if($type =="del"){
$id=$_GET["id"];
$sql="delete from vote where id in ($id)";
mysqli_query($link,$sql);
echo "<script language=javascript>alert('刪除成功！');window.location='admin.php'</script>";
}
?>
<?php } ?>
</body>
</html>
