healthup/exerciseslv2_submit.php at master · graysonhyc/healthup · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
<?php
session_start();
$score = 0;

//1_q
if (isset($_POST['1_q'])) {
    if ($_POST['1_q'] === "C") {
        $_SESSION['1_q'] = "Correct answer!";
        $score = $score + 10;
    } else {
        $_SESSION['1_q'] = "Wrong answer!";
    }
} else {
    $_SESSION['1_q'] = "Answer is missing!";
}

//2_q
if (isset($_POST['2_q_1']) || isset($_POST['2_q_2']) || isset($_POST['2_q_3'])
    || isset($_POST['2_q_4'])) {

    if (isset($_POST['2_q_1']) && isset($_POST['2_q_2']) && isset($_POST['2_q_3']) && isset($_POST['2_q_4'])) {
        $_SESSION['2_q'] = "Correct Answer!";
        $score = $score +10;
    } else {
        $_SESSION['2_q'] = "Wrong Answer!";
    }
} else {
    $_SESSION['2_q'] = "Answer is missing!";
}

//3_q
if (isset($_POST['3_q'])) {
    if ($_POST['3_q'] === "A") {
        $_SESSION['3_q'] = "Correct answer!";
        $score = $score + 10;
    } else {
        $_SESSION['3_q'] = "Wrong answer!";
    }
} else {
    $_SESSION['3_q'] = "Answer is missing!";
}

//4_q_1
if (isset($_POST['4_q_1']) && $_POST['4_q_1'] !== "") {
    if ($_POST['4_q_1'] === "True") {
        $_SESSION['4_q_1'] = "Correct answer!";
        $score = $score + 5;
    } else if ($_POST['4_q_1'] !== "Please select") {
        $_SESSION['4_q_1'] = "Wrong answer!";
    } else {
        $_SESSION['4_q_1'] = "Answer is missing!";
    }
}

//4_q_2
if (isset($_POST['4_q_2']) && $_POST['4_q_2'] !== "") {
    if ($_POST['4_q_2'] === "True") {
        $_SESSION['4_q_2'] = "Correct answer!";
        $score = $score + 5;
    } else if ($_POST['4_q_2'] !== "Please select") {
        $_SESSION['4_q_2'] = "Wrong answer!";
    } else {
        $_SESSION['4_q_2'] = "Answer is missing!";
    }
}

//5_q
if (isset($_POST['5_q']) && $_POST['5_q'] !== "") {
    if ($_POST['5_q'] === "30") {
        $_SESSION['5_q'] = "Correct answer!";
        $score = $score + 10;
    } else {
        $_SESSION['5_q'] = "Wrong answer!";
    }
} else {
    $_SESSION['5_q'] = "Answer is missing!";
}

$_SESSION['exercises_lv2_score'] = $score;

//db connection
$dbLocalhost = mysql_connect("localhost", "root", "") or die("Could not connect: " . mysql_error());
mysql_select_db("healthquizup", $dbLocalhost) or die("Could not find database: " . mysql_error());

$dbRecords = mysql_query("SELECT * FROM wp_exercisesquizscore
WHERE ID ='" . $_SESSION['user_id'] . "'", $dbLocalhost) or die("Problem reading table: " . mysql_error());
if ($arrRecords = mysql_fetch_assoc($dbRecords)){
    if ($arrRecords["exercises_lv2_score"] <= $score) {
        mysql_query("UPDATE wp_exercisesquizscore SET `exercises_lv2_score`='" . $score . "' WHERE ID ='" . $_SESSION['user_id'] . "'", $dbLocalhost);
    }
}
header ('Location: http://localhost/wordpress/level-2-exercises/');
?>