process.php

<?php
require 'DatabaseConnection.php'; 
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Get form data
    $email = $_POST['email'];
    $password = $_POST['password'];
    $firstName = $_POST['firstname'];
    $lastName = $_POST['lastname'];
    $address = $_POST['address'];
    $phone = $_POST['phoneNumber'];


    // Validate inputs
    if (empty($email) || empty($password) || empty($firstName) || empty($lastName) || empty($address) || empty($phone)) {
        echo "All fields are required.";
        exit;
    }

    // Create a new instance of the Database class
    $db = new Database();

    // Insert user into the database
    $sql = "INSERT INTO tblstudent (email, password, firstName, lastName, address, phoneNumber) VALUES (:email, :password, :firstName, :lastName, :address, :phoneNumber)";
    $params = [
        ':email' => $email,
        ':password' => $password,
        ':firstName' => $firstName,
        ':lastName' => $lastName,
        ':address' => $address,
        ':phoneNumber' => $phone
    ];

    try {
        $rowCount = $db->executeQuery($sql, $params);
        if ($rowCount > 0) {
            require 'header.php';
            echo "Registration successful!";
        } else {
            require 'header.php';
            echo "Failed to register.";
        }
    } catch (Exception $e) {
        echo "Error: " . $e->getMessage();
    }
}
?>