| Server IP : 162.0.232.25 / Your IP : 3.144.227.187 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/redlighttunes.com/ |
Upload File : |
<?php
include './php/connect.php';
include './header.php';
include './sidebar.php';
if(isset($_GET['genre'])){
if(!empty($_GET['genre'])){
$genre=$_GET['genre'];
}
}
?>
<!-- main content -->
<main class="main">
<div class="container-fluid">
<div class="row row--grid">
<!-- breadcrumb -->
<div class="col-12">
<ul class="breadcrumb">
<li class="breadcrumb__item"><a href="home">Home</a></li>
<li class="breadcrumb__item breadcrumb__item--active"><?php echo $genre;?></li>
</ul>
</div>
<!-- end breadcrumb -->
</div>
<div class="row row--grid">
<?php
include './php/connect.php';
$query = "SELECT * FROM `singles` WHERE `genre`='$genre' ORDER BY `id` DESC";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
$id=$row['id'];
$artist_url=str_replace(' ','-',strtolower($row['artist']));
$title_url=str_replace(' ','-',strtolower($row['title']));
?>
<div class="col-12 col-md-6 col-xl-4 wow fadeInUp" data-wow-duration="0.7s" data-wow-delay="0.7s">
<ul class="main__list">
<li class="single-item">
<a data-link data-title="<?php echo $row['title']; ?>" data-artist="<?php echo $row['artist']; ?>" data-img="stream.php?sid=<?php echo $row['id']; ?>" href="./singles/audios/<?php echo $row['file']; ?>" class="single-item__cover">
<img src="./singles/covers/<?php echo $row['image']; ?>" alt="<?php echo $row['title']; ?>">
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M18.54,9,8.88,3.46a3.42,3.42,0,0,0-5.13,3V17.58A3.42,3.42,0,0,0,7.17,21a3.43,3.43,0,0,0,1.71-.46L18.54,15a3.42,3.42,0,0,0,0-5.92Zm-1,4.19L7.88,18.81a1.44,1.44,0,0,1-1.42,0,1.42,1.42,0,0,1-.71-1.23V6.42a1.42,1.42,0,0,1,.71-1.23A1.51,1.51,0,0,1,7.17,5a1.54,1.54,0,0,1,.71.19l9.66,5.58a1.42,1.42,0,0,1,0,2.46Z" />
</svg>
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M16,2a3,3,0,0,0-3,3V19a3,3,0,0,0,6,0V5A3,3,0,0,0,16,2Zm1,17a1,1,0,0,1-2,0V5a1,1,0,0,1,2,0ZM8,2A3,3,0,0,0,5,5V19a3,3,0,0,0,6,0V5A3,3,0,0,0,8,2ZM9,19a1,1,0,0,1-2,0V5A1,1,0,0,1,9,5Z" />
</svg>
</a>
<div class="single-item__title">
<h4><a href="single=<?php echo $id.'-'.$title_url.'-by-'.$artist_url?>"><?php echo $row['title']; ?></a></h4>
<span><a href="#"><?php echo $row['artist']; ?></a></span>
</div>
</li>
</ul>
</div>
<?php
}
?>
</div>
</div>
</main>
<!-- end main content -->
<?php
include './footer.php';
?>
<script>
document.querySelector("title").innerText = "Redlighttunes - <?php echo $genre;?>";
</script>
<?php
include './scripts.php';
?>