submit.php

<?php

/*
    1. THIS HANDLES SUBMIT ACTIONS FROM INDEX.PHP FILE
        FIRST OF ALL, RUNS THE DATABASE (DB.PHP) TO ESTABLISH THE CONNECTION
    2. FIRST CHECKS WEATHER THE FORM CLICKED HAS POST DATA
    3. THEN EXTRACTS THE EXPECTED GLOBAL VARIABLES FROM THE POST ARRAY
    4. USING THE CONNECTION, PREPARES A STATEMENT QUERY TO BE EXECUTED
        <SORRY FORGOT TO HANDLE ERRORS HERE>
    5. EXECUTES THE QUERY TO INSERT RECORDS TO THE DB AND RE-LOADS THE INDEX PAGE
        OBVIOUSLY, THE FETCH.DB SCRIPT WILL RELOAD THE DATA FROM THE DATABASE
        AND THUS UPDATING THE REGISTERED STUDENTS
*/


include 'db.php';

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $name = $_POST['name'];
    $age = $_POST['age'];
    $reg_no = $_POST['reg_no'];

    $stmt = $conn->prepare("INSERT INTO students (name, age, reg_no) VALUES (?, ?, ?)");
    $stmt->bind_param("sis", $name, $age, $reg_no);

    if ($stmt->execute()) {
        header("Location: index.php");
        exit();
    } else {
        echo "Error: " . $stmt->error;
    }

    $stmt->close();
}
?>