OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	03/31/2025 06:36:42 AM	rwxr-xr-x
📄 dashboard.php	3.64 KB	03/26/2025 03:48:05 AM	rw-r--r--
📄 hpsdb.php	351 bytes	03/26/2025 03:48:05 AM	rw-r--r--
📄 index.php	3.82 KB	03/26/2025 03:48:05 AM	rw-r--r--
📄 send_otp.php	795 bytes	03/26/2025 03:48:05 AM	rw-r--r--
📄 submit_form.php	7.17 KB	03/26/2025 03:48:05 AM	rw-r--r--
📄 verify_otp.php	4.86 KB	03/26/2025 03:48:05 AM	rw-r--r--

Editing: dashboard.php

<?php
include 'hpsdb.php';

// SQL query to fetch all records from the students table
$sql = "SELECT * FROM students";
$result = $hpsdb->query($sql);

// Check if the query returned any rows
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Students Table</title>
    <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #f4f7fa;
            color: #333;
            margin: 0;
            padding: 20px;
        }

h1 {
            text-align: center;
            color: #5c6bc0;
        }

table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 20px;
            box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
        }

th,
        td {
            padding: 12px;
            text-align: left;
            border: 1px solid #ddd;
        }

th {
            background-color: #5c6bc0;
            color: #fff;
        }

tr:nth-child(even) {
            background-color: #f2f2f2;
        }

tr:hover {
            background-color: #e0e0e0;
        }

.container {
            max-width: 1200px;
            margin: 0 auto;
            padding: 20px;
            background-color: #fff;
            border-radius: 8px;
            box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1);
        }

.no-records {
            text-align: center;
            font-size: 18px;
            color: #888;
        }

.footer {
            text-align: center;
            margin-top: 40px;
            font-size: 14px;
            color: #777;
        }
    </style>
</head>

<body>

<div class="container">
        <h1>Students Table</h1>

<?php
        // Check if there are records
        if ($result->num_rows > 0) {
            // Start the HTML table
        ?>
            <table>
                <thead>
                    <tr>
                        <th>ID</th>
                        <th>Name</th>
                        <th>Date of Birth</th>
                        <th>Father's Name</th>
                        <th>House Color</th>
                        <th>Year of Passing</th>
                        <th>Email</th>
                        <th>Phone Number</th>
                        <th>Verified</th>
                    </tr>
                </thead>
                <tbody>
                    <? while ($row = $result->fetch_assoc()) {
                    ?>
                        <tr>
                            <td><?= $row['id'] ?></td>
                            <td><?= $row['name'] ?></td>
                            <td><?= $row['dob'] ?></td>
                            <td><?= $row['father_name'] ?></td>
                            <td><?= $row['house_color'] ? $row['house_color'] : 'N/A' ?></td>
                            <td><?= $row['yop'] ?></td>
                            <td><?= $row['email'] ?></td>
                            <td><?= $row['phone_number'] ?></td>
                            <td><?= $row['isVerified'] == '1' ? 'Verified' : 'Not Verified' ?></td>
                        </tr>
                    <? } ?>
                </tbody>
            </table>
        <? } else { ?>
            <div class='no-records'>No records found.</div>
        <? }
        // Close the database connection
        $hpsdb->close();
        ?>
    </div>

</body>

</html>