D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
self
/
root
/
proc
/
thread-self
/
root
/
home
/
markniuj
/
bazmeasar.com
/
admin
/
Filename :
speakers.php
back
Copy
<?php include "../config.php"; // Retrieve all unique speakers $query = "SELECT DISTINCT speaker FROM audio_files"; $result = $conn->query($query); // Store speakers in an array $speakers = []; if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $speakers[] = $row["speaker"]; } } // Close the database connection $conn->close(); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Speakers</title> <link rel="stylesheet" href="css.css"> </head> <body> <header> <div class="logo"><img src="logo.png"></div> </header> <div class="mainbody"> <div class="bodyarea"> <h1>Audio Speakers</h1> <!-- List all unique speakers and link to audio records by speaker --> <ul> <?php foreach ($speakers as $speaker) { ?> <li> <a href="speaker.php?speaker=<?php echo urlencode($speaker); ?>"><?php echo $speaker; ?></a> </li> <?php } ?> </ul> </div> </div> <footer> <a href="https://webograph.pk/">Site BY Webograph.pk</a> </footer> </body> </html>