R E D

NAME	SIZE	PERMISSION
question.php	5.05 KB	-rwxr-xr-x
question_bak.php	3.13 KB	-rwxr-xr-x
save_test.php	4.96 KB	-rwxr-xr-x

Code Editor : question_bak.php

<?php
require_once("../../server/server.php");
header("Content-Type: application/json; charset=UTF-8");
// save data to database
$id_test = $_POST['id_test'];
$no_question = $_POST['no_question'];
$user = $_POST['user'];
$answer = $_POST['answer'];
$type = $_POST['type'];

$query = $db->query("INSERT INTO `user_answers` (`couse`, `user_id`, `no_question`, `no_choice`, `type_quiz`, `inp_date`, `upd_date`) VALUES ('$id_test', '$user', '$no_question', '$answer', '$type', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)");
if ($query) {
    $question = $db->query("SELECT no_question,question_text,question_img FROM `questions` WHERE `couse` = '$id_test' AND `no_question` > '$no_question' ORDER BY `no_question` ASC LIMIT 1");
    $data = $question->fetch(PDO::FETCH_ASSOC);
    if ($question->rowCount() == 0) {
        $count = 0;
        $query = $db->query("SELECT * FROM `user_answers` WHERE `couse` = '$id_test' AND `user_id` = '$user' AND `type_quiz` = '$type'");
        $data = array();
        while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
            $answer = $db->query("SELECT * FROM `answers` WHERE `couse` = '$id_test' AND `no_question` = '$row[no_question]'");
            $answer = $answer->fetch(PDO::FETCH_ASSOC);
            if ($answer['answers_true'] == $row['no_choice']) {
                $count++;
            }
        }
        if($type == "before"){
            $query = $db->query("INSERT INTO `sum_score` (`couse`, `user_id`, `score_before`, `score_after`, `status_pass`) VALUES ('$id_test', '$user', '$count', '0', 'n')");
            if($query){
                $data = array(
                    "status"=>"end",
                    "score"=>$count
                );
            }else{
                $data = array(
                    "status"=>"error",
                    "data"=>null
                );
            }
        }
        if($type == "after"){
            $query = $db->query("UPDATE `sum_score` SET `score_after` = '$count', `status_pass` = 'y' WHERE `sum_score`.`couse` = '$id_test' AND `sum_score`.`user_id` = '$user'");
            if($query){
                $data = array(
                    "status"=>"end",
                    "score"=>$count,
                    'redirect'=>'./ViewCouseMe'
                );
            }else{
                $data = array(
                    "status"=>"error",
                    "data"=>null,
                    'redirect'=>null
                );
            }
        }
    } else {
        $choice = $db->query("SELECT no_choice,choice_text,choice_img FROM `choices` WHERE `no_couse` = '$id_test' AND `no_question` = '$data[no_question]'");
        $choices = array();
        while ($row = $choice->fetch(PDO::FETCH_ASSOC)) {
            $choices[] = $row;
        }
        $data = array(
            "status" => "success",
            "data" => [
                "no_question" => $data['no_question'],
                "question_text" => $data['question_text'],
                "question_image" => $data['question_img'],
                "choice" => $choices
            ]
        );
    }
} else {
    $data = array(
        "status" => "error",
        "data" => null
    );
}

echo json_encode($data);

${this.title}

Code Editor : question_bak.php