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; }