| Server IP : 162.0.232.25 / Your IP : 18.221.157.203 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 : |
<?php
include 'connect.php';
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 8;
$offset = ($pageno - 1) * $no_of_records_per_page;
$total_pages_sql = "SELECT COUNT(*) FROM `ulbum`";
$result = mysqli_query($conn, $total_pages_sql);
$total_rows = mysqli_fetch_array($result)[0];
$total_pages = ceil($total_rows / $no_of_records_per_page);
?>
<!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/animate.css">
<link rel="stylesheet" type="text/css" href="./css/load.css">
<link rel="stylesheet" type="text/css" href="./css/w3.css">
<link rel="icon" type="x-icon" href="Icons/malawisounds.ico">
<link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="impact/stylesheet.css">
<script type="text/javascript" src="js/ajax.js"></script>
<title>Malawisounds - Albums</title>
<style>
.gutter-1{padding-left:5px;padding-right:7px;}
</style>
</head>
<body>
<div class="margin">
<?php include './header.php'; ?>
<!--Search bar-->
<input type="text" id="search" placeholder=" SEARCH-MUSIC, ARTISTS" onkeyup="findmatch(this.value)" class="glyphicon glyphicon-search">
<!--search results goes here-->
<div id="results" class="w3-container w3-light-grey"></div>
<!-- End of nav Bar -->
<?php
include 'connect.php';
/////////////////////////////////////////////////////////ARTISTS/////////////////////////////////////////////
//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 class=\"w3-display-container\">";
echo "<table>";
echo "<tr>";
while ($row = mysqli_fetch_array($query_run)) {
$path = $row['path'];
$name = $row['artist_name'];
$details = $row['artist_details'];
$genre = $row['genre'];
$city = $row['city'];
$views = $row['views'];
$id = $row['id'];
?>
<td>
<a href="artist=<?php echo str_replace(' ', '-', $name); ?>" target="_parent">
<img src="bio/<?php echo $path; ?>" alt="artist" />
</a>
</td>
<?php
}
echo "</tr>";
echo "</table>";
echo "</center>";
echo "</div>";
} else {
die(mysqli_error($conn));
}
?>
<div class="container-fluid">
<div class="row">
<?php
//////////////////////////////////////////////////////ALBUM//////////////////////////////////////////////////
//sql to retrieve albums
$sql1 = "SELECT * FROM `ulbum` ORDER BY `id` DESC LIMIT $offset, $no_of_records_per_page";
if ($query_run = mysqli_query($conn, $sql1)) {
if (mysqli_num_rows($query_run) > 0) {
echo "<div style=\"background-color:#dfe7ec;\">";
while ($row = mysqli_fetch_array($query_run)) {
$id = $row['id'];
$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>";
echo "</div>";
}
} else {
die(mysqli_error($conn));
}
?>
</div>
</div>
<!-- Pagination -->
<div class="w3-center">
<div class="w3-bar">
<?php
for ($x = 1; $x <= 1; $x++) {
echo "<a href=\"?pageno=$x\" class=\"w3-button\">$x</a>";
}
?>
<a href="<?php if ($pageno <= 1) {
echo '#';
} else {
echo "?pageno=" . ($pageno - 1);
} ?>" class="w3-button">prev</a>
<a href="<?php if ($pageno == $total_pages) {
echo '#';
} else {
echo "?pageno=" . ($pageno + 1);
} ?>" class="w3-button">next</a>
<?php
echo "<a href=\"?pageno=$total_pages\" class=\"w3-button\">$total_pages</a>";
?>
</div>
</div>
<?php
/////////////////////////////////////////////////////////////ADVERT/////////////////////////////////////////////
//query for selecting adverts from db
$sql3 = "SELECT aid,ads_name FROM `ads` ORDER BY `aid` DESC";
if ($query_run = mysqli_query($conn, $sql3)) {
list($id, $imagepath) = mysqli_fetch_array($query_run);
echo "<div style=\"overflow-x:auto;background-color:#b7b7b7;\" class=\"merchandise\">";
echo "<table>";
echo "<tr>";
?>
<td>
<center><img src="ads/<?php echo $imagepath; ?>" alt="advert" /></center>
</td>
<?php
echo "</tr>";
echo "</table>";
echo "</div>";
} else {
die(mysqli_error($conn));
}
?>
<!-- Footer -->
<?php include './footer.php'; ?>
</div>
</body>
</html>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/nav.js"></script>
<script src="./js/wow.js"></script>
<script type="text/javascript">
function _(selector) {
return document.querySelectorAll(selector);
}
_("ul li a")[3].style.backgroundColor = "#3f4243";
_("ul li a")[3].style.Color = "white";
function splash(id) {
id = 'ad' + id;
document.getElementById(id).style.display = "block";
}
//scripts for trimming album title
x = _(".album_container h4");
for (i = 0; i < x.length; i++) {
if (x[i].innerText.length > 18) {
y = x[i].innerText.slice(0, 18);
z = x[i].innerHTML = y + "...";
}
}
//scripts for trimming album title
x = _(".album_container h5");
for (i = 0; i < x.length; i++) {
if (x[i].innerText.length > 28) {
y = x[i].innerText.slice(0, 28);
z = x[i].innerHTML = y + "...";
}
}
/* Animated Wow Js */
new WOW().init();
</script>