| Server IP : 192.124.249.33 / Your IP : 66.248.200.33 Web Server : Apache System : Linux 141.134.66.148.host.secureserver.net 3.10.0-1160.119.1.el7.tuxcare.els6.x86_64 #1 SMP Fri Sep 13 13:42:20 UTC 2024 x86_64 User : tarangglobal ( 1001) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/tarangglobal/public_html/cyber/admin/ |
Upload File : |
<?php require_once("pdoconfig.php");
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<meta name="description" content="Materia - Admin Template">
<meta name="keywords" content="materia, webapp, admin, dashboard, template, ui">
<meta name="author" content="solutionportal">
<!-- <base href="/"> -->
<title>Music Video</title>
<!-- Icons -->
<link rel="stylesheet" href="fonts/ionicons/css/ionicons.min.css">
<link rel="stylesheet" href="fonts/font-awesome/css/font-awesome.min.css">
<!-- Plugins -->
<link rel="stylesheet" href="styles/plugins/c3.css">
<link rel="stylesheet" href="styles/plugins/waves.css">
<link rel="stylesheet" href="styles/plugins/perfect-scrollbar.css">
<!-- Css/Less Stylesheets -->
<link rel="stylesheet" href="styles/bootstrap.min.css">
<link rel="stylesheet" href="styles/main.min.css">
<link href='http://fonts.googleapis.com/css?family=Roboto:400,500,700,300' rel='stylesheet' type='text/css'>
<!-- Match Media polyfill for IE9 -->
<!--[if IE 9]> <script src="scripts/ie/matchMedia.js"></script> <![endif]-->
<style>
.dropdown-menu {
position: absolute;
top: 100%;
left: 0;
z-index: 1000;
display: none;
float: left;
min-width: 160px;
padding: 5px 0;
margin: 2px 0 0;
list-style: none;
font-size: 14px;
text-align: left;
background-color: #ffffff;
border: 1px solid #cccccc;
border: 1px solid #eeeeee;
border-radius: 2px;
-webkit-box-shadow: 0 6px 12px rgba(0, 0, 0, 0.175);
box-shadow: 0 6px 12px rgba(0, 0, 0, 0.175);
background-clip: padding-box;
}
.table > tbody > tr > td {
padding-left:6px;
padding-right:6px;
}
.table > tbody > tr > td, .table > tfoot > tr > td {
padding: 3px;
}
.actives{
background-color: rgb(58, 57, 57) !important;
}
.auto-style1 {
text-align: left;
}
.table > thead > tr > th, .table > tbody > tr > th, .table > tfoot > tr > th, .table > thead > tr > td, .table > tbody > tr > td, .table > tfoot > tr > td {
padding: 2px;
}
.form-control{
border:1px solid#ddd;
}
.table-1 tr td{
border:1px solid#ddd;
padding:5px;
}
</style>
</head>
<body id="app" class="app off-canvas">
<!-- #Start header -->
<?php include('_header.php');?>
<!-- #end header -->
<!-- main-container -->
<div class="main-container clearfix">
<!-- main-navigation -->
<?php include('_left-menu.php');?>
<!-- #end main-navigation -->
<!-- content-here -->
<div class="content-container" id="content">
<!-- dashboard page -->
<div class="page page-dashboard">
<div class="page-wrap">
<div class="row">
<div class="col-md-12" style="margin-top:25px;">
<div class="dash-head clearfix mb20">
<div class="left">
<h3 class="mb5 text-light" style="margin-top:0px;">Music Video</h3>
</div>
<div class="right mt10">
<h5 class="text-bold mb0 mt5"><a href="music_video.php?act=add">Add New Record</a></h5>
</div>
<?php include('_right_menu.php');?>
</div>
</div>
<div class="row">
<?php
$act=$_REQUEST['act'];
$catid=$_REQUEST['video_id'];
if(isset($_REQUEST['catid']))
{
$catid=$_REQUEST['catid'];
$sqlu="select * from aa_music_video where video_id=$catid";
$res= $action->select($sqlu);
foreach ($res as $id=>$row){
$video_name=htmlspecialchars($row['video_name']);
$audio_link=htmlspecialchars($row['audio_link']);
$approve=htmlspecialchars($row['approve']);
$active=$row['approve'];
}
}
?>
<?php if($act=='add' || $act=='edit' || $act=='del'){?>
<div class="col-md-12">
<div class="col-md-6" style="margin:auto;float:none;">
<form method="post" action="music_video_act.php" enctype="multipart/form-data" name="myForm" >
<input name="video_id" type="hidden" value="<?=$catid?>"/>
<input name="act" type="hidden" value="<?=$act?>"/>
<div style="width:100%;float:left;background-color:#fff;padding:15px;">
<div class="col-md-12" style="margin-bottom:10px;">
<label>Video Name</label>
<input type="text" name="pname" class="form-control" value="<?=$video_name;?>"/>
</div>
<div class="col-md-12" style="margin-bottom:10px;">
<label>YouTube Video Embedd Link</label>
<input type="text" name="plink" class="form-control" value="<?=$audio_link;?>"/>
</div>
<div class="col-md-6" style="margin-bottom:10px;">
<label>Action</label>
<select class="form-control" name="action" id="catname" class="form-control">
<option value="-1">-- Select Action --</option>
<option value="0" <?php if($approve==0) echo "Selected";?>>Pending</option>
<option value="1" <?php if($approve==1) echo "Selected";?>>Approve</option>
</select>
</div>
<div class="col-md-12" style="text-align:center;margin-top:20px;">
<?php if($act=='add'){?>
<button class="btn btn-primary mr5 waves-effect" type="submit" value="add" id="btn-add">Save</button>
<?php }
else if($act=='edit')
{ ?>
<button class="btn btn-primary mr5 waves-effect" type="submit" value="edit" id="btn-add">Save</button>
<a href="music_video_act.php?video_id=<?=$catid;?>&act=del" class="btn btn-primary mr5 waves-effect">Delete</a>
<?php } ?>
</div>
</form>
</div>
</div>
<?php } ?>
<!-- style three -->
<div class="col-md-12">
<div class="col-md-12 mb30 mt30" style="background-color:#fff;padding:15px;">
<table class="table-1 table-bordered table-hover" style="width:100%;">
<thead>
<tr style="background:#f1f1f1;">
<td class="text-left">#</td>
<td class="auto-style1">Video Names</td>
<td class="auto-style1">Video Link</td>
<td style="auto-style1">Action</td>
</tr>
</thead>
<tbody>
<?php
$num_rec_per_page=15;
if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };
$i=1+$start_from = ($page-1) * $num_rec_per_page;
$sql="select * from aa_music_video ";
//echo $sql;
$resb=$action->select($sql);
foreach($resb as $id=>$row)
{
$date=$row['d1'];
$newDate = date("d-m-Y", strtotime($date));
?>
<tr>
<td class="text-left"><?=$i++;?></td>
<td class="text-left"><?=$row['video_name'];?></td>
<td class="text-left"><?=$row['audio_link'];?></td>
<td class="text-left"><a href="music_video.php?catid=<?=$row['video_id']?>&act=edit" class="link btn-primary" style="padding:5px;border-radius:2px">Update</a>
</td>
</tr>
<?php } ?>
</tbody>
</table>
<div style="width:100%;float:left;text-align:center;background:#fff;padding: 10px;">
<div style="width:100%;float:left;">
<?php
$params = $_SERVER['QUERY_STRING'];
$params=str_replace("page=","",$params);
$p=substr($params,0,strpos($params,"&"));
$sql="select * from aa_music_video" .$cond;
//echo $sql;
$res= $action->select($sql); //run the query
$total_records =count($res); //count number of records
//echo $total_records;
$total_pages = ceil($total_records / $num_rec_per_page);
echo "<a style='background-color: rgb(255, 45, 0);color:#fff;padding: 1px 4px;' href='music_video.php?page=1&$params'>".'First'."</a> "; // Goto 1st page
for ($i=1; $i<=$total_pages; $i++)
{
$a="";
if($p==$i){ $a="active"; }
echo "<a class='$a' style='background-color: rgb(255, 45, 0);color:#fff;padding: 1px 4px;' href='music_video.php?page=".$i."&".$params."'>".$i."</a> ";
};
echo "<a style='background-color: rgb(255, 45, 0);color:#fff;padding: 1px 4px;' href='music_video.php?page=$total_pages&$params'>".'Last'."</a> "; // Goto last page
?>
</div>
</div>
</div>
</div>
</div>
</div> <!-- #end page-wrap -->
</div>
<!-- #end dashboard page -->
</div>
</div> <!-- #end main-container -->
<!-- theme settings -->
<div class="site-settings clearfix hidden-xs">
<div class="settings clearfix">
<div class="trigger ion ion-settings left"></div>
<div class="wrapper left">
<ul class="list-unstyled other-settings">
<li class="clearfix mb10">
<div class="left small">Nav Horizontal</div>
<div class="md-switch right">
<label>
<input type="checkbox" id="navHorizontal">
<span> </span>
</label>
</div>
</li>
<li class="clearfix mb10">
<div class="left small">Fixed Header</div>
<div class="md-switch right">
<label>
<input type="checkbox" id="fixedHeader">
<span> </span>
</label>
</div>
</li>
<li class="clearfix mb10">
<div class="left small">Nav Full</div>
<div class="md-switch right">
<label>
<input type="checkbox" id="navFull">
<span> </span>
</label>
</div>
</li>
</ul>
<hr/>
<ul class="themes list-unstyled" id="themeColor">
<li data-theme="theme-zero" class="active"></li>
<li data-theme="theme-one"></li>
<li data-theme="theme-two"></li>
<li data-theme="theme-three"></li>
<li data-theme="theme-four"></li>
<li data-theme="theme-five"></li>
<li data-theme="theme-six"></li>
<li data-theme="theme-seven"></li>
</ul>
</div>
</div>
</div>
<!-- #end theme settings -->
<!-- Dev only -->
<!-- Vendors -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js" type="text/javascript"></script>
<script src="scripts/vendors.js"></script>
<script src="scripts/plugins/d3.min.js"></script>
<script src="scripts/plugins/c3.min.js"></script>
<script src="scripts/plugins/screenfull.js"></script>
<script src="scripts/plugins/perfect-scrollbar.min.js"></script>
<script src="scripts/plugins/waves.min.js"></script>
<script src="scripts/plugins/jquery.sparkline.min.js"></script>
<script src="scripts/plugins/jquery.easypiechart.min.js"></script>
<script src="scripts/plugins/bootstrap-rating.min.js"></script>
<script src="scripts/app.js"></script>
<script src="scripts/index.init.js"></script>
<script>
$(document).ready(function(){
var crs='<?=$crs_id?>';
if(crs!='')
{
// alert(crs);
crs_val(crs);
}
});
function choice1()
{
var x = document.getElementById("fee");
var x2=x.options[x.selectedIndex].value;
var xsplit=x2.split("|");
$("#feers").val(xsplit[1]);
}
</script>
<script>
/*
function crs_val()
{
var cid=$("#crsname").val();
$.getJSON("http://tarangglobal.com/join_detail.php?callback=?","cid="+cid, function(data){
var tab='<option value="">Select Timing</option>';
var tab1='<option value="">Select Fee</option>';
$.each(data,function(i,element)
{
var t=element.timings;
var t1=t.split(",");
var f=element.fee;
var f1=f.split(",");
t1.forEach(function(e) {
e=e.trim();
tab+='<option value="'+e+'" >'+e+'</option>';
});
f1.forEach(function(g) {
g=g.trim();
tab1+='<option value="'+g+'">'+g+'</option>';
});
$("#time").html(tab);
$("#fee").html(tab1);
});
var time1="<?=$time_1;?>";
var fees1="<?=$pawan;?>";
if(time1!='' )
$("#time").val(time1);
if(fees1!='' )
$("#fee").val(fees1);
});
}
*/
</script>
</body>
</html>Private