| Server IP : 162.0.232.25 / Your IP : 3.15.15.91 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>
<head>
<title>Home</title>
<link rel="icon" type="x-icon" href="Icons/malawisounds.ico">
<link rel="stylesheet" type="text/css" href="./css/animate.css">
<link rel="stylesheet" type="text/css" href="css/load.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" />
<meta name="viewport" content="width=device-width,initial-scale=1.0" />
<meta charset="UTF-8" />
<script type="text/javascript" src="js/ajax.js"></script>
<style type="text/css">
.box1 table tr td img {
width: 200px;
height: 200px;
object-fit: cover;
object-position: center;
}
.box1 .move_trapezoid_content {
top: 12px;
}
@media screen and (max-width:700px) {
.box1 .trapezoid {
border-bottom: 50px solid #b4c7d1;
}
.box1 .move_trapezoid_content {
top: 10px;
}
}
@media screen and (max-width:610px) {
.box1 table tr td img {
width: 150px;
height: 150px;
}
}
@media screen and (max-width:548px) {
.box1 .trapezoid {
font-size: 21px;
padding-left: 5px;
}
.box1 .rectangoid {
font-size: 21px;
padding-left: 5px;
}
}
@media screen and (max-width:468px) {
.box1 table tr td img {
width: 100px;
height: 100px
}
.box1 .trapezoid {
font-size: 19px;
padding-left: 7px;
border-right: 45px solid transparent;
border-bottom: 40px solid #b4c7d1;
width: 75%;
}
}
@media screen and (max-width:324px) {
.box1 table tr td img {
width: 85px;
height: 85px
}
.box1 .trapezoid {
border-right: 20px solid transparent;
font-size: 16px;
border-bottom: 30px solid #b4c7d1;
}
.box1 .rectangoid {
font-size: 16px;
}
.box1 .move_trapezoid_content {
top: 6px;
}
}
@media screen and (max-width:260px) {
.box1 table tr td img {
width: 70px;
height: 70px
}
}
@media screen and (max-width:230px) {
.box1 table tr td img {
width: 57px;
height: 57px
}
}
</style>
</head>
<body>
<div class="box1">
<!-- top feature thumbnail -->
<div class="trapezoid">
<div class="move_trapezoid_content">TOP ARTISTS</div>
</div>
<?php
include 'connect.php';
/////////////////////////////////////////////////////TOP FEATURE/////////////////////////////////////////////
//query for selecting artists
$sql1 = "SELECT * FROM `biography` WHERE `trending`=1 ORDER BY `id` DESC";
if ($query_run = mysqli_query($conn, $sql1)) {
echo "<div class=\"artist_table\">";
echo "<center>";
echo "<table>";
echo "<tr>";
while ($row = mysqli_fetch_array($query_run)) {
$path = $row['path'];
$name = $row['artist_name'];
$id = $row['id'];
?>
<td>
<a href="artist=<?php echo str_replace(' ', '-', $name); ?>" target="_parent">
<img src="bio/<?php echo $path; ?>" alt="<?php echo $name; ?>" />
</a>
</td>
<?php
}
echo "</tr>";
echo "</table>";
echo "</center>";
echo "</div>";
} else {
die(mysqli_error($conn));
}
/////////////////////////////////////////////////////TRENDING/////////////////////////////////////////////
?>
<!-- top feature thumbnail -->
<div class="rectangoid" style="margin-bottom:5px;">
<div class="move_rectangoid_content">TRENDING</div>
</div>
<?php
//query for selecting first 3 trending songs
$sql2 = "SELECT * FROM `tbl_uploads` WHERE `song_type`='promo' AND `verify`=1 ORDER BY `id` DESC LIMIT 3";
//running the query
if ($query_run = mysqli_query($conn, $sql2)) {
//retrieving rows from database
while ($row = mysqli_fetch_array($query_run)) {
$id = $row['id'];
$title = $row['title'];
$artist = $row['artist'];
$titleurl = str_replace(' ', '-', $title);
$artisturl = str_replace(' ', '-', $artist);
$path = $row['file'];
$imagepath = $row['image'];
$listen = $row['listened'];
$mode = $row['song_mode'];
$price = $row['price'];
//displaying free songs
if ($mode == 'free') { ?>
<div class="w3-center wow fadeInUp" data-wow-delay="0.5s">
<div class="w3-display-container">
<img src="images/<?php echo $imagepath; ?>" src="images/<?php echo $imagepath; ?>" alt="<?php echo $title; ?>" style="border-radius:8px;" />
<img src="Icons/new.png" alt="new" class="w3-display-topright new" />
</div>
<h4 class="w3-text-blue trim"><?php echo $artist . '-' . $title; ?></h4>
<h4 style="float:left;padding-left:10px;">
<div class="glyphicon glyphicon-download-alt"></div> <a href="<?php echo "$id-$titleurl-by-$artisturl" ?>" target="_parent">DOWNLOAD</a>
</h4>
<h4 style="float:right;padding-right:10px;">
<div class="glyphicon glyphicon-headphones"></div> <a href="sid-<?php echo "$id-" . strtolower(str_replace(' ', '-', $title)) . '-by-' . strtolower(str_replace(' ', '-', $artist)); ?>" target="_parent">STREAM</a>
</h4>
</div>
<hr class="clear">
<?php
}
//displaying payed songs
else if ($mode == 'buy') { ?>
<div class="w3-center wow fadeInUp" data-wow-delay="0.5s">
<div class="w3-display-container">
<img src="images/<?php echo $imagepath; ?>" alt="<?php echo $title; ?>" style="border-radius:8px;" />
<img src="Icons/new.png" alt="new" class="w3-display-topright new" />
</div>
<h4 class="w3-text-blue trim"><?php echo $artist . '-' . $title; ?></h4>
<h4 style="float:left;padding-left:10px;">
<div class="glyphicon glyphicon-shopping-cart"></div> <a href="<?php echo "$id-buy-$titleurl-by-$artisturl" ?>" target="_parent">BUY</a>
</h4>
<h4 style="float:right;padding-right:10px;">K<?php echo $price; ?></h4>
</div>
<hr class="clear">
<?php
}
}
} else {
die('query run error' . mysqli_error($conn));
}
//query for selecting first remaing trending songs
$sql2 = "SELECT * FROM `tbl_uploads` WHERE `song_type`='promo' AND `verify`=1 ORDER BY `id` DESC LIMIT 3,50";
//running the query
if ($query_run = mysqli_query($conn, $sql2)) {
//retrieving rows from database
while ($row = mysqli_fetch_array($query_run)) {
$id = $row['id'];
$title = $row['title'];
$artist = $row['artist'];
$titleurl = str_replace(' ', '-', $title);
$artisturl = str_replace(' ', '-', $artist);
$path = $row['file'];
$imagepath = $row['image'];
$listen = $row['listened'];
$mode = $row['song_mode'];
$price = $row['price'];
//displaying free songs
if ($mode == 'free') { ?>
<div class="w3-center wow fadeInUp" data-wow-delay="0.5s">
<img src="images/<?php echo $imagepath; ?>" alt="<?php echo $title; ?>" style="border-radius:8px;" />
<h4 class="w3-text-blue trim"><?php echo $artist . '-' . $title; ?></h4>
<h4 style="float:left;padding-left:10px;">
<div class="glyphicon glyphicon-download-alt"></div> <a href="<?php echo "$id-$titleurl-by-$artisturl" ?>" target="_parent">DOWNLOAD</a>
</h4>
<h4 style="float:right;padding-right:10px;">
<div class="glyphicon glyphicon-headphones"></div> <a href="sid-<?php echo "$id-" . strtolower(str_replace(' ', '-', $title)) . '-by-' . strtolower(str_replace(' ', '-', $artist)); ?>" target="_parent">STREAM</a>
</h4>
</div>
<hr class="clear">
<?php
}
//displaying payed songs
else if ($mode == 'buy') { ?>
<div class="w3-center wow fadeInUp" data-wow-delay="0.5s">
<img src="images/<?php echo $imagepath; ?>" alt="<?php echo $title; ?>" style="border-radius:8px;" />
<h4 class="w3-text-blue trim"><?php echo $artist . '-' . $title; ?></h4>
<h4 style="float:left;padding-left:10px;">
<div class="glyphicon glyphicon-shopping-cart"></div> <a href="<?php echo "$id-buy-$titleurl-by-$artisturl" ?>" target="_parent">BUY</a>
</h4>
<h4 style="float:right;padding-right:10px;">K<?php echo $price; ?></h4>
</div>
<hr class="clear">
<?php
}
}
} else {
die('query run error' . mysqli_error($conn));
}
/////////////////////////////////////////////////////////////////RECENTLY UPLOADED SONGS/////////////////////////////////////////////////////////
?>
<!-- Recently uploaded songs -->
<div class="rectangoid" style="margin-bottom:5px;">
<div class="move_rectangoid_content">RECENTLY UPLOADED</div>
</div>
<?php
$sql = "SELECT * FROM `tbl_uploads` WHERE `song_type`='regular' AND `verify`=1 ORDER BY `id` DESC LIMIT 3";
if ($query_run = mysqli_query($conn, $sql)) {
while ($row = mysqli_fetch_array($query_run)) {
$id = $row['id'];
$title = $row['title'];
$artist = $row['artist'];
$imagepath = $row['image'];
$titleurl = str_replace(' ', '-', $title);
$artisturl = str_replace(' ', '-', $artist);
$price = $row['price'];
$mode = $row['song_mode'];
$verify = $row['verify'];
//displaying free songs
if ($mode == 'free') { ?>
<div class="w3-center wow fadeInUp" data-wow-delay="0.5s">
<img src="images/<?php echo $imagepath; ?>" alt="<?php echo $title; ?>" style="border-radius:8px;" />
<h4 class="w3-text-blue trim"><?php echo $artist . '-' . $title; ?></h4>
<h4 style="float:left;padding-left:10px;">
<div class="glyphicon glyphicon-download-alt"></div> <a href="<?php echo "$id-$titleurl-by-$artisturl" ?>" target="_parent">DOWNLOAD</a>
</h4>
<h4 style="float:right;padding-right:10px;">
<div class="glyphicon glyphicon-headphones"></div> <a href="sid-<?php echo "$id-" . strtolower(str_replace(' ', '-', $title)) . '-by-' . strtolower(str_replace(' ', '-', $artist)); ?>" target="_parent">STREAM</a>
</h4>
</div>
<hr class="clear">
<?php
}
//displaying payed songs
else if ($mode == 'buy') { ?>
<div class="w3-center wow fadeInUp" data-wow-delay="0.5s">
<img src="images/<?php echo $imagepath; ?>" alt="<?php echo $title; ?>" style="border-radius:8px;" />
<h4 class="w3-text-blue trim"><?php echo $artist . '-' . $title; ?></h4>
<h4 style="float:left;padding-left:10px;">
<div class="glyphicon glyphicon-shopping-cart"></div> <a href="<?php echo "$id-buy-$titleurl-by-$artisturl" ?>" target="_parent">BUY</a>
</h4>
<h4 style="float:right;padding-right:10px;">K<?php echo $price; ?></h4>
</div>
<hr class="clear">
<?php
}
}
} else {
die(mysqli_error($conn));
}
///////////////////////////////////LATEST VIDEOS/////////////////////////////////////////
?>
<!-- top feature thumbnail -->
<div class="trapezoid">
<div class="move_trapezoid_content">LATEST VIDEOS</div>
</div>
<?php
$sql4 = "SELECT * FROM `videos` ORDER BY `id` DESC LIMIT 3";
if ($run_query = mysqli_query($conn, $sql4)) {
while ($row = mysqli_fetch_array($run_query)) {
$title = $row['title'];
$artist = $row['artist'];
$youtube = $row['youtube'];
?>
<div class="videos">
<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>
<?php
}
} else {
die(mysqli_error($conn));
}
?>
</div>
</body>
</html>
<script src="./js/wow.js"></script>
<script type="text/javascript">
function splash(id) {
id = 'ad' + id;
document.getElementById(id).style.display = "block";
}
//scripts for trimming song titles
x = document.querySelectorAll(".trim");
for (i = 0; i < x.length; i++) {
y = x[i].innerHTML;
if (y.length <= 25) {
z = x[i].innerHTML;
} else {
y = x[i].innerHTML.slice(0, 25);
z = x[i].innerHTML = y + "...";
}
}
/* Animated Wow Js */
new WOW().init();
</script>