| Server IP : 162.0.232.25 / Your IP : 18.189.189.19 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="icon" type="x-icon" href="Icons/malawisounds.ico">
<link rel="stylesheet" type="text/css" href="load.css">
<link rel="stylesheet" type="text/css" href="w3.css">
<link rel="stylesheet" type="text/css" href="bootstrap/css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="impact/stylesheet.css" />
<title>Mwsounds|Singles</title>
<style type="text/css">
.respond .image-resize
{
width:100%;
object-fit:cover;
object-position:center center;
}
.opa
{
position:relative;
padding:5px;
opacity:0.6;
background-color:white;
top:-33px;
text-align:center;
font-size:18px;
font-weight:bold;
}
</style>
<script type="text/javascript">
function findmatch(str)
{
if (str.length==0)
{
document.getElementById("results").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{
// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{ // code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("results").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","searchmusic.php?q="+str,true);
xmlhttp.send();
}
</script>
</head>
<body class="w3-light-grey">
<div class="margin w3-white w3-card-1">
<header>
<img src="Icons/msounds1.png" class="msounds" alt="Logo" />
<!--Search bar-->
<form name="search" id="search">
<div class="w3-center">
<input type="text" placeholder=" Search-Artists,Songs" name="search_text" onkeyup="findmatch(this.value)"
class="glyphicon glyphicon-search" style="padding:8px; border-radius:15px; width:270px;" required>
</div>
</form>
</header>
<br>
<!--Navigation Bar-->
<div class="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">E<span class="w3-text-white">_</span>NEWS</a></li>
</ul>
</div>
<div id="results" class="w3-container w3-light-grey"></div>
<br>
<div class="latest">
<div class="latest1">
<h3 class="trapezium">Recent Uploads</h3>
<br>
<?php
include'connect.php';
$sql1="SELECT `file`,`size`,`artist`,`title`,`image`,`genre`,`downloads`,`id`,`type`,`time`,`views`,`listened`,UNIX_TIMESTAMP() - `time` AS TimeSpent FROM `tbl_uploads` WHERE `song_type`='regular' ORDER BY `id` DESC LIMIT 5";
if($query_run=mysqli_query($conn,$sql1))
{
while($row=mysqli_fetch_array($query_run))
{
$id=$row['id'];
$title=$row['title'];
$artist=$row['artist'];
$titleurl=str_replace(' ','-',$title);
$artisturl=str_replace(' ','-',$artist);
$genre=$row['genre'];
$size=$row['size'];
$path=$row['file'];
$imagepath=$row['image'];
$downloads=$row['downloads'];
$timespent=$row['TimeSpent'];
$listened=$row['listened'];
?>
<a href="songs.php?id=<?php echo $id?>&name=<?php echo "$artisturl-$titleurl";?>">
<div class="latest_box1 w3-card-2">
<img src="images/<?php echo $imagepath;?>" class="image-resize img-responsive" alt="coverart"/>
</div>
<div class="latest_box2 w3-card-2">
<div style="font-family:arial">
<div class="img w3-text-white">
<b><div class="glyphicon glyphicon-user"></div> <?php echo $artist; ?></b><br>
<div class="glyphicon glyphicon-music"></div> <span style="font-family:impact;"><?php echo $title;?></span>
</div>
</div>
</div>
</a>
<br><br>
<?php
}
}
else
{
die(mysqli_error($conn));
}
?>
</div>
<div class="latest2">
<h3 class="trapezium">Artists</h3>
<br>
<div class="w3-section">
<?php
$sql="SELECT * FROM `biography` ORDER BY `id` DESC";
if($query_run=mysqli_query($conn,$sql))
{
while($row=mysqli_fetch_array($query_run))
{
$image=$row['path'];
$artist=$row['artist_name'];
?>
<div class="slider">
<img src="bio/<?php echo $image;?>">
<div class="opa" style="margin-bottom:-52px;"><?php echo $artist;?></div>
</div>
<?php
}
}
else
{
die(mysqli_error($conn));
}
?>
</div>
</div>
<script>
var myIndex = 0;
mine();
function mine()
{
var i;
var x = document.getElementsByClassName("slider");
for (i = 0; i < x.length; i++) {
x[i].style.display = "none";
}
myIndex++;
if (myIndex > x.length) {myIndex = 1}
x[myIndex-1].style.display = "block";
setTimeout(mine, 5000);
}
</script>
</div>
<div class="clear"></div>
<h3 class="trapezium">Other</h3>
<div>
<?php
///////////////////////////////////////////second uploaded tracks////////////////////////////////////////////////
$sql="SELECT `file`,`size`,`artist`,`title`,`image`,`genre`,`downloads`,`id`,`type`,`time`,`views`,`listened`,UNIX_TIMESTAMP() - `time` AS TimeSpent FROM `tbl_uploads` WHERE `song_type`='regular' ORDER BY `id` DESC LIMIT 6,15";
if($query_run=mysqli_query($conn,$sql))
{
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'];
$timespent=$row['TimeSpent'];
$listened=$row['listened'];
?>
<div class="w3-card-4 w3-round respond" style="font-family:arial; font-size:18px; background-color:#ff9900;">
<div class="model1">
<img src="images/<?php echo $imagepath ?>" alt="artwork" style="height:112px" class="image-resize img-responsive"/>
</div>
<div class="model2">
<b class="w3-text-black"><?php echo $artist;?></b><br>
<span style="font-family:impact"><?php echo $title;?></span><br>
<br>
<table>
<tr>
<td>
<a href="songs.php?id=<?php echo $id?>&name=<?php echo "$artisturl-$titleurl";?>"><div class="glyphicon glyphicon-download-alt"></div> <?php echo $downloads; ?></a>
</td>
<td>
<a href="listen.php?id=<?php echo $id?>" target="_blank"><div class="glyphicon glyphicon-headphones"></div><?php echo $listened; ?></a>
</td>
<td>
<div class="glyphicon glyphicon-time" style="word-spacing:-13px">
<?php
$days=floor($timespent/(60*60*24));
$months=floor($timespent/(60*60*24*30));
$years=floor($timespent/(60*60*24*365));
$remainder=$timespent%(60*60*24);
$hours=floor($remainder/(60*60));
$remainder=$remainder%(60*60);
$minutes=floor($remainder/60);
$seconds=$remainder%60;
if($days==1)
{
echo $days.' day ago';
}
else if($days>1 && $days<=30)
{
echo $days.' days ago';
}
else if($days>730)
{
echo $years.' years ago';
}
else if($days>365 && $days<=730)
{
echo $years.' year ago';
}
else if($days>60 && $days<=365)
{
echo $months.' months ago';
}
else if($days>30)
{
echo $months.' month ago';
}
else if($days>1)
{
echo $days.' days ago';
}
else if($days==0 && $hours==0 && $minutes==0)
{
echo'just now';
}
else if($days==0 && $hours==0 && $minutes==1)
{
echo $minutes.' minute ago';
}
else if($days==0 && $hours==0)
{
echo $minutes.' minutes ago';
}
else if($days==0 && $hours==1)
{
echo $hours.' hour ago';
}
else if($days==0 && $hours>1)
{
echo $hours.' hours ago';
}
?>
</div>
</td>
</tr>
</table>
</div>
<div class="clear"></div>
</div>
<?php
}
}
else
{
die('query run error'.mysqli_error($conn));
}
?>
</div>
<div class="w3-center clear">
<button><a href="view2.php" target="_parent">Next »</a></button>
</div>
<!--Footer-->
<div class="footer" style="padding:3px 10px 3x 10px;">
<div class="w3-center social">
<a href="http://www.facebook.com/malawisounds"><img src="Icons/facebook.png" alt="fb" class="link"></a>
<a href="http://www.twitter.com/2muzik3"><img src="Icons/Twitter.png" alt="twitter" class="link"></a>
<a href="https://www.instagram.com/p/BtHqqNCFytO/?utm_source=ig_share_sheet&igshid=1b4zv5kw0jg6"><img src="Icons/instagram.png" alt="instagram" class="link"></a>
<a href="https://chat.whatsapp.com/9EBW2hoH3d9Cq11LZegfxf"><img src="Icons/whatsapp.png" alt="whatsapp" class="link"></a>
</div>
<div class="details w3-center">
<a href="terms.php" target="_self">Terms and conditions</a> |
<a href="contact.php" target="_self">Contact us</a> |
<a href="about.php" target="-self">About Us</a>
</div>
<h4 class="w3-text-white w3-center text-justify">Copyright ©2018- <?php echo date('Y',time());?></h4>
</div>
</div>
</body>
</html>