| Server IP : 162.0.232.25 / Your IP : 3.144.227.73 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 './php/time.php';
include './header.php';
include './sidebar.php';
?>
<!-- main content -->
<main class="main">
<div class="container-fluid">
<!-- artists -->
<section class="row row--grid">
<?php
if (isset($_POST['search'])) {
$search = $_POST['search'];
?>
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M12.3,12.22A4.92,4.92,0,0,0,14,8.5a5,5,0,0,0-10,0,4.92,4.92,0,0,0,1.7,3.72A8,8,0,0,0,1,19.5a1,1,0,0,0,2,0,6,6,0,0,1,12,0,1,1,0,0,0,2,0A8,8,0,0,0,12.3,12.22ZM9,11.5a3,3,0,1,1,3-3A3,3,0,0,1,9,11.5Zm9.74.32A5,5,0,0,0,15,3.5a1,1,0,0,0,0,2,3,3,0,0,1,3,3,3,3,0,0,1-1.5,2.59,1,1,0,0,0-.5.84,1,1,0,0,0,.45.86l.39.26.13.07a7,7,0,0,1,4,6.38,1,1,0,0,0,2,0A9,9,0,0,0,18.74,11.82Z" />
</svg> Artists</h2>
</div>
</div>
<!-- end title -->
<div class="col-12">
<div class="row row--grid">
<?php
$query = "SELECT * FROM `artists` WHERE `artist` LIKE '%$search%'";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
?>
<div class="col-12">
<h4 style="color:yellow;">RESULTS: <?php echo $count; ?></h4>
</div>
<?php
while ($row = mysqli_fetch_array($run)) {
$id = $row['id'];
$artist = str_replace(' ', '-', strtolower($row['artist']));
?>
<div class="col-6 col-sm-4 col-md-3 col-xl-2 wow fadeInUp" data-wow-duration="0.7s" data-wow-delay="0.7s">
<a href="artist=<?php echo "$id-$artist"; ?>" class="artist wow fadeInUp" data-wow-duration="0.9s" data-wow-delay="0.4s">
<div class="artist__cover">
<img src="./artists/<?php echo $row['image']; ?>" alt="">
</div>
<h3 class="artist__title"><?php echo $row['artist']; ?></h3>
</a>
</div>
<?php
}
?>
</div>
</div>
</section>
<!-- end artists -->
<!-- Albums -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 496 512">
<path d="M248 8C111 8 0 119 0 256s111 248 248 248 248-111 248-248S385 8 248 8zM88 256H56c0-105.9 86.1-192 192-192v32c-88.2 0-160 71.8-160 160zm160 96c-53 0-96-43-96-96s43-96 96-96 96 43 96 96-43 96-96 96zm0-128c-17.7 0-32 14.3-32 32s14.3 32 32 32 32-14.3 32-32-14.3-32-32-32z" />
</svg> Albums</h2>
</div>
</div>
<!-- end title -->
<?php
$query = "SELECT * FROM `albums` WHERE `title` LIKE '%$search%' OR `artist` LIKE '%$search%'";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
?>
<div class="col-12">
<h4 style="color:yellow;">RESULTS: <?php echo $count; ?></h4>
</div>
<?php
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-6 col-sm-4 col-lg-2 wow fadeInUp" data-wow-duration="0.8s" data-wow-delay="1.0s">
<div class="album">
<div class="album__cover">
<img src="./albums/covers/<?php echo $row['image']; ?>" alt="<?php echo $row['title']; ?>">
<a href="<?php echo $row['type'] . "~$id-$title_url-by-$artist_url"; ?>"><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></a>
<span class="album__stat">
<span><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512">
<path d="M216 0h80c13.3 0 24 10.7 24 24v168h87.7c17.8 0 26.7 21.5 14.1 34.1L269.7 378.3c-7.5 7.5-19.8 7.5-27.3 0L90.1 226.1c-12.6-12.6-3.7-34.1 14.1-34.1H192V24c0-13.3 10.7-24 24-24zm296 376v112c0 13.3-10.7 24-24 24H24c-13.3 0-24-10.7-24-24V376c0-13.3 10.7-24 24-24h146.7l49 49c20.1 20.1 52.5 20.1 72.6 0l49-49H488c13.3 0 24 10.7 24 24zm-124 88c0-11-9-20-20-20s-20 9-20 20 9 20 20 20 20-9 20-20zm64 0c0-11-9-20-20-20s-20 9-20 20 9 20 20 20 20-9 20-20z" />
</svg> <?php echo $row['zip_downloads']; ?></span>
</span>
</div>
<div class="album__title">
<h3><a href="<?php echo $row['type'] . "~$id-$title_url-by-$artist_url"; ?>"><?php echo $row['title']; ?></a></h3>
<span><a href="#"><?php echo $row['artist']; ?></a></span>
</div>
</div>
</div>
<?php
}
?>
<!-- end albumss -->
<!-- Singles -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512">
<path d="M470.38 1.51L150.41 96A32 32 0 0 0 128 126.51v261.41A139 139 0 0 0 96 384c-53 0-96 28.66-96 64s43 64 96 64 96-28.66 96-64V214.32l256-75v184.61a138.4 138.4 0 0 0-32-3.93c-53 0-96 28.66-96 64s43 64 96 64 96-28.65 96-64V32a32 32 0 0 0-41.62-30.49z" />
</svg><a href="singles.php"> Singles</a></h2>
</div>
</div>
<!-- end title -->
<?php
$query = "SELECT * FROM `singles` WHERE `title` LIKE '%$search%' OR `artist` LIKE '%$search%'";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
?>
<div class="col-12">
<h4 style="color:yellow;">RESULTS: <?php echo $count; ?></h4>
</div>
<?php
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.8s" data-wow-delay="1.2s">
<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
}
?>
</section>
<!-- Videos -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 576 512">
<path d="M336.2 64H47.8C21.4 64 0 85.4 0 111.8v288.4C0 426.6 21.4 448 47.8 448h288.4c26.4 0 47.8-21.4 47.8-47.8V111.8c0-26.4-21.4-47.8-47.8-47.8zm189.4 37.7L416 177.3v157.4l109.6 75.5c21.2 14.6 50.4-.3 50.4-25.8V127.5c0-25.4-29.1-40.4-50.4-25.8z" />
</svg><a href="singles.php">Videos</a></h2>
</div>
</div>
<!-- end title -->
<?php
$query = "SELECT * FROM `videos` WHERE `title` LIKE '%$search%' OR `artist` LIKE '%$search%'";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
?>
<div class="col-12">
<h4 style="color:yellow;">RESULTS: <?php echo $count; ?></h4>
</div>
<?php
while ($row = mysqli_fetch_array($run)) {
?>
<div class="col-12 col-sm-6 col-md-4 wow fadeInUp" data-wow-duration="0.7s" data-wow-delay="1.0s">
<div class="live">
<a href="<?php echo $row['youtube']; ?>" class="live__cover open-video">
<img src="./youtube/<?php echo $row['thumbnail']; ?>" alt="">
<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"></path>
</svg>
</a>
<h3 class="live__title"><a href="<?php echo $row['youtube']; ?>" class="open-video"><?php echo $row['title']; ?></a></h3>
</div>
</div>
<?php
}
?>
</section>
<!-- news -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M16,14H8a1,1,0,0,0,0,2h8a1,1,0,0,0,0-2Zm0-4H10a1,1,0,0,0,0,2h6a1,1,0,0,0,0-2Zm4-6H17V3a1,1,0,0,0-2,0V4H13V3a1,1,0,0,0-2,0V4H9V3A1,1,0,0,0,7,3V4H4A1,1,0,0,0,3,5V19a3,3,0,0,0,3,3H18a3,3,0,0,0,3-3V5A1,1,0,0,0,20,4ZM19,19a1,1,0,0,1-1,1H6a1,1,0,0,1-1-1V6H7V7A1,1,0,0,0,9,7V6h2V7a1,1,0,0,0,2,0V6h2V7a1,1,0,0,0,2,0V6h2Z" />
</svg> News</h2>
</div>
</div>
<!-- end title -->
<!-- post -->
<?php
$query = "SELECT `nid`,`title`,`image`,`views`,UNIX_TIMESTAMP()-`date` as spent_time FROM `news` WHERE `title` LIKE '%$search%'";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
?>
<div class="col-12">
<h4 style="color:yellow;">RESULTS: <?php echo $count; ?></h4>
</div>
<?php
while ($row = mysqli_fetch_array($run)) {
?>
<!-- post -->
<div class="col-12 col-sm-6 col-lg-4 wow fadeInUp" data-wow-duration="0.5s" data-wow-delay="1.0s">
<div class="post">
<a href="article=<?php echo $row['nid']; ?>" class="post__img">
<img src="news/<?php echo $row['image']; ?>" alt="">
</a>
<div class="post__content">
<h3 class="post__title"><a href="article=<?php echo $row['nid']; ?>"><?php echo $row['title']; ?></a>
</h3>
<div class="post__meta">
<span class="post__date"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M12,2A10,10,0,1,0,22,12,10.01114,10.01114,0,0,0,12,2Zm0,18a8,8,0,1,1,8-8A8.00917,8.00917,0,0,1,12,20ZM14.09814,9.63379,13,10.26807V7a1,1,0,0,0-2,0v5a1.00025,1.00025,0,0,0,1.5.86621l2.59814-1.5a1.00016,1.00016,0,1,0-1-1.73242Z" />
</svg> <?php timeSpent($row['spent_time']); ?></span>
<span class="post__comments"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<i class="fa fa-eye"></i>
</svg> <?php echo $row['views']; ?></span>
</div>
</div>
</div>
</div>
<!-- end post -->
<?php
}
?>
<!-- end post -->
</section>
<!-- end news -->
<!-- store -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M8.5,19A1.5,1.5,0,1,0,10,20.5,1.5,1.5,0,0,0,8.5,19ZM19,16H7a1,1,0,0,1,0-2h8.49121A3.0132,3.0132,0,0,0,18.376,11.82422L19.96143,6.2749A1.00009,1.00009,0,0,0,19,5H6.73907A3.00666,3.00666,0,0,0,3.92139,3H3A1,1,0,0,0,3,5h.92139a1.00459,1.00459,0,0,1,.96142.7251l.15552.54474.00024.00506L6.6792,12.01709A3.00006,3.00006,0,0,0,7,18H19a1,1,0,0,0,0-2ZM17.67432,7l-1.2212,4.27441A1.00458,1.00458,0,0,1,15.49121,12H8.75439l-.25494-.89221L7.32642,7ZM16.5,19A1.5,1.5,0,1,0,18,20.5,1.5,1.5,0,0,0,16.5,19Z" />
</svg>Products</h2>
</div>
</div>
<!-- end title -->
<?php
include './php/connect.php';
$query = "SELECT * FROM `ads` WHERE `name` LIKE '%$search%'";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
?>
<div class="col-12">
<h4 style="color:yellow;">RESULTS: <?php echo $count; ?></h4>
</div>
<?php
while ($row = mysqli_fetch_array($run)) {
$id = $row['aid'];
$product = str_replace(' ', '-', strtolower($row['name']));
?>
<div class="col-6 col-md-6 col-lg-4 col-xl-3 wow fadeInUp" data-wow-duration="0.7s" data-wow-delay="0.7s">
<div class="product">
<div class="product__img">
<img src="./ads/<?php echo $row['image']; ?>" alt="<?php echo $row['name']; ?>">
<button class="product__add" type="button"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M19,11H13V5a1,1,0,0,0-2,0v6H5a1,1,0,0,0,0,2h6v6a1,1,0,0,0,2,0V13h6a1,1,0,0,0,0-2Z" />
</svg></button>
</div>
<h3 class="product__title"><a href="product=<?php echo "$id-$product"; ?>"><?php echo $row['name']; ?></a></h3>
<span class="product__price">K<?php echo $row['price']; ?></span>
</div>
</div>
<?php
}
?>
</section>
<!-- end store -->
</div>
</main>
<!-- end main content -->
<?php
}
include './footer.php';
?>
<script>
document.querySelector("title").innerText = "Redlighttunes - Home";
</script>
<?php
include './scripts.php';
?>