| Server IP : 162.0.232.25 / Your IP : 13.58.180.210 Web Server : LiteSpeed System : Linux premium276.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : kwacuqig ( 988) PHP Version : 8.2.26 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/kwacuqig/learn.skilltainment.org/ |
Upload File : |
<?php
include './sidebar.php';
include './navbar.php';
if (isset($_GET['id'])) {
if (!empty($_GET['id'])) {
$pid = mysqli_real_escape_string($conn, $_GET['id']);
}
}
?>
<div class="container-fluid pt-4 px-4">
<div class="row g-2">
<div class="col-12">
<div class="bg-secondary rounded h-100 p-4">
<div class="table-responsive">
<table class="table playlist">
<thead>
<tr>
<th scope="col">Image</th>
<th scope="col">Title</th>
<th scope="col">Edit</th>
<th scope="col">Delete</th>
</tr>
</thead>
<tbody>
<?php
$query = "SELECT * FROM `playlists`,`videos` WHERE `playlists`.`pid`=`videos`.`pid` AND `playlists`.`pid`=$pid ORDER BY `videos`.`vid` DESC";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
while ($row = mysqli_fetch_array($run)) {
?>
<tr>
<td><img src="./playlists/img/<?php echo $row['image'];?>" class="rounded" alt=""></td>
<td><?php echo $row['video_title'];?></td>
<td><a href="video-edit.php?pid=<?php echo $pid.'&vid='.$row['vid']; ?>" class="btn btn-primary"><i class="fa fa-edit"></i></a></td>
<td><a href="video-delete.php?pid=<?php echo $pid.'&vid='.$row['vid']; ?>" onclick="return confirm('Confirm To Delete <?php echo $row['video_title']; ?>?')" class="btn btn-danger"><i class="fa fa-trash"></i></a></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<script>
document.querySelector("title").innerText="";
document.querySelectorAll(".navbar-nav a")[1].classList.add("active");
</script>
<?php
include './footer.php';
?>