<?php include "../inc/database.class.php"; include "../inc/common.class.php"; if ($_POST) { $q = textSafety($_POST['search']); $result = Database::getInstance()->query("select album_name, id, album_image from album_details where album_name like '%{$q}%' or album_type like '%{$q}%' or album_description like '%{$q}%' order by id LIMIT 8"); while ($row = mysql_fetch_array($result)) { $album_name = $row['album_name']; $b_username = '******' . $q . '</strong>'; $final_username = str_ireplace($q, $b_username, $album_name); ?> <a href="show-list.php?album_id=<?php echo $row['id']; ?> "> <div class="show" align="left"> <span class="name"><?php echo $final_username; ?> </span> </div> </a> <?php } }
<?php include "../inc/database.class.php"; include "../inc/common.class.php"; $id = textSafety($_GET['user_id']); $result = Database::getInstance()->query("SELECT * FROM user_details WHERE id='{$id}'"); while ($row = mysql_fetch_array($result)) { $id = $row['id']; if (isset($row['name'])) { $name = $row['name']; } if (isset($row['gender'])) { $gender = $row['gender']; } if (isset($row['age'])) { $age = $row['age']; } if (isset($row['email_id'])) { $email_id = $row['email_id']; } if (isset($row['mobile_number'])) { $mobile_number = $row['mobile_number']; } if (isset($row['address'])) { $address = $row['address']; } if (isset($row['album_image'])) { $album_image = $row['album_image']; } if (isset($row['file_name'])) { $file_name = $row['file_name'];
$album_id = textSafety($_GET['album_id']); $sql_song = "DELETE FROM song_details WHERE id={$id}"; $result = Database::getInstance()->deleteRecord($sql_song); $url = "../upload-admin.php?error=0&delete=success&album_id={$album_id}&access=valid"; header("Refresh:0;URL={$url}"); exit(0); } if (isset($_POST['update_details_btn'])) { $song_name = textSafety($_POST['song_name']); $song_link = textSafety($_POST['song_link']); $id = textSafety($_POST['id']); $song_artist = textSafety($_POST['song_artist']); $song_contributing_artist = textSafety($_POST['song_contributing_artist']); $song_year = textSafety($_POST['song_year']); $song_genre = textSafety($_POST['song_genre']); $added_by = textSafety($_POST['added_by']); if ($song_name == "" || $song_link == "") { $url = "../update-song--admin.php?error=1&empty=song&access=valid&id={$id}&song_link={$song_link}&song_name={$song_name}&song_artist={$song_artist}&song_contributing_artist={$song_contributing_artist}&song_year={$song_year}&song_genre={$song_genre}&added_by={$added_by}"; header("Refresh:0;URL={$url}"); exit(0); } if (!preg_match("/\\b(?:(?:https?|ftp):\\/\\/|www\\.)[-a-z0-9+&@#\\/%?=~_|!:,.;]*[-a-z0-9+&@#\\/%=~_|]/i", $song_link)) { $url = "../update-song-admin.php?access=valid&invalid=url&id={$id}&song_link={$song_link}&song_name={$song_name}&song_artist={$song_artist}&song_contributing_artist={$song_contributing_artist}&song_year={$song_year}&song_genre={$song_genre}&added_by={$added_by}"; header("Refresh:0;URL={$url}"); exit(0); } if ($song_year == "") { $song_year = "0000"; } if (!is_numeric($song_year) || strlen($song_year) != 4) { $url = "../update-song-admin.php?error=1&year=invalid&access=valid&id={$id}&song_link={$song_link}&song_name={$song_name}&song_artist={$song_artist}&song_contributing_artist={$song_contributing_artist}&song_year={$song_year}&song_genre={$song_genre}&added_by={$added_by}";
<?php include "../inc/database.class.php"; include "../inc/common.class.php"; if (isset($_POST['submit_comment'])) { $comment_box = textSafety($_POST['comment_box']); $name = textSafety($_POST['name']); $email = textSafety($_POST['email']); $album_id = textSafety($_POST['album_id']); if ($comment_box == "") { $url = "../show-list.php?error=4&code=360&email={$email}&comment_box={$comment_box}&album_id={$album_id}&name={$name}#comment_box"; header("Refresh:0;URL={$url}"); exit(0); } if ($name == "") { $url = "../show-list.php?error=1&code=360&email={$email}&comment_box={$comment_box}&album_id={$album_id}&name={$name}#comment_box"; header("Refresh:0;URL={$url}"); exit(0); } if ($email == "") { $url = "../show-list.php?error=2&code=400&name={$name}&email={$email}&comment_box={$comment_box}&album_id={$album_id}#comment_box"; header("Refresh:0;URL={$url}"); exit(0); } if (!preg_match("/([\\w\\-]+\\@[\\w\\-]+\\.[\\w\\-]+)/", $email) && $email != "") { $url = "../show-list.php?error=3&code=420&name={$name}&email={$email}&comment_box={$comment_box}&album_id={$album_id}#comment_box"; header("Refresh:0;URL={$url}"); exit(0); } $sql = "insert into comment_details (name, email, comment, album_id, status) values ('{$name}','{$email}','{$comment_box}', '{$album_id}', 0)"; $result = Database::getInstance()->insertRecord($sql);
include "../inc/database.class.php"; include "../inc/common.class.php"; session_start(); if (!isset($_SESSION['flag']) || empty($_SESSION['flag']) || !isset($_SESSION['email']) || empty($_SESSION['email'])) { $url = "../index.php"; header("Refresh:0;URL={$url}"); exit(0); } if (isset($_POST['user_details_btn'])) { $name = textSafety($_POST['name']); $gender = textSafety($_POST['gender']); $age = textSafety($_POST['age']); $email_id = textSafety($_POST['email_id']); $mobile_number = textSafety($_POST['mobile_number']); $address = textSafety($_POST['address']); if ($name == "" || $gender == "") { $url = "../add-user.php?error=1&code=360&name={$name}&age={$age}&email_id={$email_id}&mobile_number={$mobile_number}&address={$address}"; header("Refresh:0;URL={$url}"); exit(0); } if (!preg_match("/([\\w\\-]+\\@[\\w\\-]+\\.[\\w\\-]+)/", $email_id) && $email_id != "") { $url = "../add-user.php?error=2&code=120&name={$name}&age={$age}&email_id={$email_id}&mobile_number={$mobile_number}&address={$address}"; header("Refresh:0;URL={$url}"); exit(0); } if ($age == "") { $age = "00"; } if ($mobile_number == "") { $mobile_number = "0000000000";
<?php include "../inc/database.class.php"; include "../inc/common.class.php"; $id = textSafety($_GET['id']); $result = Database::getInstance()->query("SELECT * FROM user_details WHERE id='{$id}'"); while ($row = mysql_fetch_array($result)) { $id = $row['id']; if (isset($row['name'])) { $name = $row['name']; } if (isset($row['gender'])) { $gender = $row['gender']; } if (isset($row['age'])) { $age = $row['age']; } if (isset($row['email_id'])) { $email_id = $row['email_id']; } if (isset($row['mobile_number'])) { $mobile_number = $row['mobile_number']; } if (isset($row['address'])) { $address = $row['address']; } if (isset($row['album_image'])) { $album_image = $row['album_image']; } if (isset($row['file_name'])) { $file_name = $row['file_name'];
<?php require_once "../inc/common.class.php"; header("Access-Control-Allow-Origin: *"); header("Access-Control-Allow-Headers: Authorization"); header("Content-Type: application/json; charset=UTF-8;"); $response = []; $db = new DB(); if (isset($_GET) && isset($_GET['search'])) { $text = textSafety($_GET['search']); $get_songs = "SELECT song_name, album_id FROM song_details WHERE song_name like '%{$text}%' or song_artist like '%{$text}%' or song_contributing_artist like '%{$text}%' order by id LIMIT 4"; $get_songs_results = $db->query($get_songs); $song_list = []; while ($row = $get_songs_results->fetch_assoc()) { $album_id = $row['album_id']; $get_album_type = "SELECT album_type FROM album_details WHERE id='{$album_id}'"; $get_album_type_results = $db->query($get_album_type); $album_type = ""; while ($album_type_row = $get_album_type_results->fetch_assoc()) { $album_type = $album_type_row['album_type']; } $temp_array = []; $temp_array['albumType'] = strtolower($album_type); $temp_array['albumId'] = $album_id; $temp_array['songName'] = $row['song_name']; array_push($song_list, $temp_array); } $get_albums = "SELECT id, album_name FROM album_details WHERE album_name like '%{$text}%' or album_description like '%{$text}%' or meta_fb_desc like '%{$text}%' or album_type like '%{$text}%' order by id LIMIT 4"; $get_albums_results = $db->query($get_albums); $album_list = []; while ($row = $get_albums_results->fetch_assoc()) {
$temp_array['albumName'] = substr($row['album_name'], 0, 16) . "..."; } //$temp_array['albumArt'] = $album_image_location . $row['file_name']; $temp_array['albumArt'] = "https://upload.wikimedia.org/wikipedia/en/d/d2/Blake_Lewis_Audio_Day_Dream.jpg"; $temp_array['likes'] = $row['followers']; $temp_array['albumTags'] = $row['album_description']; $temp_array['fbDesc'] = $row['meta_fb_desc']; $temp_array['type'] = $row['album_type']; $lists[] = $temp_array; } $unknown_album_details = ["type" => "unknown", "id" => 4, "name" => "Unknown", "icon" => "ion-podium", "lists" => $lists]; $response = [$recent_album_details, $traditional_album_details, $modern_album_details, $unknown_album_details]; echo json_encode($response); } if (isset($_GET['get']) && $_GET['get'] == 'ALBMTYPWISE' && isset($_GET['type'])) { $album_type = ucwords(textSafety($_GET['type'])); if ($album_type == "Recently-added") { $get_albums = "SELECT * FROM album_details WHERE recent='yes' ORDER BY id DESC "; } else { $get_albums = "SELECT * FROM album_details WHERE album_type='{$album_type}' ORDER BY id DESC "; } $get_albums_results = $db->query($get_albums); $lists = []; while ($row = $get_albums_results->fetch_assoc()) { $temp_array = []; $temp_array['id'] = $row['id']; if (strlen(substr($row['album_name'], 0, 20)) == strlen($row['album_name'])) { $temp_array['albumName'] = $row['album_name']; } else { $temp_array['albumName'] = substr($row['album_name'], 0, 20) . "..."; }
if (isset($_GET['album_id']) && isset($_GET['delete']) && $_GET['delete'] == "yes") { $album_id = textSafety($_GET['album_id']); $sql_album = "DELETE FROM album_details WHERE id={$album_id}"; $result = Database::getInstance()->deleteRecord($sql_album); $sql_song = "DELETE FROM song_details WHERE album_id={$album_id}"; $result = Database::getInstance()->deleteRecord($sql_song); $url = "../create-album-admin.php?error=0&delete=success#album_list"; header("Refresh:0;URL={$url}"); exit(0); } if (isset($_POST['update_album_btn'])) { $album_name = textSafety($_POST['album_name']); $album_description = textSafety($_POST['album_description']); $album_type = textSafety($_POST['album_type']); $album_id = textSafety($_POST['album_id']); $recent = textSafety($_POST['recent']); if ($album_name == "") { $url = "../update-album-admin.php?error=1&empty=album"; header("Refresh:0;URL={$url}"); exit(0); } /* $filesize=$_FILES['ufile']['size'] / 1024; $filetype=$_FILES['ufile']['type']; $filename=$_FILES['ufile']['name']; $tmp_file=$_FILES['ufile']['tmp_name']; $filename=addslashes($filename); */ $file_name = ""; $file_name = uploadImage("album-image"); $content = "";
header("Refresh:0;URL={$url}"); exit(0); } if (isset($_GET['id']) && isset($_GET['id']) && $_GET['delete'] == "yes") { $id = textSafety($_GET['id']); $sql_album = "DELETE FROM ad_details WHERE id={$id}"; $result = Database::getInstance()->deleteRecord($sql_album); $url = "../manage-advertise.php?error=0&delete=success"; header("Refresh:0;URL={$url}"); exit(0); } if (isset($_POST['update_ad'])) { $ad_title = textSafety($_POST['ad_title']); $ad_link = textSafety($_POST['ad_link']); $ad_place = textSafety($_POST['ad_place']); $id = textSafety($_POST['id']); if ($ad_title == "") { $url = "../upload-advertise.php?error=1&empty=title&ad_link={$ad_link}"; header("Refresh:0;URL={$url}"); exit(0); } if ($ad_link != "") { if (!filter_var($ad_link, FILTER_VALIDATE_URL)) { $url = "../upload-advertise.php?error=2&invalid=link&ad_title={$ad_title}&ad_link={$ad_link}"; header("Refresh:0;URL={$url}"); exit(0); } } else { $ad_link = "http://songs.kaakai.in"; } /*
header("Content-Type: application/json; charset=UTF-8;"); $response = []; $db = new DB(); if (isset($_GET) && isset($_GET['get']) && $_GET['get'] == 'LKS' && $_GET['uniqueKey']) { $ip_address = textSafety($_GET['uniqueKey']); $get_liked_albums = "SELECT * FROM follower_details WHERE ip_address='{$ip_address}'"; $get_liked_albums_results = $db->query($get_liked_albums); $lists = []; while ($row = $get_liked_albums_results->fetch_assoc()) { if (count($row) >= 0) { $lists[] = $row['album_id']; } } $response = ["albumIds" => $lists]; } elseif (isset($_GET) && isset($_GET['get']) && $_GET['get'] == 'ALKS' && $_GET['uniqueKey']) { $ip_address = textSafety($_GET['uniqueKey']); $get_liked_albums = "SELECT * FROM follower_details WHERE ip_address='{$ip_address}'"; $get_liked_albums_results = $db->query($get_liked_albums); $lists = []; while ($row = $get_liked_albums_results->fetch_assoc()) { if (count($row) >= 0) { $album_id = $row['album_id']; $get_liked_albums_details = "SELECT * FROM album_details WHERE id='{$album_id}' ORDER BY id DESC"; $get_liked_albums_details_results = $db->query($get_liked_albums_details); while ($album_row = $get_liked_albums_details_results->fetch_assoc()) { $temp_array = []; $temp_array['id'] = $album_row['id']; if (strlen(substr($album_row['album_name'], 0, 20)) == strlen($album_row['album_name'])) { $temp_array['albumName'] = $album_row['album_name']; } else { $temp_array['albumName'] = substr($album_row['album_name'], 0, 20) . "...";
$album_name = $row['album_name']; } echo "<title>" . $album_name . " | Amar Ela</title>"; } else { echo "<title>Amar Ela | Song List</title>"; } ?> <meta charset="utf-8"> <meta name="viewport" content="width=device-width"> <meta name="Keywords" content="amar ela, Bishnupriya Manipuri Online Song, Bishnupriya, songs, Vishnupriya, Ela, manipuri ela, BM ela, Amar Thator Ela, songs.kaakai.in"> <meta name="Description" content="Site of online Bishnupriya Manipuri music store under KAAKAI newspaper."> </head> <?php if (isset($_GET['album_id'])) { $album_id = textSafety($_GET['album_id']); $result = Database::getInstance()->query("SELECT * FROM album_details WHERE id='{$album_id}'"); $row = mysql_fetch_array($result, MYSQLI_ASSOC); if (!$row) { $url = "index.php"; header("Refresh:0;URL={$url}"); exit(0); } } else { $url = "index.php"; header("Refresh:0;URL={$url}"); exit(0); } $detect = new Mobile_Detect(); $mobile_browser = false; if ($detect->isMobile() && !$detect->isTablet()) {
<?php include "../inc/database.class.php"; include "../inc/common.class.php"; if (isset($_POST['loginBtn'])) { $email = textSafety($_POST['email']); $password = md5(textSafety($_POST['password'])); if (isset($_POST['keep_me'])) { $keep_me = textSafety($_POST['keep_me']); } else { $keep_me = "no"; } $sql = "SELECT * FROM admin WHERE email='{$email}' && password='******'"; $result = Database::getInstance()->query($sql); $row = mysql_fetch_array($result, MYSQLI_ASSOC); if ($row) { if ($keep_me == "yes") { setcookie("songs_email", $email, time() + 86400 * 30); // 86400 = 1 day setcookie("songs_keep", $keep_me, time() + 86400 * 30); // 86400 = 1 day } else { if (isset($_COOKIE['songs_email'])) { unset($_COOKIE['songs_email']); setcookie('songs_email', '', time() - 3600); // empty value and old timestamp } if (isset($_COOKIE['songs_keep'])) { unset($_COOKIE['songs_keep']); setcookie('songs_keep', '', time() - 3600); // empty value and old timestamp
<?php require_once "../inc/common.class.php"; header("Access-Control-Allow-Origin: *"); header("Access-Control-Allow-Headers: Authorization"); header("Content-Type: application/json; charset=UTF-8;"); $response = []; $db = new DB(); if (isset($_GET) && isset($_GET['get']) && $_GET['get'] == 'BNR' && isset($_GET['place'])) { $place = textSafety($_GET['place']); if ($place == 'browse-top') { $get_banner = "SELECT * FROM banner_mobile WHERE place='{$place}' && status=1 ORDER BY RAND() LIMIT 1"; } elseif ($place == 'browse-middle') { $get_banner = "SELECT * FROM banner_mobile WHERE place='{$place}' && status=1 ORDER BY RAND() LIMIT 3"; } elseif ($place == 'album-top') { $get_banner = "SELECT * FROM banner_mobile WHERE place='{$place}' && status=1 ORDER BY RAND() LIMIT 1"; } elseif ($place == 'album-bottom') { $get_banner = "SELECT * FROM banner_mobile WHERE place='{$place}' && status=1 ORDER BY RAND() LIMIT 1"; } elseif ($place == 'radio') { $get_banner = "SELECT * FROM banner_mobile WHERE place='{$place}' && status=1 ORDER BY RAND() LIMIT 1"; } $get_banner_results = $db->query($get_banner); $lists = []; while ($row = $get_banner_results->fetch_assoc()) { $temp_array = []; $temp_array['albumId'] = isset($row['album_id']) ? $row['album_id'] : ''; $temp_array['bannerName'] = $row['name']; $temp_array['bannerUrl'] = $row['url']; $temp_array['bannerImage'] = $row['image_location']; $temp_array['place'] = $row['place']; $lists[] = $temp_array;
<?php ob_start(); session_start(); if (!isset($_SESSION['flag']) || empty($_SESSION['flag']) || !isset($_SESSION['email']) || empty($_SESSION['email'])) { $url = "../index.php"; header("Refresh:0;URL={$url}"); exit(0); } else { include "../inc/database.class.php"; include "../inc/common.class.php"; if (isset($_POST['upload_ad'])) { $ad_title = textSafety($_POST['ad_title']); $ad_link = textSafety($_POST['ad_link']); $ad_place = textSafety($_POST['ad_place']); if ($ad_title == "") { $url = "../upload-advertise.php?error=1&empty=title&ad_link={$ad_link}"; header("Refresh:0;URL={$url}"); exit(0); } if ($ad_link != "") { if (!filter_var($ad_link, FILTER_VALIDATE_URL)) { $url = "../upload-advertise.php?error=2&invalid=link&ad_title={$ad_title}&ad_link={$ad_link}"; header("Refresh:0;URL={$url}"); exit(0); } } else { $ad_link = "http://amarela.kaakai.in"; } $file_name = ""; $file_name = uploadImage("advertise-image");