展开全部
PHP:<?php
header ('Content-Type:text/html;charset=utf-8');
mysql_connect("localhost","root","") or die('The database connection failed');
mysql_select_db("vote") or die('The database is wrong choice');
mysql_query('SET NAMES UTF8');
if (isset($_POST['name']))
{
@mysql_query("UPDATE `list` SET `votes` = (SELECT `votes` FROM (SELECT * FROM list) as b WHERE `id` = {$_POST['name']}) + 1 WHERE `id` = {$_POST['name']}");
$result = @mysql_query("SELECT * FROM `list`");
echo "当前票数:";
while ($query = mysql_fetch_array($result,MYSQL_ASSOC))
{
echo $query['name'].":{$query['votes']}
";
}
echo "返回上页";
}
else
{
$result = @mysql_query("SELECT * FROM `list`");
echo '
';echo "谁最聪明32313133353236313431303231363533e58685e5aeb931333337393031:";
while ($query = mysql_fetch_array($result,MYSQL_ASSOC))
{
echo "".$query['name'];
}
echo '';
echo '
';}
?>
mysql:SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE DATABASE `vote` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `vote`;
CREATE TABLE `list` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) NOT NULL,
`votes` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `list` VALUES (1, '小明', 0);
INSERT INTO `list` VALUES (2, '小文', 0);
我觉得也够简单了