考试管理系统(小2月考)
效果图:
控制器:
<?php
namespace frontend\controllers;
use Yii;
use frontend\models\User;
use yii\web\Controller;
use yii\web\session;
class UserController extends Controller
{
public $enableCsrfValidation = false;
public function actionCreate()
{
$model = new User();
if ($model->load(Yii::$app->request->post()) ) {
$res=$model->getpost();
//判断用户名称是否正确
if($res['u_name'])
{
//判断用户密码是否正确
if($res['u_pwd']==$_POST['User']['u_pwd']){
$session = Yii::$app->session;
$session->set('u_id',$res['u_id']);
echo "<script>alert('登陆成功');location.href='index.php?r=user/question'</script>";
}else{
echo "<script>alert('密码错误,重新登陆');location.href='index.php?r=user/create'</script>";
}
}else{
echo "<script>alert('用户名不存在,重新登陆');location.href='index.php?r=user/create'</script>";
}
} else {
return $this->render('create', [
'model' => $model,
]);
}
}
//显示问题
public function actionQuestion(){
$model = new User();
//查出所有问题
$row=$model->getList();
//查询所有答案
$res=$model->getanswer();
//取出十条数据里的值
$key=array_rand($row,10);//键名
foreach($key as $key1=>$val)
{
$que[]=$row[$val];
}
//遍历数组
foreach($que as $key=>$row1){
foreach($res as $key2=>$res1){
if($row1['question_id']==$res1['question_id']){
$que[$key]['answer'][]=$res1;
}
}
}
return $this->renderPartial('test',['row'=>$que]);
}
//得出成绩
public function actionAdd1(){
//var_dump($_POST);die;
$model = new User();
$rank=$model->getinfo();
//echo $rank;die;
return $this->renderPartial('rank',['rank'=>$rank]);
}
}
模型层:
//判断用户登陆是否正确
public function getpost()
{
//var_dump($_POST);die;
//接收数据
$u_name=$_POST['User']['u_name'];
$u_pwd=$_POST['User']['u_pwd'];
//查询语句
$row=Yii::$app->db->CreateCommand("select * from user where u_name='$u_name'")->queryone();
//var_dump($row);die;
return $row;
}
//先查出所有问题
public function getList(){
//随机查询10条语句
//$row=Yii::$app->db->CreateCommand("select * from question order by rand() limit 10")->queryall();
$row=Yii::$app->db->CreateCommand("select * from question")->queryall();
//var_dump($row);die;
return $row;
}
//查询所有问题
public function getanswer(){
//查询语句
$row=Yii::$app->db->CreateCommand("select * from answer")->queryall();
//var_dump($row);die;
return $row;
}
//查询答案id下的正确结果
public function getinfo()
{
$answer_id=implode(",",$_POST);
//var_dump($_POST);die;
//查询语句
$row=Yii::$app->db->CreateCommand("select count(*) from answer where answer_id in($answer_id) and answer_state=1")->queryScalar();
//var_dump($row);die;
//获取登录的用户id
$session = Yii::$app->session;
$u_id = $session->get('u_id');
//添加成绩入库
$data=Yii::$app->db->CreateCommand()->insert("rank",['rank'=>$row,'u_id'=>$u_id])->execute();
return $row;
}
视图层:
<center><h3>欢迎来到考试页面</h3></center>
<form action="index.php?r=user/add1" method="post">
<table>
<?php foreach($row as $key=>$v) {?>
<tr>
<td>
<?php echo $v['question_id'];?>.<?php echo $v['question'];?>()
</td>
</tr>
<tr>
<?php foreach($v['answer'] as $key=>$v1) {?>
<td><input type="radio" name="<?php echo $v1['question_id'];?>" value="<?php echo $v1['answer_id'];?>">
<?php echo $v1['answer']?>
</td>
</tr>
<?php }?>
<?php }?>
<tr>
<td><input type="submit" value="提交试卷" /></td>
</tr>
</form>
</table>