| Server IP : 162.0.232.25 / Your IP : 18.189.194.225 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';
include 'hits.php';
if (isset($_GET['artist'])) {
$dropdown = mysqli_real_escape_string($conn, htmlentities($_GET['artist']));
$dropdown = str_replace('-', ' ', $dropdown);
if (!empty($dropdown)) {
$sql = "SELECT id,`path`,`artist_name`,`artist_details`,`genre`,`city`,`views` FROM `biography` WHERE `artist_name`='" . $dropdown . "'";
if ($query_run = mysqli_query($conn, $sql)) {
list($id, $path, $name, $details, $genre, $city, $views) = mysqli_fetch_array($query_run);
function update()
{
global $views, $conn, $id;
$seen = $views + 1;
$up = "UPDATE `biography` SET `views`='$seen' WHERE `id`=$id";
if (!$query = mysqli_query($conn, $up)) {
die(mysqli_error($conn));
}
}
update();
} else {
die(mysqli_error($conn));
}
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<link rel="icon" type="x-icon" href="Icons/malawisounds.ico">
<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="stylesheet" type="text/css" href="bootstrap/css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="impact/stylesheet.css" />
<script type="text/javascript" src="js/ajax.js"></script>
<title><?php echo "$name's Biography"; ?></title>
</style>
<!--og codes-->
<meta property="og:url" content="https://malawisounds.com/bioview.php?artist=<?php echo str_replace(' ', '-', $dropdown); ?>" />
<meta property="og:type" content="website" />
<meta property="og:title" content="<?php echo "$name's Profile"; ?>" />
<meta property="og:image" content="https://malawisounds.com/bio/<?php echo $path; ?>" />
<meta property="og:description" content="Biography" />
<meta property="fb:app_id" content="197362031139140" />
</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
/////////////////////////////////////////////////////////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)) {
$image = $row['path'];
$artist_name = $row['artist_name'];
$id = $row['id'];
?>
<td>
<a href="artist=<?php echo str_replace(' ', '-', $artist_name); ?>" target="_parent">
<img src="bio/<?php echo $image; ?>" alt="<?php echo $artist_name; ?>" />
</a>
</td>
<?php
}
echo "</tr>";
echo "</table>";
echo "</center>";
echo "</div>";
} else {
die(mysqli_error($conn));
}
?>
<div class="container-fluid">
<div class="row artist-cover">
<div class="col-xs-5 col-sm-4">
<img src="bio/<?php echo $path; ?>" class="w3-animate-zoom image" alt="<?php echo $name; ?>" />
</div>
<div class="col-xs-7 col-sm-8">
<h4><?php echo $name; ?></h4>
<h5>
<div class="fas fa-location-arrow"></div> <?php echo $city; ?>
</h5>
<h5>
<div class="fas fa-microphone"></div> <?php echo $genre; ?>
</h5>
</div>
</div>
<div class="row artist-details">
<div class="col-sm-12">
<p><?php echo $details; ?></p>
</div>
</div>
</div>
<div class="container-fluid">
<div class="row">
<div class="col-sm-12">
<?php
////////////////////////////////////////////////////////////ARTIST SINGLES////////////////////////////////////////////////////////
$sql = "SELECT `tbl_uploads`.`id`,`tbl_uploads`.`title`,`tbl_uploads`.`artist`,`tbl_uploads`.`song_mode`,`tbl_uploads`.`verify` FROM `tbl_uploads`,`profile_content` WHERE `profile_content`.`music_id`=`tbl_uploads`.`id` AND `profile_content`.`profile_title`='$dropdown'";
if ($query_run = mysqli_query($conn, $sql)) {
if (mysqli_num_rows($query_run) > 0) {
echo "<h4>Related Songs</h4>";
}
echo "<ol>";
while ($row = mysqli_fetch_array($query_run)) {
$id = $row['id'];
$title = $row['title'];
$artist = $row['artist'];
$mode = $row['song_mode'];
$verify = $row['verify'];
$titleurl = str_replace(' ', '-', $title);
$artisturl = str_replace(' ', '-', $artist);
//checking if song mode is free
if ($mode == 'free' && $verify == 1) {
?>
<li><a href="<?php echo "$id-$titleurl-by-$artisturl"; ?>"><?php echo "$title by $artist"; ?></a></li>
<?php
} else if ($mode = 'buy') {
?>
<li><a href="<?php echo "$id-buy-$titleurl-by-$artisturl" ?>"><?php echo "$title by $artist"; ?></a></li>
<?php
}
}
echo "</ol>";
} else {
die(mysqli_error($conn));
}
?>
</div>
<div class="col-sm-12">
<?php
////////////////////////////////////////////////////////////ARTIST ALBUMS////////////////////////////////////////////////////////
$sql = "SELECT * FROM `ulbum`,`profile_content_album` WHERE `ulbum`.`id`=`profile_content_album`.`album_id` AND `profile_content_album`.`profile_title`='$dropdown'";
if ($query_run = mysqli_query($conn, $sql)) {
if (mysqli_num_rows($query_run) > 0) {
echo "<h4>Related Albums</h4>";
}
echo "<ol>";
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']));
$mode = $row['mode'];
$type = $row['type'];
//checking if album/ep is free
if ($mode == 'free') {
?>
<li><a href="<?php echo "$titleurl-by-$artisturl"; ?>"><?php echo "$title by $artist"; ?></a></li>
<?php
}
//checking if album/ep is payed
else if ($mode == 'buy') {
?>
<li><a href="<?php echo "buy-$titleurl-$type-by-$artisturl"; ?>"><?php echo "$title by $artist"; ?></a></li>
<?php
}
}
echo "</ol>";
} else {
die(mysqli_error($conn));
}
?>
</div>
</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 src="./js/all.min.js"></script>
<script type="text/javascript">
function _(selector) {
return document.querySelectorAll(selector);
}
function splash(id) {
id = 'ad' + id;
document.getElementById(id).style.display = "block";
}
_("ul li a")[2].style.backgroundColor = "#3f4243";
_("ul li a")[2].style.Color = "white";
/* Animated Wow Js */
new WOW().init();
</script>