用于每天取题，自动统计结果，判断对错的每日一题。
//下面是用于统计结果，判断对错的result.php
<?php
$date=date("Y-m-d");
$answer=trim($answer);
$answer=htmlspecialchars($answer);
$ans=$answer;
//global $ans;
mysql_pconnect("localhost","root","") or die("不能连接数据库");
@mysql_select_db ("teaman") or die("不能连接数据库");
if ($id=="show") { //判断是否是查寻答案
$sql="select english,chinese from everydayshow where date='$date' ";
$result=mysql_query($sql);
$english=mysql_result($result,0,"english");
//$englist=stripslashes($english);
$chinese=mysql_result($result,0,"chinese");
echo "<table width='450' border='1' cellpadding='1' cellspacing='1' bordercolor='#33ccff' align='center'>";
echo "<tr><td>每日一题答案--".$date."</td></tr>";
echo "<tr><td>题目：".stripslashes($english)."</td></tr>";
echo "<tr><td>答案: ".$chinese."</td></tr>";
if ($anss==$chinese) { //$anss是查看结果时传递的变量
echo "<tr><td><font color='red'>恭喜您，厉害，回答正确.</font></td></tr>";
} else {
echo "<tr><td><font color='blue'>很遗憾，您答错了或没有答题.</font></td></tr>";
}
echo "</table>";
echo "<a href='javascript:history.go(-1)'>返回</a>";
exit;
}
?>
<html>
<head>
<title>每日一题</title>
<meta http-equiv="content-type" content="text/html;charset=gb2312">
</head>
<body>
<?php
if ($answer=='') { //如果没有回答问题，就显示答题
$sql="select sum(times) as times from everydayresult where date='$date'";
$result=mysql_query($sql);
$alltimes=mysql_result($result,0,"times");//取得答题的总人次
$sql="select * from everydayresult where date='$date'";
$result=mysql_query($sql);
$num=mysql_num_rows($result);
if ($num==0) { //看是否有记录
echo "该题尚无人回答，请答题。";
exit; //下面的就不再执行了
}
echo "<table width='450' border='1' cellpadding='1' cellspacing='1' bordercolor='#33ccff' align='center'>";
echo "<tr bgcolor='#99ccff'><td colspan='3'>今日题目: ".stripslashes($english)."</td></tr>";
echo "<tr bgcolor='#99ccff'><td>回答内容</td><td>次数</td><td>比例图</td>";
while (list($id,$english,$answer,$ip,$date,$times)=mysql_fetch_row($result)) {
echo "<tr><td>";
echo $answer."</td><td>".$times."</td><td><img src='line.gif' width='".(200*$times/$alltimes)."' height='5'></tr>";
}
echo "<tr><td colspan='3'>现共有<font color='red'>".$alltimes."</font>人答题,很遗憾，您没有答题。</td></tr><table>";
} else { //如果答了题，就先写入再显示出来
$sql="select answer from everydayresult where answer='$answer' and date='$date'"; //看是否有一样的答题
$result=mysql_query($sql);
$checknum=mysql_num_rows($result);
if ($checknum !=0) { //说明已经有人和你回答的一样
$sql="update everydayresult set times=times+1 where answer='$answer' and date='$date'"; //那就不用加新数据，将答题的记录加1
mysql_query($sql);
} else { //是新答案就要加新记录
$sql="insert into everydayresult(english,answer,ip,date) values('$english','$answer','$REMOTE_ADDR','$date')";
mysql_query($sql);
} //下面是显示上面处理过的记录
$sql="select sum(times) as times from everydayresult where date='$date'";
$res=mysql_query($sql);
$alltimes=mysql_result($res,0,"times");//这里又要取得答题后的总人次
$sql="select * from everydayresult where date='$date'" ;
$result=mysql_query($sql);
echo "<table width='450' border='1' cellpadding='1' cellspacing='1' bordercolor='#33ccff' align='center'>";
echo "<tr bgcolor='#99ccff'><td colspan='3'>今日题目: ".stripslashes($english)."</td></tr>";
echo "<tr bgcolor='#99ccff'><td>回答内容</td><td>次数</td><td>比例图</td>";
while (list($id,$english,$answer,$ip,$date,$times)=mysql_fetch_row($result)) {
echo "<tr><td>";
echo $answer."</td><td>".$times."</td><td><img src='line.gif' width='".(200*$times/$alltimes)."' height='5'></tr>";
}
echo "<tr><td colspan='3'>现共有<font color='red'>".$alltimes."</font>人答题</td></tr></table>";
}
?>
<p align="center"><a href="<?php echo $PHP_SELF; ?>?id=show&anss=<?php echo $ans; ?>">查看答案</a> <a href='javascript:history.go(-1)'>返回</a></p>
</body>
</html>
共三个部分，此为三.
|