<?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");
