2个回答
展开全部
<?php
header("Content-type: text/html; charset=utf-8");
$link = mysql_connect( 'localhost', 'root', '') or die('Could not connect to mysql server' );
mysql_select_db('tpxt',$link) or die('Could not select database');
if (isset($_POST['submit'])) {
$sql = "SELECT `id` FROM `table` WHERE `uid` = ".$_POST['uid'];
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$sql = "UPDATE `table` SET `vote`=`vote`+1 WHERE `uid` = ".$_POST['uid'];
mysql_query($sql);
}else{
$sql = "INSERT INTO `table`(uid,vote) VALUES('".$_POST['uid']."','1')";
mysql_query($sql);
}
echo "<script>alert('Ok 投票成功!');</script>";
echo "<script>window.location.reload();</script>";
exit();
}else{
$sql = "SELECT `vote` FROM `table` WHERE `uid` = 3";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$t3 = mysql_fetch_assoc($result);
}else{
$t3['vote'] = 0;
}
$sql = "SELECT `vote` FROM `table` WHERE `uid` = 4";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$t4 = mysql_fetch_assoc($result);
}else{
$t4['vote'] = 0;
}
$sql = "SELECT `vote` FROM `table` WHERE `uid` = 5";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$t5 = mysql_fetch_assoc($result);
}else{
$t5['vote'] = 0;
}
$sql = "SELECT `vote` FROM `table` WHERE `uid` = 6";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$t6 = mysql_fetch_assoc($result);
}else{
$t6['vote'] = 0;
}
$sql = "SELECT `vote` FROM `table` WHERE `uid` = 7";
$result = mysql_query($sql);
if ($result && mysql_num_rows($result)) {
$t7 = mysql_fetch_assoc($result);
}else{
$t7['vote'] = 0;
}
$count = $t3['vote']+$t4['vote']+$t5['vote']+$t6['vote']+$t7['vote'];
$t3_b = $t3['vote']/$count;
$t4_b = $t4['vote']/$count;
$t5_b = $t5['vote']/$count;
$t6_b = $t6['vote']/$count;
$t7_b = $t7['vote']/$count;
}
?>
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询