����JFIF��H�H����Exif��MM�*���� ��3����V�����3������3�(��������������������3�����
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['title'])) { $profile_title=str_replace('-', ' ', $_GET['title']); $sql="SELECT `id`,`path`,`genre` FROM `biography` WHERE `artist_name`='$profile_title'"; if($run=mysqli_query($conn,$sql)) { list($id,$image,$genre)=mysqli_fetch_array($run); } 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="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" /> <script type="text/javascript" src="js/ajax.js"></script> <title><?php echo "$profile_title's profile";?></title> <!--og codes--> <meta property="og:url" content="https://malawisounds.com/profiles.php" /> <meta property="og:type" content="website" /> <meta property="og:title" content="<?php echo "$profile_title's profile";?>" /> <meta property="og:image" content="https://malawisounds.com/profiles/<?php echo $image;?>" /> <meta property="og:description" content="Download and Stream" /> </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 --> <div class="singles"> <?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="_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="contain_all"> <div class="contain1"> <img src="bio/<?php echo $image;?>" alt="profile-art"> </div> <div class="contain2"> <h2><?php echo strtoupper($profile_title);?></h2> <h4><?php echo $genre;?></h4> </div> <div class="clear"></div> </div> <?php //////////////////////////////////////////////////MUSIC//////////////////////////////////////////////// $sql="SELECT `profile_content`.`profile_title`, `tbl_uploads`.`title`, `tbl_uploads`.`artist`, `tbl_uploads`.`image`, `tbl_uploads`.`id` FROM `profile_content` JOIN `tbl_uploads` ON `profile_content`.`music_id`=`tbl_uploads`.`id` AND `profile_content`.`profile_title`='$profile_title'"; if($query_run=mysqli_query($conn,$sql)) { while($row=mysqli_fetch_array($query_run)) { $id=$row['id']; $title=$row['title']; $artist=$row['artist']; $imagepath=$row['image']; $titleurl=str_replace(' ','-',$title); $artisturl=str_replace(' ','-',$artist); ?> <div class="w3-card-3 respond"> <div class="model1"> <img src="images/<?php echo $imagepath ?>" alt="artwork"> </div> <div class="model2"> <a href="<?php echo "$id-$titleurl-by-$artisturl";?>"><?php echo "$title by $artist";?></a> </div> <div class="clear"></div> </div> <?php } } 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)); } ?> </div> <!--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>