基于PHP怎样编辑一个简单的投票系统

发布时间：2023-07-01 13:18:52 所属栏目：语言来源：

导读：本篇内容介绍了“基于PHP怎样写一个简单的投票系统？”的有关知识，在实际项目的操作过程或是学习过程中，不少人都会遇到这样的问题，接下来就让小编带大家学习一下如何处理这些情况吧！希望大家仔细阅读，

本篇内容介绍了“基于PHP怎样写一个简单的投票系统？”的有关知识，在实际项目的操作过程或是学习过程中，不少人都会遇到这样的问题，接下来就让小编带大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

实现代码

1.sql

-- phpMyAdmin SQL Dump

-- version 4.5.1

-- http://www.phpmyadmin.net

-- Host: 127.0.0.1

-- Generation Time: 2022-03-28 05:42:05

-- 服务器版本：10.1.13-MariaDB

-- PHP Version: 5.6.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

-- Database: `a`

-- --------------------------------------------------------

-- 表的结构 `voto`

CREATE TABLE `voto` (

`id` int(10) NOT NULL,

`titleid` int(10) DEFAULT NULL,

`item` varchar(50) DEFAULT NULL,

`count` int(10) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 转存表中的数据 `voto`

INSERT INTO `voto` (`id`, `titleid`, `item`, `count`) VALUES

(24, 1, '张学友', 0),

(25, 1, '陈奕迅', 0),

(26, 1, '林俊杰', 0),

(27, 1, '萧敬腾', 0),

(29, 1, '', 0),

(30, 1, 'aaa', 0);

-- Indexes for dumped tables

-- Indexes for table `voto`

ALTER TABLE `voto`

ADD PRIMARY KEY (`id`);

-- 在导出的表使用AUTO_INCREMENT

-- 使用表AUTO_INCREMENT `voto`

ALTER TABLE `voto`

MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

2.html

<!DOCTYPE html>

<head>

<title>Document</title>

</head>

<body>

<a href="admin.php" rel="external nofollow" >增删改查投票的选项</a>

<br>

<a href="index.php" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" >投票给谁呢</a>

</body>

</html>

3.admin.php（增删改查投票的页面）密码：admi

<?php

ob_start(); //打开缓冲区

session_start();

header("Content-type:text/html;charset=utf-8");

$link = mysqli_connect('localhost','root','','a');

mysqli_set_charset($link, "utf8");

if (!$link) {

die("连接失败:".mysqli_connect_error());

}

<!DOCTYPE html>

<head>

<title>PHP+mysql开发的简单投票系统</title>

/*全局样式*/

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}

/*全局样式结束*/

</style>

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("您没有选择删除项");

}

else

{

location.href="?type=del&id=" rel="external nofollow" +id

}

</script>

</head>

<body>

<?php

if(isset($_GET['tj']) == 'out'){

session_destroy();//删除当前用户对应的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('登陆失败,请检查您的密码！');window.location='admin.php'</script>";

}

<?php if($_SESSION['pwd']<>2){ ?>

<tr>

</tr>

<tr>

</label>

<label>

</label></td>

</tr>

<tr>

软件版本：<script type="text/javascript" src="http://www.04ie.com/net/phpvoto1_1.js"></script></td>

</tr>

</table>

</form>

<?php }else{ ?>

<?php

if(isset($_POST["Submit"]))

{

$title=$_POST["title"];

$sql="update vototitle set vototitle='$title'";

mysqli_query($link,$sql);

alert("修改成功");

</script>

<?php

}

if(isset($_POST["Submit2"]))

{

$newitem=$_POST["newitem"];

$sql="insert into voto (titleid,item,count) values (1,'$newitem',1)";

mysqli_query($link,$sql);

}

<tr>

<?php

$sql="select * from vototitle";

$rs=mysqli_query($link,$sql);

$rows=mysqli_fetch_assoc($rs);

</label></td>

</label></td>

</tr>

<tr>

</tr>

<?php

$sql="select * from voto order by count desc";

$rs=mysqli_query($link,$sql);

while($rows=mysqli_fetch_assoc($rs))

{

<tr>

</tr>

<?php

}

<tr>

</tr>

<tr>

</label></td>

</label>

</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 voto 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 voto where id=$id";

$rs=mysqli_query($link,$sql);

$rows=mysqli_fetch_assoc($rs);

<tr>

<th colspan="2" bgcolor="#FFFFFF">修改投票项目</th>

</tr>

<tr>

</label></td>

</tr>

<tr>

</label></td>

</tr>

<tr>

</label></td>

</tr>

</table>

</form>

<?php

}

<?php

$type = isset($_GET["type"])?$_GET["type"]:"";

if($type =="del"){

$id=$_GET["id"];

$sql="delete from voto where id in ($id)";

mysqli_query($link,$sql);

echo "<script language=javascript>alert('删除成功！');window.location='admin.php'</script>";

}

<?php } ?>

</body>

</html>

4.index.php投票的页面

<?php

ob_start();

session_start();

header("Content-type:text/html;charset=utf-8");

$link = mysqli_connect('localhost','root','','a');

mysqli_set_charset($link, "utf8");

if (!$link) {

die("连接失败:".mysqli_connect_error());

}

<!doctype html>

<html>

<head>

/*全局样式*/

body { font-family: "宋体"; font-size: 12pt; color: #333333; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;background-color: #A6C7E1;}

table { font-family: "宋体"; font-size: 9pt; line-height: 20px; color: #333333}

a:link { font-size: 9pt; color: #333333; text-decoration: none}

a:visited { font-size: 9pt; color: #333333; text-decoration: none}

a:hover { font-size: 9pt; color: #E7005C; text-decoration: underline}

a:active { font-size: 9pt; color: #333333; text-decoration: none}

/*全局样式结束*/

</style>

function check()

{

node=frm.itm;

flag=false;

for(i=0;i<node.length;i++)

{

if(node[i].checked)

{

flag=true;

}

if(!flag)

{

alert("您没有选择")

return false;

}

return true;

}

</script>

<?php

if(isset($_POST["submit"])){

if($_POST){

$id = $_POST["selected_id"];

$sql = "update voto set count = count+1 where id=$id";

mysqli_query($link,$sql);

}

if($_SESSION["voto"]==session_id())

{

alert("您已经投票了");

location.href="index.php" rel="external nofollow" rel="external nofollow" rel="external nofollow" rel="external nofollow" ;

</script>

<?php

exit();

}

$id=$_POST["itm"];

$sql="update voto set count=count+1 where id=$id";

if(mysqli_query($link,$sql))

{

$_SESSION["voto"]=session_id();

<?php

}

else

{

<?php

}

</head>

<body>

<tr>

<?php

$sql="select * from vototitle";

$rs=mysqli_query($link,$sql);

$row=mysqli_fetch_assoc($rs);

echo $row["vototitle"];

?> </th>

</tr>

<?php

$sql="select * from voto";

$rs=mysqli_query($link,$sql);

while($rows=mysqli_fetch_assoc($rs))

{

<tr>

<?php echo $rows["item"]?></td>

</tr>

<?php

}

<tr>

$("[type='radio']").click(function(){

$("#selected_id").val($(this).val());

});

</script></td>

</tr>

</table>

</form>

<?php

if(isset($_GET["id"])=="ck"){?>

<?php

$sql="select sum(count) as 'total' from voto";

$rs=mysqli_query($link,$sql);

$rows=mysqli_fetch_assoc($rs);

$sum=$rows["total"]; //得出总票数

$sql="select * from voto";

$rs=mysqli_query($link,$sql);

<tr>

</tr>

<?php

while($rows=mysqli_fetch_assoc($rs))

{

<tr>

<?php

$per=$rows["count"]/$sum;

$per=number_format($per,4);

<?php echo $per*100?>% </td>

</tr>

<?php

}

</table>

</div>

<?php } ?>

</body>

</html>

这篇关于“基于PHP怎样写一个简单的投票系统？”的文章就介绍到这了,更多相关的内容，欢迎关注群英网络，小编将为大家输出更多高质量的实用文章！

（编辑：银川站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

Spring Boot叫做什么	Spring MVC @Autowire
何为Spring	Eclipse创立Servlet项