submitRecord.php

<?php
    session_start();
    // setup
    $host = "localhost";
    $username = "root";
    $password = "";
    $dbname = "spekmadb";
    
    // connect to db
    $conn = new mysqli($host, $username, $password, $dbname);

    // check if connection is errorless
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    // send sql query
    $score = (int)$_REQUEST["sc"] * 25;

    $gred = "";
    if ($score == 100) {
        $gred = "A";
    } elseif ($score >= 75) {
        $gred = "B";
    } elseif ($score >= 50) {
        $gred = "C";
    } else {
        $gred = "D";
    }

    $idpeng = $_REQUEST["ip"];
    $idsoalan = $_REQUEST["is"];
    $query = "UPDATE perekodan SET markah = $score, gred = '$gred'
    WHERE perekodan.idpeng = '$idpeng' AND perekodan.idsoalan = $idsoalan";
    $result = mysqli_query($conn, $query);

    echo $result;
?>