OXIESEC PANEL

Name	Size	Modified	Perms
📁 ..	-	06/17/2025 10:17:24 AM	rwxrwxr-x
📄 admin.php	2.97 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 adminProcess	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📁 assets	-	02/15/2025 11:20:33 AM	rwxr-xr-x
📁 backup	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📄 editData.php	16.75 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 editQuestion.php	8.03 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 editQuiz.php	8.3 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 footer.php	1.86 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 forms	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📄 go_back.php	2.96 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 index.php	12.68 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 login.php	4.34 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 nav_scripts.php	1.96 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 navbar.php	2.41 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 navbar_login.php	2.34 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 payment.php	12.06 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 quiz.php	20.67 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 quizControl.php	8.4 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 quizQuestions.php	8.85 KB	05/19/2025 10:07:16 AM	rw-r--r--
📄 quizSubmitPage.php	39 bytes	05/19/2025 10:07:16 AM	rw-r--r--
📄 register.php	21.65 KB	05/19/2025 10:07:16 AM	rw-r--r--
📁 test	-	02/15/2025 11:20:34 AM	rwxr-xr-x
📁 test1	-	05/19/2025 10:07:16 AM	rwxr-xr-x
📁 yt_subscription	-	05/19/2025 10:07:16 AM	rwxr-xr-x

Editing: admin.php

<?php
include 'assets/php/validate.logged.php';
include 'assets/php/db_config.php';

// Fetch data from the table
function fetchCandidates()
{
    global $conn;
    $sql = "SELECT c.*, q.quiz_id, q.quiz_fee
    FROM candidate c
    LEFT JOIN quiz_status q ON c.id = q.user_id;";
    // $sql = "SELECT * FROM candidate";
    $result = $conn->query($sql);
    echo "<table>
    <thead>
        <tr>
            <th>ID</th>
            <th>Candidate details</th>
            <th>Address</th>
            <th>subscriptionStatus</th>
            <th>Quizes and Fee Paid</th>
        </tr>
    </thead>
    <tbody>";

// Check if data exists and output each row
    if ($result->num_rows > 0) {
        // Output data of each row
        $serial = 1;
        while ($row = $result->fetch_assoc()) {
            echo "<tr>
                <td>" . $serial . "</td>
                <td>" . "Name-" . $row["fullName"] . "<br>" . "email-" . $row["email"] . "<br>" . "mobile-" . $row["mobile"] . "<br>" . "DOB-" . $row["dob"] . "<br>" . "Gender-" . $row["gender"] . "</td>
                <td>" . $row["address"] . "<br>" . "city-" . $row["city"] . "<br>" . "state-" . $row["state"] . "<br>" . "pincode-" . $row["pincode"] . "</td>
                <td>" . (($row['subscriptionStatus']=='Y')?'Yes':'No') . "</td>
                <td>" . $row["quiz_id"] . "-" . (($row['quiz_fee']=='Y')?'Paid':'Not paid') . "</td>
              </tr>";
            $serial++;
        }
    } else {
        echo "<tr><td colspan='4'>No records found</td></tr>";
    }

echo "</tbody>
</table>";
    // Close connection
    $conn->close();
}
?>

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

<head>
        <meta charset='UTF-8'>
        <meta name='viewport' content='width=device-width, initial-scale=1.0'>
        <title>Admin Dashboard</title>
        <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
        <link rel="stylesheet" href="assets/css/styles.css">
        <style>
            table {
                width: 100%;
                border-collapse: collapse;
            }

table,
            th,
            td {
                border: 1px solid black;
            }

th,
            td {
                padding: 10px;
                text-align: left;
            }
        </style>
    </head>

<body>
        <header id="header" class="header d-flex align-items-center sticky-top">
            <div
                class="container-fluid container-xl position-relative d-flex align-items-center">
                <? include "navbar_login.php" ?>
                <a href="quizControl.php" style="color: black;">Quiz Control</a>
            </div>

</header>

<button onclick="window.location.href='dashboard.php'" style="border-radius: 10px;">Back</button>
        <h1>Registered Candidates</h1>
        <? fetchCandidates(); ?>
    </body>

</html>