【php开源代码栏目提醒】:网学会员在php开源代码频道为大家收集整理了pollresult.php提供大家参考,希望对大家有所帮助!
<?php
include_once("config.php");
include_once("functions.php");
$id = isset($_REQUEST['id'])?$_REQUEST['id']:'';
$question = isset($_REQUEST['question'])?$_REQUEST['question']:'';
$answer = isset($_REQUEST['answer'])?$_REQUEST['answer']:'';
$noa = isset($_REQUEST['noa'])?$_REQUEST['noa']:'';
$answer1 = isset($_REQUEST['answer1'])?$_REQUEST['answer1']:'';
$answer2 = isset($_REQUEST['answer2'])?$_REQUEST['answer2']:'';
$answer3 = isset($_REQUEST['answer3'])?$_REQUEST['answer3']:'';
$answer4 = isset($_REQUEST['answer4'])?$_REQUEST['answer4']:'';
$answer5 = isset($_REQUEST['answer5'])?$_REQUEST['answer5']:'';
$answer6 = isset($_REQUEST['answer6'])?$_REQUEST['answer6']:'';
echo "<head>
<title>$title</title>
<link rel = stylesheet type=text/css href=style.css>
</head>
<body bgcolor=#ffffff topmargin=0 leftmargin=0 rightmargin=0>";
echo "<br><center>下面为投票结果<br>";
if (!$answer){ //如果没有选中一个选项,则回到投票页面
include_once("show.php");
exit;
}
$answervar="answer".$answer; //获得选项编号
//检查投票选项是否存在
$pollrow=mysql_num_rows(mysql_query("select * from pollresult where pid=$id"));
if ($pollrow >0){
//获取该选项的被投票数量
$getanswer="select $answervar from pollresult where pid=$id";
$getresult=mysql_query($getanswer);
$rows=
mysql_num_rows($getresult);
$pollanswer=($rows >0)?mysql_result($getresult,0,$answervar):0;
//然后将该数量增加1
$pollanswer+=1;
//更新投票数据到数据库
$update
sql="update pollresult set $answervar=$pollanswer where pid=$id";
@mysql_query($updatesql);
//显示结果
showResult($id,$question,$answer1,$answer2,$answer3,$answer4,$answer5,$answer6,$answer);
} else { //插入新记录,即第一次被投票
$insertnew="insert into pollresult (pid,$answervar,noofanswers) values($id,1,$noa)";
mysql_query($insertnew);
//显示结果
showResult($id,$question,$answer1,$answer2,$answer3,$answer4,$answer5,$answer6,$answer);
}
echo "</body></html>";
?>