function insert_exam_result($exam_id, $user_id, $score, $results) { //"result": [{"problem_id": 123,"type": 1,"selected_answer": ["A"],"result": 0,"score":0},{"problem_id":456,"type": 2,"selected_answer": ["A","B","C"],"result":1,"score": 2}] $link = @mysqli_connect(DB_HOST, ADMIN_ACCOUNT, ADMIN_PASSWORD, CONNECT_DB); if (!$link) { die(MSG_ERR_CONNECT_TO_DATABASE); } foreach ($results as $result) { $answer = get_answer_string($result->selected_answer); $str_query = <<<EOD INSERT INTO examanswer (ExamId, ProblemId, UserId, ProblemType, Score, Answer, Result) Values ({$exam_id}, {$result->problem_id}, {$user_id}, {$result->type}, {$result->score}, '{$answer}', {$result->result}) EOD; if (!mysqli_query($link, $str_query)) { return ERR_INSERT_DATABASE; } } return SUCCESS; }
$share_via_id = false; $bars_only = false; if (isset($_POST['count'])) { $count = $_POST['count']; } if (isset($_GET['id'])) { $warning = false; $share_id = $_GET['id']; $sharelink = '?id=' . $share_id; $share_via_id = true; $bars_only = true; if (substr_count($share_id, '-') == 1) { $items = explode('-', $share_id); $index = $items[0]; $subindex = intval($items[1]); $answerstring = get_answer_string('./data/visits.sav', $index, $subindex); $answers = str_split($answerstring); } } if (isset($_POST['ans']) and $_POST['ans'] != '') { $warning = false; $answerstring = $_POST['ans']; $answers = str_split($answerstring); $bars_only = false; } elseif (isset($_GET['ans']) and $_GET['ans'] != '') { $warning = false; $answerstring = $_GET['ans']; $answers = str_split($answerstring); $bars_only = false; } if ($warning) {