PjzyfesA

1method: "POST",
2    url: "submit.php",
3    data: JSON.stringify(this.sendObj),
4    headers: {
5        "Content-Type": "application/json",
6        charset: "utf-8"
7    }
8	
9$postData = file_get_contents("php://input");
10$data = json_decode(utf8_encode($postData), true);
11
12$table = $data['table'];
13$name = $data['name'];
14$email = $data['email'];
15$points = $data['points'];
16$percentage = $data['percentage'];
17$userAnswers = $data['userAnswers'];
18
19function connect_DB($servername, $username, $password, $database) {
20    $db_conn  = new mysqli($servername, $username, $password, $database);
21    $char = $db_conn->query("SET NAMES 'utf8'");
22
23    if ($db_conn->connect_error) {
24        header($_SERVER['SERVER_PROTOCOL'] . ' 500 Internal Server Error', true, 500);
25        die("Connection failed: " . $db_conn->connect_error);
26    }
27    else {
28        echo "Connected successfully rn";
29    }
30    return $db_conn;
31}
32
33function create_DB_table($db, $table) {
34    $sql = "CREATE TABLE IF NOT EXISTS $table (
35        id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
36        reg_date TIMESTAMP
37    )";
38
39    if ($db->query($sql) == TRUE) {
40         echo "Table successfully created rn";
41     }
42     else {
43         header($_SERVER['SERVER_PROTOCOL'] . ' 500 Internal Server Error', true, 500);
44         die("Table creation failed: " . $db->error);
45
46     }
47}