fetch.php

<?php
/*
    1. THIS IS A PHP SCRIPT THAT IS ONLY CALLED IN THE INDEX.PHP FILE
        TO FILL THE TABLE OF REGISTERED STUDENTS
    2. FIRST CHECKS IF THE CONNECTION IS SET (NOT NULL) NOT TO THROW AN ERROR
        THEN FETCHES THE DATA 
    3. ECHOES (DRAWS ) TABLE HEADINGS
    4. BY ITERATING OVER THE FETCHED DATA UNTIL NONE IS LEFT,
        THE TABLE IS FILLED WITH THE DATA FROM THE DATABASE,
        THE LAST ACTION COLUMN IS ONLY FILLED WITH A DELETE BUTTON WITH A
        DELETE ACTION PASSING IN THE ID OF THE ITEM. WHEN CLICKED, THIS ID IS 
        PASSED TO THE DELETE.PHP SCRIPT DELETING THIS RECORD FROM THE DATABASE
    5. INCASE THERE WAS AN ERROR IN THE CONNECTION IN STEP(2) AN ERROR 
        MESSAGE IS DISPLAYED
    
    THATS ALL
*/

include 'db.php';
if (isset($conn)) {
    
        $result = $conn->query("SELECT * FROM students ORDER BY id DESC");
    
    echo "<table>
            <tr>
                <th>Name</th>
                <th>Age</th>
                <th>Registration Number</th>
                <th>Action</th>
            </tr>";

    while ($row = $result->fetch_assoc()) {
        echo "<tr>
                <td>{$row['name']}</td>
                <td>{$row['age']}</td>
                <td>{$row['reg_no']}</td>
                <td><button onclick='deleteStudent({$row['id']})'>Delete</button></td>
            </tr>";
    }
    echo "</table>";
} else {
    echo " <div class='error-message'>Unable to load registered studentss</div>";
}

?>