1#@!#!123s

: / home / markniuj / bazmeasar.com / admin /
Filename : all-speakers.php
back
<?php include "../config.php"; ?>
<!DOCTYPE html>
<html>
<head>
    <title>Speaker Management</title>
        <meta content="width=device-width, initial-scale=1.0" name="viewport">
        <link href="css/style.css" rel="stylesheet">
        <link href="css.css" rel="stylesheet">
        <link href="audio/css.css" rel="stylesheet">
</head>
<body>
    <h1>Speaker Management</h1>

    <?php

    // Query to retrieve categories from the "categories" table
    $query = "SELECT spid, spname FROM speakers";
    $result = $conn->query($query);

    if ($result->num_rows > 0) {
        echo "<table border='1'>";
        echo "<tr><th>Speakers ID</th><th>Speakers Name</th><th>Edit</th><th>Delete</th></tr>";

        while ($row = $result->fetch_assoc()) {
            $spid = $row["spid"];
            $spname = $row["spname"];
            echo "<tr>";
            echo "<td>$spid</td>";
            echo "<td>$spname</td>";
            echo "<td><a href='edit_speaker.php?spid=$spid'>Edit</a></td>";
            echo "<td><a href='delete_speaker.php?spid=$spid'>Delete</a></td>";
            echo "</tr>";
        }

        echo "</table>";
    } else {
        echo "No categories found.";
    }

    $conn->close();
    ?>
</body>
</html>