| Server IP : 162.0.232.25 / Your IP : 3.15.151.109 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['id']))
{
$id=mysqli_real_escape_string($conn,htmlentities($_GET['id']));
if(!empty($id))
{
$sqli="SELECT `views` FROM `news` WHERE `nid`='$id'";
if($sql_run=mysqli_query($conn,$sqli))
{
if(list($listened)=mysqli_fetch_array($sql_run))
{
$increment=++$listened;
$Sqli2="UPDATE `news` SET `views`='$increment' WHERE `nid`='$id'";
$sql2_run=mysqli_query($conn,$Sqli2);
$sql="SELECT * FROM `news` WHERE `nid`='".$id."'";
if($query_run=mysqli_query($conn,$sql))
{
while($row=mysqli_fetch_array($query_run))
{
$id=$row['nid'];
$image=$row['image'];
$title=$row['story_title'];
$details=$row['story_details'];
$date=$row['date'];
$views=$row['views'];
$writer=$row['writer'];
}
}
else
{
die(mysqli_error($conn));
}
}
}
}
}
?>
<!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="w3.css">
<link rel="stylesheet" type="text/css" href="load.css">
<link rel="shortcut 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><?php echo $title;?></title>
<!--og codes-->
<meta property="og:url" content="https://malawisounds.com/read.php?id=<?php echo $id;?>" />
<meta property="og:type" content="website" />
<meta property="og:title" content="<?php echo $title;?>" />
<meta property="og:image" content="https://malawisounds.com/news/<?php echo $image;?>" />
<meta property="og:description" content="E News" />
<meta property="fb:app_id" content="197362031139140" />
</style>
</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))
{
$path=$row['path'];
$name=$row['artist_name'];
$id=$row['id'];
?>
<td>
<a href="artist=<?php echo str_replace(' ','-',$name);?>" target="_blank">
<img src="bio/<?php echo $path;?>" alt="artist"/>
</a>
</td>
<?php
}
echo "</tr>";
echo "</table>";
echo "</center>";
echo "</div>";
}
else
{
die(mysqli_error($conn));
}
///////////////////////////////////////////////////////////////NEWS////////////////////////////////////////////
?>
<div class="read_box" >
<center><img src="news/<?php echo $image;?>" alt="artwork"></center>
<h3><?php echo strtoupper($title);?></h3>
<div>
<div class="writer"><span class="glyphicon glyphicon-edit"></span> <?php echo $writer;?></div>
<div class="date"><span class="glyphicon glyphicon-time"></span> <?php echo $date;?></div>
</div>
<hr>
<p><?php echo $details;?></p>
</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;margin:5px 0px;\" 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));
}
?>
</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);
}
_("ul li a")[4].style.backgroundColor="#3f4243";
_("ul li a")[4].style.Color="white";
</script>