D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
self
/
root
/
proc
/
self
/
root
/
home
/
markniuj
/
.vscode-server
/
data
/
User
/
History
/
1dd7a4e7
/
Filename :
S4fv.php
back
Copy
<?php include "config.php"; $records_per_page = 15; if (isset($_GET['speaker'])) { $speaker = urldecode($_GET['speaker']); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>speaker</title> <meta content="width=device-width, initial-scale=1.0" name="viewport"> <meta content="" name="keywords"> <meta content="" name="description"> <!-- Favicon --> <link href="img/favicon.ico" rel="icon"> <!-- Google Web Fonts --> <link rel="preconnect" href="https://fonts.googleapis.com"> <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin> <link href="https://fonts.googleapis.com/css2?family=Barlow:wght@600;700&family=Ubuntu:wght@400;500&display=swap" rel="stylesheet"> <!-- Icon Font Stylesheet --> <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.10.0/css/all.min.css" rel="stylesheet"> <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.4.1/font/bootstrap-icons.css" rel="stylesheet"> <!-- Libraries Stylesheet --> <link href="lib/animate/animate.min.css" rel="stylesheet"> <link href="lib/owlcarousel/assets/owl.carousel.min.css" rel="stylesheet"> <link href="lib/tempusdominus/css/tempusdominus-bootstrap-4.min.css" rel="stylesheet" /> <!-- Customized Bootstrap Stylesheet --> <link href="css/bootstrap.min.css" rel="stylesheet"> <!-- Template Stylesheet --> <link href="css/style.css" rel="stylesheet"> <link href="css/css.css" rel="stylesheet"> <link href="audio/css.css" rel="stylesheet"> </head> <body> <!-- Spinner Start --> <div id="spinner" class="show bg-white position-fixed translate-middle w-100 vh-100 top-50 start-50 d-flex align-items-center justify-content-center"> <div class="spinner-border text-primary" style="width: 3rem; height: 3rem;" role="status"> <span class="sr-only">Loading...</span> </div> </div> <!-- Spinner End --> <!-- Topbar Start --> <?php include 'include/topbar.php';?> <!-- Topbar End --> <!-- Navbar Start --> <?php include 'include/menu.php';?> <!-- Navbar End --> <!-- Service Start --> <div class="container-xxl service py-5"> <div class="container"> <div class="text-center wow fadeInUp" data-wow-delay="0.1s"> <h6 class="text-primary text-uppercase">// <?php echo $category; ?> //</h6> <h1 class="mb-5">Related speaker: <?php echo $speaker; ?></h1> </div> <div class="row g-4 wow fadeInUp" data-wow-delay="0.3s"> <div class="col-lg-12"> <div class="nav w-100 nav-pills me-12"> <?php $count_sql = "SELECT COUNT(*) AS total FROM audio_files WHERE speaker = '$speaker'"; $count_result = $conn->query($count_sql); $total_records = $count_result->fetch_assoc()['total']; $total_pages = ceil($total_records / $records_per_page); $page = isset($_GET['page']) ? $_GET['page'] : 1; $offset = ($page - 1) * $records_per_page; $sql = "SELECT * FROM audio_files WHERE speaker = '$speaker' ORDER BY upload_date DESC LIMIT $offset, $records_per_page"; $result = $conn->query($sql); if ($result->num_rows > 0) { echo "<table>"; echo "<tr><th>Name</th><th>Details</th><th>speaker</th><th>Date</th></tr>"; while ($row = $result->fetch_assoc()) { echo "<tr>"; echo "<td><a href='details.php?id=" . $row['id'] . "'>" . $row['english_title'] . "</a></td>"; echo "<td>" . $row['details'] . "</td>"; echo "<td>" . $row['speaker'] . "</td>"; echo "<td>" . $row['upload_date'] . "</td>"; echo "<td><a href='download.php?audio_filename=" . $row['audio_filename'] . "' title='Download'><i class='fa fa-download'></i></a></td>"; echo "</tr>"; } echo "</table>"; echo "<div class='pagination'>"; for ($i = 1; $i <= $total_pages; $i++) { echo "<a href='speaker.php?speaker=" . urlencode($speaker) . "&page=$i'>$i</a> "; } echo "</div>"; } else { echo "No records found for this speaker."; } $conn->close(); ?> </div> </div> </div> </div> </div> <!-- Service End --> <!-- Service End --> <!-- Footer Start --> <?php include 'include/footer.php';?> <!-- Footer End --> <!-- Back to Top --> <a href="#" class="btn btn-lg btn-primary btn-lg-square back-to-top"><i class="bi bi-arrow-up"></i></a> <!-- JavaScript Libraries --> <script src="https://code.jquery.com/jquery-3.4.1.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0/dist/js/bootstrap.bundle.min.js"></script> <script src="lib/wow/wow.min.js"></script> <script src="lib/easing/easing.min.js"></script> <script src="lib/waypoints/waypoints.min.js"></script> <script src="lib/counterup/counterup.min.js"></script> <script src="lib/owlcarousel/owl.carousel.min.js"></script> <script src="lib/tempusdominus/js/moment.min.js"></script> <script src="lib/tempusdominus/js/moment-timezone.min.js"></script> <script src="lib/tempusdominus/js/tempusdominus-bootstrap-4.min.js"></script> <!-- Template Javascript --> <script src="js/main.js"></script> </body> </html> <?php } ?>