| Server IP : 162.0.232.25 / Your IP : 18.227.140.251 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/malawisounds.com/ |
Upload File : |
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="./css/load.css">
<link rel="stylesheet" type="text/css" href="./css/animate.css">
<link rel="stylesheet" type="text/css" href="./css/w3.css">
<link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="../impact/stylesheet.css" />
<style type="text/css">
.gutter-1 {
padding-left: 5px;
padding-right: 7px;
}
</style>
</head>
<body>
<?php
include 'connect.php';
if (isset($_GET['q'])) {
$search = mysqli_real_escape_string($conn, htmlentities($_GET['q']));
//////////////////////////////////////////////////singles/////////////////////////////////////////////////////////////
$sql = "SELECT * FROM `tbl_uploads` WHERE `artist` LIKE '%$search%' OR `title` LIKE '%$search%' AND `verify`=1";
if ($query_run = mysqli_query($conn, $sql)) {
?>
<h3>SINGLES</h3>
<div class="w3-text-ingigo"><b>RESULT : <?php echo mysqli_num_rows($query_run); ?></b></div>
<div class="container-fluid">
<div class="row">
<?php
if ($num_rows = mysqli_num_rows($query_run) > 0) {
while ($row = mysqli_fetch_array($query_run)) {
$id = $row['id'];
$title = $row['title'];
$artist = $row['artist'];
$genre = $row['genre'];
$size = $row['size'];
$path = $row['file'];
$imagepath = $row['image'];
$titleurl = str_replace(' ', '-', $title);
$artisturl = str_replace(' ', '-', $artist);
$downloads = $row['downloads'];
$price = $row['price'];
$mode = $row['song_mode'];
//displaying free songs
if ($mode == 'free') { ?>
<div class="w3-card-3 col-lg-4 col-sm-6 wow fadeInUp" data-wow-delay="0.5s">
<div class="respond">
<div class="model1">
<img src="images/<?php echo $imagepath ?>">
</div>
<div class="model2">
<a href="<?php echo "$id-$titleurl-by-$artisturl"; ?>"><?php echo "$title by $artist"; ?></a>
</div>
<div class="clear"></div>
</div>
</div>
<?php
}
//displaying payed songs
else if ($mode == 'buy') { ?>
<div class="w3-card-3 col-lg-4 col-sm-6 wow fadeInUp" data-wow-delay="0.5s">
<div class="respond">
<div class="model1">
<img src="images/<?php echo $imagepath ?>">
</div>
<div class="model2">
<a href="<?php echo "$id-buy-$titleurl-by-$artisturl" ?>"><?php echo "$title by $artist [K$price]"; ?></a>
</div>
<div class="clear"></div>
</div>
</div>
<?php
}
}
}
?>
</div>
</div>
<?php
} else {
die(mysqli_error($conn));
}
//////////////////////////////////////////////////////ALBUM//////////////////////////////////////////////////
//sql to retrieve albums
$sql1 = "SELECT * FROM `ulbum` WHERE `title` LIKE '%$search%' OR `artist` LIKE '%$search%'";
if ($run = mysqli_query($conn, $sql1)) {
echo '<h3>ALBUMS</h3>';
echo "<div class=\"w3-text-ingigo\"><b>RESULT : " . mysqli_num_rows($run) . "</b></div>";
?>
<div class="container-fluid">
<div class="row">
<?php
if (mysqli_num_rows($run) > 0) {
while ($row = mysqli_fetch_array($run)) {
$artist = $row['artist'];
$title = $row['title'];
$artisturl = str_replace(' ', '-', strtolower($row['artist']));
$titleurl = str_replace(' ', '-', strtolower($row['title']));
$path = $row['image'];
$genre = $row['genre'];
$date = $row['time'];
$mode = $row['mode'];
$price = $row['price'];
$type = $row['type'];
//checking if album/ep is for free
if ($mode == 'free') { ?>
<div class="col-lg-3 col-md-4 col-sm-6 col-xs-6 gutter-1 w3-hover-opacity wow fadeInUp" data-wow-delay="0.5s">
<div class="album_container">
<a href="<?php echo "$titleurl-by-$artisturl"; ?>">
<img src="album_images/<?php echo $path; ?>" alt="<?php echo $title; ?>" /><br>
<h4>
<?php echo $title; ?>
</h4>
<h5>
<?php echo $artist; ?>
</h5>
</a>
</div>
</div>
<?php
}
//checking if album/ep is payed
else if ($mode == 'buy') { ?>
<div class="col-lg-3 col-md-4 col-sm-6 col-xs-6 gutter-1 w3-hover-opacity wow fadeInUp" data-wow-delay="0.5s">
<div class="album_container">
<a href="<?php echo "buy-$titleurl-$type-by-$artisturl"; ?>">
<img src="album_images/<?php echo $path; ?>" alt="coverart" /><br>
<h4>
<span><?php echo "$title-$artist"; ?></span>
</h4>
<h5>
<?php echo "K$price"; ?>
</h5>
</a>
</div>
</div>
<?php
}
}
echo "<div class=\"clear\"></div>";
}
} else {
die(mysqli_error($conn));
}
?>
</div>
</div>
<?php
//////////////////////////////////////////////////////VIDEOS//////////////////////////////////////////////////
//sql to retrieve videos
$sql2 = "SELECT * FROM `videos` WHERE `title` LIKE '%$search%' OR `artist` LIKE '%$search%'";
if ($run2 = mysqli_query($conn, $sql2)) {
echo '<h3>VIDEOS</h3>';
echo "<div class=\"w3-text-ingigo\"><b>RESULT : " . mysqli_num_rows($run2) . "</b></div>";
if (mysqli_num_rows($run2) > 0) {
while ($row = mysqli_fetch_array($run2)) {
$id = $row['id'];
$title = $row['title'];
$artist = $row['artist'];
$youtube = $row['youtube'];
$artisturl = str_replace(' ', '-', strtolower($row['artist']));
$titleurl = str_replace(' ', '-', strtolower($row['title']));
?>
<div class="col-md-4 col-sm-6 wow fadeInUp" data-wow-delay="0.5s">
<div class="youtube">
<div class="iframe-container">
<iframe src="<?php echo "https://www.youtube.com/embed/$youtube"; ?>?autoplay=0&controls=1" allowfullscreen='true'></iframe>
</div>
<h5><?php echo "$title by $artist"; ?></h5>
</div>
</div>
<?php
}
echo "<div class=\"clear\"></div>";
}
}
}
?>
</body>
</html>
<script src="./js/wow.js"></script>
<script type="text/javascript">
function _(selector) {
return document.querySelectorAll(selector);
}
//scripts for trimming album title
x = _(".album_container h4");
for (i = 0; i < x.length; i++) {
if (x[i].innerText.length > 20) {
y = x[i].innerText.slice(0, 21);
z = x[i].innerHTML = y + "...";
}
}
//scripts for trimming song titles
x = document.querySelectorAll(".model2 a");
for (i = 0; i < x.length; i++) {
y = x[i].innerHTML;
if (y.length <= 28) {
z = x[i].innerHTML;
} else {
y = x[i].innerHTML.slice(0, 28);
z = x[i].innerHTML = y + "...";
}
}
/* Animated Wow Js */
new WOW().init();
</script>