db.php

<?php

/*
    1. THIS IS USED TO ESTABLISH A CONNECTION TO THE DATABASE
    2. FIRST ASSUMES THAT MY PROFFESOR HAS SET HIS DATABASE TO DEFAULT,
        IF NOT, TROUBLE! EVERYTHING WILL NOT WORK
    3. SORUNDED A TRY TO WARN THE PROFFESIOR INCASE HE IS NOT USING DEFAULT SETTINGS
        IN THE CATCH BLOCK
    4. USES MY SQLI TO CREATE THE CONNECTION
    5. A BUNCH OF ERROR CHECKS AT EACH STAGE

    6. REMEMBER WHEN THE PROFESSOR OPENS MY FILE HE WONT BE HAVING THIS DATABASE 
        NAME IN HIS DATABASE, SO THIS PROGRAM SHOULD CHECK IF THE DATABASE NAMED 
        "STUDENTS" EXISTS IF NOT, IT WILL CREATE IT. LIKEWISE THE TABLES.

    THATS ALL
*/


$host = "localhost";
$user = "root";
$pass = "";
$dbname = "student_db";

try{
    $conn = new mysqli($host, $user, $pass);
    
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    // Create database if it does not exist
    $sql = "CREATE DATABASE IF NOT EXISTS $dbname";
    if ($conn->query($sql) === FALSE) {
        die("Error creating database: " . $conn->error);
    }

    // Select the database
    $conn->select_db($dbname);

    // Create students table if it does not exist
    $table_sql = "CREATE TABLE IF NOT EXISTS students (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL,
        age INT NOT NULL,
        reg_number VARCHAR(50) NOT NULL UNIQUE
    )";
    if ($conn->query($table_sql) === FALSE) {
        die("Error creating table: " . $conn->error);
    }

}catch(Exception $e){
    echo " <div class='error-message'>Unable to access the database, 
    Use username 'root' and pasword '' for your settings</div>";
}


?>