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) {
