| Server IP : 162.0.232.25 / Your IP : 3.129.42.59 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/redlighttunes.com/ |
Upload File : |
<?php
include './php/connect.php';
include './php/time.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<!-- CSS -->
<link rel="stylesheet" href="css/bootstrap-reboot.min.css">
<link rel="stylesheet" href="css/bootstrap-grid.min.css">
<link rel="stylesheet" href="css/owl.carousel.min.css">
<link rel="stylesheet" href="css/magnific-popup.css">
<link rel="stylesheet" href="css/select2.min.css">
<link rel="stylesheet" href="css/paymentfont.min.css">
<link rel="stylesheet" href="css/slider-radio.css">
<link rel="stylesheet" href="css/plyr.css">
<link rel="stylesheet" href="css/main.css">
<link rel="stylesheet" href="css/animate.css">
<!-- Favicons -->
<link rel="icon" type="image/png" href="icon/redlighttunes.png" sizes="32x32">
<!--open graph codes-->
<meta property="og:url" content="https://redlighttunes.com/index.php" />
<meta property="og:type" content="website" />
<meta property="og:title" content="REDLIGHT TUNES" />
<meta property="og:image" content="https://redlighttunes.com/icon/bg.jpg" />
<meta property="og:image:width" content="1200" />
<meta property="og:image:height" content="630" />
<meta property="og:description" content="Visit" />
<meta property="fb:app_id" content="197362031139140" />
<meta name="description" content="Redlighttunes">
<meta name="author" content="Beaton Ndawa">
<title></title>
</head>
<body>
<!-- header -->
<header class="header">
<div class="header__content">
<div class="header__logo">
<a href="home">
<img src="./icon/redlighttunes.png" alt="">
</a>
</div>
<nav class="header__nav">
<a href="about">About</a>
<a href="contacts">Contacts</a>
</nav>
<form action="search" method="POST" class="header__search">
<input type="text" name="search" placeholder="Search">
<button type="submit"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M21.71,20.29,18,16.61A9,9,0,1,0,16.61,18l3.68,3.68a1,1,0,0,0,1.42,0A1,1,0,0,0,21.71,20.29ZM11,18a7,7,0,1,1,7-7A7,7,0,0,1,11,18Z" />
</svg></button>
</form>
<div class="header__actions">
<div class="header__action header__action--search">
<button class="header__action-btn" type="button"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M21.71,20.29,18,16.61A9,9,0,1,0,16.61,18l3.68,3.68a1,1,0,0,0,1.42,0A1,1,0,0,0,21.71,20.29ZM11,18a7,7,0,1,1,7-7A7,7,0,0,1,11,18Z" />
</svg></button>
</div>
</div>
<button class="header__btn" type="button">
<span></span>
<span></span>
<span></span>
</button>
</div>
</header>
<!-- end header -->
<?php
include './sidebar.php';
?>
<!-- main content -->
<main class="main">
<div class="container-fluid">
<!-- Singles -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512">
<path d="M470.38 1.51L150.41 96A32 32 0 0 0 128 126.51v261.41A139 139 0 0 0 96 384c-53 0-96 28.66-96 64s43 64 96 64 96-28.66 96-64V214.32l256-75v184.61a138.4 138.4 0 0 0-32-3.93c-53 0-96 28.66-96 64s43 64 96 64 96-28.65 96-64V32a32 32 0 0 0-41.62-30.49z" />
</svg><a href="singles.php">Latest Singles</a></h2>
</div>
</div>
<!-- end title -->
<?php
$query = "SELECT * FROM `singles` ORDER BY `id` DESC LIMIT 3";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
$id = $row['id'];
$artist_url = str_replace(' ', '-', strtolower($row['artist']));
$title_url = str_replace(' ', '-', strtolower($row['title']));
?>
<div class="col-12 col-md-6 col-xl-4 wow fadeInUp" data-wow-duration="0.8s" data-wow-delay="1.0s">
<ul class="main__list">
<li class="single-item">
<a data-link data-title="<?php echo $row['title']; ?>" data-artist="<?php echo $row['artist']; ?>" data-img="stream.php?sid=<?php echo $row['id']; ?>" href="./singles/audios/<?php echo $row['file']; ?>" class="single-item__cover">
<img src="./singles/covers/<?php echo $row['image']; ?>" alt="<?php echo $row['title']; ?>">
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M18.54,9,8.88,3.46a3.42,3.42,0,0,0-5.13,3V17.58A3.42,3.42,0,0,0,7.17,21a3.43,3.43,0,0,0,1.71-.46L18.54,15a3.42,3.42,0,0,0,0-5.92Zm-1,4.19L7.88,18.81a1.44,1.44,0,0,1-1.42,0,1.42,1.42,0,0,1-.71-1.23V6.42a1.42,1.42,0,0,1,.71-1.23A1.51,1.51,0,0,1,7.17,5a1.54,1.54,0,0,1,.71.19l9.66,5.58a1.42,1.42,0,0,1,0,2.46Z" />
</svg>
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M16,2a3,3,0,0,0-3,3V19a3,3,0,0,0,6,0V5A3,3,0,0,0,16,2Zm1,17a1,1,0,0,1-2,0V5a1,1,0,0,1,2,0ZM8,2A3,3,0,0,0,5,5V19a3,3,0,0,0,6,0V5A3,3,0,0,0,8,2ZM9,19a1,1,0,0,1-2,0V5A1,1,0,0,1,9,5Z" />
</svg>
</a>
<div class="single-item__title">
<h4><a href="single=<?php echo $id . '-' . $title_url . '-by-' . $artist_url ?>"><?php echo $row['title']; ?></a>
</h4>
<span><a href="#"><?php echo $row['artist']; ?></a></span>
</div>
</li>
</ul>
</div>
<?php
}
?>
</section>
<!-- Albums -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 496 512">
<path d="M248 8C111 8 0 119 0 256s111 248 248 248 248-111 248-248S385 8 248 8zM88 256H56c0-105.9 86.1-192 192-192v32c-88.2 0-160 71.8-160 160zm160 96c-53 0-96-43-96-96s43-96 96-96 96 43 96 96-43 96-96 96zm0-128c-17.7 0-32 14.3-32 32s14.3 32 32 32 32-14.3 32-32-14.3-32-32-32z" />
</svg> Latest Albums</h2>
<a href="c=albums" class="main__link">See all <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M17.92,11.62a1,1,0,0,0-.21-.33l-5-5a1,1,0,0,0-1.42,1.42L14.59,11H7a1,1,0,0,0,0,2h7.59l-3.3,3.29a1,1,0,0,0,0,1.42,1,1,0,0,0,1.42,0l5-5a1,1,0,0,0,.21-.33A1,1,0,0,0,17.92,11.62Z" />
</svg></a>
</div>
</div>
<!-- end title -->
<?php
$query = "SELECT * FROM `albums` ORDER BY `id` DESC LIMIT 6";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
$id = $row['id'];
$artist_url = str_replace(' ', '-', strtolower($row['artist']));
$title_url = str_replace(' ', '-', strtolower($row['title']));
?>
<div class="col-6 col-sm-4 col-lg-2 wow fadeInUp" data-wow-duration="0.8s" data-wow-delay="1.2s">
<div class="album">
<div class="album__cover">
<img src="./albums/covers/<?php echo $row['image']; ?>" alt="<?php echo $row['title']; ?>">
<a href="<?php echo $row['type'] . "~$id-$title_url-by-$artist_url"; ?>"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M18.54,9,8.88,3.46a3.42,3.42,0,0,0-5.13,3V17.58A3.42,3.42,0,0,0,7.17,21a3.43,3.43,0,0,0,1.71-.46L18.54,15a3.42,3.42,0,0,0,0-5.92Zm-1,4.19L7.88,18.81a1.44,1.44,0,0,1-1.42,0,1.42,1.42,0,0,1-.71-1.23V6.42a1.42,1.42,0,0,1,.71-1.23A1.51,1.51,0,0,1,7.17,5a1.54,1.54,0,0,1,.71.19l9.66,5.58a1.42,1.42,0,0,1,0,2.46Z" />
</svg></a>
<span class="album__stat">
<span><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512">
<path d="M216 0h80c13.3 0 24 10.7 24 24v168h87.7c17.8 0 26.7 21.5 14.1 34.1L269.7 378.3c-7.5 7.5-19.8 7.5-27.3 0L90.1 226.1c-12.6-12.6-3.7-34.1 14.1-34.1H192V24c0-13.3 10.7-24 24-24zm296 376v112c0 13.3-10.7 24-24 24H24c-13.3 0-24-10.7-24-24V376c0-13.3 10.7-24 24-24h146.7l49 49c20.1 20.1 52.5 20.1 72.6 0l49-49H488c13.3 0 24 10.7 24 24zm-124 88c0-11-9-20-20-20s-20 9-20 20 9 20 20 20 20-9 20-20zm64 0c0-11-9-20-20-20s-20 9-20 20 9 20 20 20 20-9 20-20z" />
</svg> <?php echo $row['zip_downloads']; ?></span>
</span>
</div>
<div class="album__title">
<h3><a href="<?php echo $row['type'] . "~$id-$title_url-by-$artist_url"; ?>"><?php echo $row['title']; ?></a></h3>
<span><a href="#"><?php echo $row['artist']; ?></a></span>
</div>
</div>
</div>
<?php
}
?>
<!-- end albumss -->
<!-- artists -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M12.3,12.22A4.92,4.92,0,0,0,14,8.5a5,5,0,0,0-10,0,4.92,4.92,0,0,0,1.7,3.72A8,8,0,0,0,1,19.5a1,1,0,0,0,2,0,6,6,0,0,1,12,0,1,1,0,0,0,2,0A8,8,0,0,0,12.3,12.22ZM9,11.5a3,3,0,1,1,3-3A3,3,0,0,1,9,11.5Zm9.74.32A5,5,0,0,0,15,3.5a1,1,0,0,0,0,2,3,3,0,0,1,3,3,3,3,0,0,1-1.5,2.59,1,1,0,0,0-.5.84,1,1,0,0,0,.45.86l.39.26.13.07a7,7,0,0,1,4,6.38,1,1,0,0,0,2,0A9,9,0,0,0,18.74,11.82Z" />
</svg> Artists</h2>
<a href="c=artists" class="main__link">See all <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M17.92,11.62a1,1,0,0,0-.21-.33l-5-5a1,1,0,0,0-1.42,1.42L14.59,11H7a1,1,0,0,0,0,2h7.59l-3.3,3.29a1,1,0,0,0,0,1.42,1,1,0,0,0,1.42,0l5-5a1,1,0,0,0,.21-.33A1,1,0,0,0,17.92,11.62Z" />
</svg></a>
</div>
</div>
<!-- end title -->
<div class="col-12">
<div class="row row--grid">
<?php
$query = "SELECT * FROM `artists` ORDER BY `id` DESC";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
$id = $row['id'];
$artist = str_replace(' ', '-', strtolower($row['artist']));
?>
<div class="col-6 col-sm-4 col-md-3 col-xl-2 wow fadeInUp" data-wow-duration="0.7s" data-wow-delay="0.7s">
<a href="artist=<?php echo "$id-$artist"; ?>" class="artist wow fadeInUp" data-wow-duration="0.9s" data-wow-delay="1.0s">
<div class="artist__cover">
<img src="./artists/<?php echo $row['image']; ?>" alt="">
</div>
<h3 class="artist__title"><?php echo $row['artist']; ?></h3>
</a>
</div>
<?php
}
?>
</div>
</div>
</section>
<!-- end artists -->
<!-- Videos -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 576 512">
<path d="M336.2 64H47.8C21.4 64 0 85.4 0 111.8v288.4C0 426.6 21.4 448 47.8 448h288.4c26.4 0 47.8-21.4 47.8-47.8V111.8c0-26.4-21.4-47.8-47.8-47.8zm189.4 37.7L416 177.3v157.4l109.6 75.5c21.2 14.6 50.4-.3 50.4-25.8V127.5c0-25.4-29.1-40.4-50.4-25.8z" />
</svg><a href="singles.php">Latest Videos</a></h2>
</div>
</div>
<!-- end title -->
<?php
$query = "SELECT * FROM `videos` ORDER BY `id` DESC LIMIT 3";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
?>
<div class="col-12 col-sm-6 col-md-4 wow fadeInUp" data-wow-duration="0.7s" data-wow-delay="1.0s">
<div class="live">
<a href="<?php echo $row['youtube']; ?>" class="live__cover open-video">
<img src="./youtube/<?php echo $row['thumbnail']; ?>" alt="">
<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M18.54,9,8.88,3.46a3.42,3.42,0,0,0-5.13,3V17.58A3.42,3.42,0,0,0,7.17,21a3.43,3.43,0,0,0,1.71-.46L18.54,15a3.42,3.42,0,0,0,0-5.92Zm-1,4.19L7.88,18.81a1.44,1.44,0,0,1-1.42,0,1.42,1.42,0,0,1-.71-1.23V6.42a1.42,1.42,0,0,1,.71-1.23A1.51,1.51,0,0,1,7.17,5a1.54,1.54,0,0,1,.71.19l9.66,5.58a1.42,1.42,0,0,1,0,2.46Z"></path>
</svg>
</a>
<h3 class="live__title"><a href="<?php echo $row['youtube']; ?>" class="open-video"><?php echo $row['title']; ?></a></h3>
</div>
</div>
<?php
}
?>
</section>
<!-- news -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M16,14H8a1,1,0,0,0,0,2h8a1,1,0,0,0,0-2Zm0-4H10a1,1,0,0,0,0,2h6a1,1,0,0,0,0-2Zm4-6H17V3a1,1,0,0,0-2,0V4H13V3a1,1,0,0,0-2,0V4H9V3A1,1,0,0,0,7,3V4H4A1,1,0,0,0,3,5V19a3,3,0,0,0,3,3H18a3,3,0,0,0,3-3V5A1,1,0,0,0,20,4ZM19,19a1,1,0,0,1-1,1H6a1,1,0,0,1-1-1V6H7V7A1,1,0,0,0,9,7V6h2V7a1,1,0,0,0,2,0V6h2V7a1,1,0,0,0,2,0V6h2Z" />
</svg> News</h2>
<a href="c=news" class="main__link">See all <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M17.92,11.62a1,1,0,0,0-.21-.33l-5-5a1,1,0,0,0-1.42,1.42L14.59,11H7a1,1,0,0,0,0,2h7.59l-3.3,3.29a1,1,0,0,0,0,1.42,1,1,0,0,0,1.42,0l5-5a1,1,0,0,0,.21-.33A1,1,0,0,0,17.92,11.62Z" />
</svg></a>
</div>
</div>
<!-- end title -->
<!-- post -->
<?php
$query = "SELECT `nid`,`title`,`image`,`views`,UNIX_TIMESTAMP()-`date` as spent_time FROM `news` ORDER BY `nid` DESC LIMIT 3";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
?>
<!-- post -->
<div class="col-12 col-sm-6 col-lg-4 wow fadeInUp" data-wow-duration="0.5s" data-wow-delay="1.0s">
<div class="post">
<a href="article=<?php echo $row['nid']; ?>" class="post__img">
<img src="news/<?php echo $row['image']; ?>" alt="">
</a>
<div class="post__content">
<h3 class="post__title"><a href="article=<?php echo $row['nid']; ?>"><?php echo $row['title']; ?></a>
</h3>
<div class="post__meta">
<span class="post__date"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M12,2A10,10,0,1,0,22,12,10.01114,10.01114,0,0,0,12,2Zm0,18a8,8,0,1,1,8-8A8.00917,8.00917,0,0,1,12,20ZM14.09814,9.63379,13,10.26807V7a1,1,0,0,0-2,0v5a1.00025,1.00025,0,0,0,1.5.86621l2.59814-1.5a1.00016,1.00016,0,1,0-1-1.73242Z" />
</svg> <?php timeSpent($row['spent_time']); ?></span>
<span class="post__comments"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<i class="fa fa-eye"></i>
</svg> <?php echo $row['views']; ?></span>
</div>
</div>
</div>
</div>
<!-- end post -->
<?php
}
?>
<!-- end post -->
</section>
<!-- end news -->
<!-- store -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M8.5,19A1.5,1.5,0,1,0,10,20.5,1.5,1.5,0,0,0,8.5,19ZM19,16H7a1,1,0,0,1,0-2h8.49121A3.0132,3.0132,0,0,0,18.376,11.82422L19.96143,6.2749A1.00009,1.00009,0,0,0,19,5H6.73907A3.00666,3.00666,0,0,0,3.92139,3H3A1,1,0,0,0,3,5h.92139a1.00459,1.00459,0,0,1,.96142.7251l.15552.54474.00024.00506L6.6792,12.01709A3.00006,3.00006,0,0,0,7,18H19a1,1,0,0,0,0-2ZM17.67432,7l-1.2212,4.27441A1.00458,1.00458,0,0,1,15.49121,12H8.75439l-.25494-.89221L7.32642,7ZM16.5,19A1.5,1.5,0,1,0,18,20.5,1.5,1.5,0,0,0,16.5,19Z" />
</svg>New Products</h2>
<a href="c=ads" class="main__link">See all <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M17.92,11.62a1,1,0,0,0-.21-.33l-5-5a1,1,0,0,0-1.42,1.42L14.59,11H7a1,1,0,0,0,0,2h7.59l-3.3,3.29a1,1,0,0,0,0,1.42,1,1,0,0,0,1.42,0l5-5a1,1,0,0,0,.21-.33A1,1,0,0,0,17.92,11.62Z" />
</svg></a>
</div>
</div>
<!-- end title -->
<?php
$query = "SELECT * FROM `ads` ORDER BY `aid` DESC LIMIT 4";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
$id = $row['aid'];
$product = str_replace(' ', '-', strtolower($row['name']));
?>
<div class="col-6 col-md-6 col-lg-4 col-xl-3 wow fadeInUp" data-wow-duration="0.7s" data-wow-delay="0.7s">
<div class="product">
<div class="product__img">
<img src="./ads/<?php echo $row['image']; ?>" alt="<?php echo $row['name']; ?>">
<button class="product__add" type="button"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24">
<path d="M19,11H13V5a1,1,0,0,0-2,0v6H5a1,1,0,0,0,0,2h6v6a1,1,0,0,0,2,0V13h6a1,1,0,0,0,0-2Z" />
</svg></button>
</div>
<h3 class="product__title"><a href="product=<?php echo "$id-$product"; ?>"><?php echo $row['name']; ?></a></h3>
<span class="product__price">K<?php echo $row['price']; ?></span>
</div>
</div>
<?php
}
?>
</section>
<!-- end store -->
<!-- Top 10 -->
<section class="row row--grid">
<!-- title -->
<div class="col-12">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 576 512">
<path d="M528.1 171.5L382 150.2 316.7 17.8c-11.7-23.6-45.6-23.9-57.4 0L194 150.2 47.9 171.5c-26.2 3.8-36.7 36.1-17.7 54.6l105.7 103-25 145.5c-4.5 26.3 23.2 46 46.4 33.7L288 439.6l130.7 68.7c23.2 12.2 50.9-7.4 46.4-33.7l-25-145.5 105.7-103c19-18.5 8.5-50.8-17.7-54.6zM388.6 312.3l23.7 138.4L288 385.4l-124.3 65.3 23.7-138.4-100.6-98 139-20.2 62.2-126 62.2 126 139 20.2-100.6 98z" />
</svg>Weekly Top 10</h2>
</div>
</div>
<!-- end title -->
<div class="col-12">
<table class="main__table">
<tbody>
<?php
$query = "SELECT * FROM `singles` ORDER BY `downloads` DESC, `streams` DESC, `time` DESC LIMIT 10";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
$num = 1;
while ($row = mysqli_fetch_array($run)) {
$id = $row['id'];
$artist_url = str_replace(' ', '-', strtolower($row['artist']));
$title_url = str_replace(' ', '-', strtolower($row['title']));
?>
<tr>
<td>
<div class="main__table-text">
<a href="single=<?php echo $id . '-' . $title_url . '-by-' . $artist_url ?>"><?php echo $num . '. ' . $row['title'] . ' by ' . $row['artist']; ?></a>
</div>
</td>
</tr>
<?php
$num++;
}
?>
</tbody>
</table>
</div>
</section>
<!-- end Top 10 -->
<!-- Genres -->
<section class="row row--grid">
<!-- title -->
<div class="col-12 mb-4">
<div class="main__title">
<h2><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512">
<path d="M464 32H48C21.49 32 0 53.49 0 80v352c0 26.51 21.49 48 48 48h416c26.51 0 48-21.49 48-48V80c0-26.51-21.49-48-48-48zm-6 400H54a6 6 0 0 1-6-6V86a6 6 0 0 1 6-6h404a6 6 0 0 1 6 6v340a6 6 0 0 1-6 6zm-42-92v24c0 6.627-5.373 12-12 12H204c-6.627 0-12-5.373-12-12v-24c0-6.627 5.373-12 12-12h200c6.627 0 12 5.373 12 12zm0-96v24c0 6.627-5.373 12-12 12H204c-6.627 0-12-5.373-12-12v-24c0-6.627 5.373-12 12-12h200c6.627 0 12 5.373 12 12zm0-96v24c0 6.627-5.373 12-12 12H204c-6.627 0-12-5.373-12-12v-24c0-6.627 5.373-12 12-12h200c6.627 0 12 5.373 12 12zm-252 12c0 19.882-16.118 36-36 36s-36-16.118-36-36 16.118-36 36-36 36 16.118 36 36zm0 96c0 19.882-16.118 36-36 36s-36-16.118-36-36 16.118-36 36-36 36 16.118 36 36zm0 96c0 19.882-16.118 36-36 36s-36-16.118-36-36 16.118-36 36-36 36 16.118 36 36z" />
</svg>Genres</h2>
</div>
</div>
<!-- end title -->
<?php
$query = "SELECT * FROM `genre` ORDER BY `genre` ASC";
$run = mysqli_query($conn, $query) or die(mysqli_error($conn));
$count = mysqli_num_rows($run);
while ($row = mysqli_fetch_array($run)) {
?>
<div class="col-xl-2 col-lg-3 col-md-4 col-6">
<div class="genre__btn"><a href="genre=<?php echo $row['genre']; ?>"><?php echo $row['genre']; ?></a></div>
</div>
<?php
}
?>
</section>
<!-- end Genres -->
</div>
</main>
<!-- end main content -->
<?php
include './footer.php';
?>
<script>
document.querySelector("title").innerText = "Redlighttunes - Home";
document.querySelectorAll("ul.sidebar__nav .sidebar__nav-item a")[0].classList.add("sidebar__nav-link--active");
//slicing all playlists titles
var count = document.querySelectorAll(".main__table .main__table-text a").length;
for (var i = 0; i < count; i++) {
var title = document.querySelectorAll(".main__table .main__table-text a")[i].innerText;
var slicer = title.slice(0, 35);
if (title.length >= 35) {
document.querySelectorAll(".main__table .main__table-text a")[i].innerHTML = slicer + '...';
} else {
document.querySelectorAll(".main__table .main__table-text a")[i].innerHTML = slicer;
}
}
</script>
<?php
include './scripts.php';
?>