public function getResult()
{
$connectionDB = ConnectionDB::getInstance();
$mysqli = $connectionDB::connect();
$table = 'math_correct_answers';
$allAnswers = array();
$query = Mysqli_query($mysqli, "\n SELECT `sum_id`, `answer` FROM {$table}\n ");
while ($row = mysqli_fetch_assoc($query)) {
$allAnswers[$row['sum_id']] = $row['answer'];
}
$resultArray = array_intersect_assoc($allAnswers, $_SESSION['answers']);
$data = array();
$data['correctAnswers'] = count($resultArray);
$data['allAnswers'] = count($allAnswers);
$data = json_encode($data);
echo $data;
}
public function deleteSum()
{
$connectionDB = ConnectionDB::getInstance();
$mysqli = $connectionDB::connect();
$id = $_POST['id'];
$response = '';
$query = Mysqli_query($mysqli, "DELETE FROM math_sums WHERE id = " . $id);
if ($query) {
$response .= 'Deleted test ' . $id . 'from math_sums. ';
} else {
exit(mysqli_error($mysqli));
}
$query = Mysqli_query($mysqli, "DELETE FROM math_correct_answers WHERE sum_id = " . $id);
if ($query) {
$response .= 'Deleted test ' . $id . 'from math_correct_answers. ';
} else {
exit(mysqli_error($mysqli));
}
echo $response;
}
