| Server IP : 162.0.232.25 / Your IP : 13.58.224.40 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="shortcut icon" href="Icons/malawisounds.ico">
<meta name="viewport" content="width=device-width,initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="w3.css">
<link rel="stylesheet" type="text/css" href="load.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 type="text/css">
tr,td{background-color:transparent;color:#333333;}
.image{width:300px;height:300px;border-radius:20px;object-fit:cover;box-shadow:-3px 3px 3px grey;}
ol{margin-top:5px;}
h4{text-align:center;}
ol li a{text-decoration:none;color:#2891a6;}
ol li a:hover{text-decoration:none;color:#2891a6;}
@media screen and (max-width:640px)
{
.image{width:250px;height:250px;}
}
</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">
<header>
<!-- malawisounds logo -->
<img src="Icons/msounds1.png" alt="logo" class="msounds">
<!-- social media links -->
<div class="link">
<a href="https://www.facebook.com/Malawi-Sounds-303591487173877/"><img src="Icons/facebook.png" alt="facebook"></a>
<a href="https://www.instagram.com/malawi_sounds"><img src="Icons/instagram.png" alt="instagram"></a>
<a href="#"><img src="Icons/twitter.png" alt="twitter"></a>
</div>
</header>
<!-- Navigation Bar -->
<nav>
<ul>
<li><a href="home" target="_parent">HOME</a></li>
<li><a href="singles" target="_parent">SINGLES</a></li>
<li><a href="biography" target="_parent">ARTISTS</a></li>
<li><a href="albums" target="_parent">ALBUMS</a></li>
<li><a href="e-news" target="_parent">NEWS</a></li>
<li><a href="videos" target="_parent">VIDEOS</a></li>
<li><a href="oldies" target="_parent">OLDIES</a></li>
<li><span class="search glyphicon glyphicon-search"></span></li>
</ul>
</nav>
<!--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="_blank">
<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="w3-center">
<img src="bio/<?php echo $path;?>" class="w3-animate-fading image" alt="<?php echo $name;?>" />
<br>
<h4 style="font-family:gothic-bold;margin-bottom:2px;"><?php echo strtoupper($name);?></h4>
</div>
<center>
<table style="border:none;">
<tr style="border:none;">
<td style="border:none;"><b>Genre:</b><?php echo $genre;?></td>
<td style="border:none;">-|-</td>
<td style="border:none;"><b>City:</b><?php echo $city;?><br></td>
</tr>
</table>
</center>
<center style="margin-top:5px;font-size:16px;"><b>Profile</b></center>
<p style="font-size:15px;color:grey;width:90%;margin:auto;text-align:justify;font-family:gothic;"><?php echo $details;?></p>
<?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));
}
////////////////////////////////////////////////////////////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));
}
/////////////////////////////////////////////////////////////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-->
<div class="footer">
<div class="details w3-center">
<a href="upload-music" target="_parent">UPLOAD</a> |
<a href="contact-us" target="_parent">CONTACT US</a> |
<a href="about-us" target="_parent">ABOUT US</a>
</div>
<h4 class="w3-center">© 2018- <?php echo date('Y',time());?></h4>
</div>
</div>
</body>
</html>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/nav.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";
</script>