File Manager

X7ROOT File Manager

Current Path: /home/jeyam/public_html/ktgadmin

📁 ..
📄 .htaccess(200 B)
📄 academics_services.php(17.13 KB)
📄 academics_sidetab_multi_image_descp.php(6.2 KB)
📄 academics_sidetab_multi_image_descp_grid.php(4.15 KB)
📄 academics_sidetab_multi_images_grid.php(3.58 KB)
📄 add_academics_sidetab_multi_images.php(7.92 KB)
📄 add_events_maincategory_sidetab_multi_images.php(7.96 KB)
📄 add_products_maincategory_sidetab_multi_images.php(7.96 KB)
📄 add_trips_sidetab_multi_images.php(7.9 KB)
📄 banner_details.php(7.86 KB)
📄 banner_grid.php(3.86 KB)
📄 banner_services.php(3.08 KB)
📄 clients.php(7.3 KB)
📄 clients_grid.php(3.62 KB)
📄 clients_services.php(2.83 KB)
📁 css
📄 db_config.php(221 B)
📄 db_new_karur_public_school.sql(13.12 KB)
📄 events_main_category_grid.php(3.67 KB)
📄 events_main_category_sidetab_mimg_descp_grid.php(4.53 KB)
📄 events_maincategory_dropdown.php(473 B)
📄 events_maincategory_sidetab_multi_images_grid.php(3.63 KB)
📄 events_services.php(17.04 KB)
📄 events_yearcat_sidetab_multi_image_descp.php(14.4 KB)
📄 faculty_mail.php(1.04 KB)
📄 faculty_reg.php(3.78 KB)
📄 faculty_reg_grid.php(3.13 KB)
📄 faculty_reg_insert.php(1.15 KB)
📄 gallery_cat_grid.php(3.67 KB)
📄 gallery_category_dropdown.php(477 B)
📄 gallery_services.php(7.85 KB)
📄 gallery_w_grid.php(4.1 KB)
📄 gallery_with_filter_details.php(15.79 KB)
📄 header.php(7.55 KB)
📄 img_upload.php(606 B)
📄 index.php(4.8 KB)
📄 industries.php(16.21 KB)
📄 industries_cat_grid.php(3.66 KB)
📄 industries_category_dropdown.php(468 B)
📄 industries_grid.php(4.21 KB)
📄 industries_services.php(5.62 KB)
📁 js
📄 latest_news.php(8.22 KB)
📄 latest_news_grid.php(3.83 KB)
📄 latest_news_services.php(3.16 KB)
📄 login.php(1.13 KB)
📄 logout.php(213 B)
📄 mail.php(982 B)
📁 media
📄 popup_image_details.php(7.33 KB)
📄 popup_image_grid.php(3.65 KB)
📄 popup_services.php(4.72 KB)
📄 products_main_category_grid.php(3.68 KB)
📄 products_main_category_sidetab_mimg_descp_grid.php(4.54 KB)
📄 products_maincategory_dropdown.php(475 B)
📄 products_maincategory_sidetab_multi_images_grid.php(3.63 KB)
📄 products_services.php(17.1 KB)
📄 products_yearcat_sidetab_multi_image_descp.php(14.42 KB)
📄 profile_autobind.php(937 B)
📄 profile_update.php(932 B)
📄 roofing.php(16.18 KB)
📄 roofing_cat_grid.php(3.65 KB)
📄 roofing_category_dropdown.php(465 B)
📄 roofing_grid.php(4.19 KB)
📄 roofing_services.php(5.59 KB)
📄 settings.php(9.46 KB)
📄 steels.php(16.17 KB)
📄 steels_cat_grid.php(3.65 KB)
📄 steels_category_dropdown.php(464 B)
📄 steels_grid.php(4.19 KB)
📄 steels_services.php(5.58 KB)
📄 student_mail.php(1.05 KB)
📄 student_reg.php(3.78 KB)
📄 student_reg_delete.php(502 B)
📄 student_reg_grid.php(3.04 KB)
📄 student_reg_insert.php(973 B)
📄 team.php(8.23 KB)
📄 team_grid.php(3.72 KB)
📄 team_services.php(3.07 KB)
📁 temp
📄 trips_services.php(17.01 KB)
📄 trips_sidetab_multi_image_descp.php(6.19 KB)
📄 trips_sidetab_multi_image_descp_grid.php(4.13 KB)
📄 trips_sidetab_multi_images_grid.php(3.57 KB)
📄 update_academics_sidetab_multi_image_descp.php(4.9 KB)
📄 update_banner.php(6.66 KB)
📄 update_clients.php(6.06 KB)
📄 update_events_yearcat_sidetab_multi_image_desp.php(13.18 KB)
📄 update_gallery_with_filter.php(13.34 KB)
📄 update_industries.php(13.93 KB)
📄 update_latest_news.php(7.13 KB)
📄 update_popup_image.php(6.1 KB)
📄 update_products_yearcat_sidetab_multi_image_desp.php(13.2 KB)
📄 update_roofing.php(13.91 KB)
📄 update_steels.php(13.9 KB)
📄 update_team.php(6.89 KB)
📄 update_trips_sidetab_multi_image_descp.php(4.88 KB)
📄 update_video_with_filter.php(4.91 KB)
📁 userdata
📁 vendors
📄 video_cat_grid.php(3.67 KB)
📄 video_category_dropdown.php(475 B)
📄 video_services.php(6.26 KB)
📄 video_w_grid.php(3.85 KB)
📄 video_with_filter_details.php(6.17 KB)

Editing: video_services.php

<?php
include_once('header.php');
include_once("db_config.php");	
date_default_timezone_set('Asia/Kolkata');	
class video_services{
	function __construct($conn){
		$this->mySQLconn=$conn;
	}
	
	function video_wof_insert($curdate){
		$title=str_replace("'","^",$_POST['title']);
		
		$sql= "INSERT INTO tbl_video_without_filter (title,link,created_by,create_date) VALUES('".$title."','".$_POST['link']."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function video_wof_delete($curdate){
		$sql= "update tbl_video_without_filter set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where vid_wof_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function video_wof_autobind($curdate){
		$bannerData=array();
		$sql= "select * from tbl_video_without_filter where vid_wof_id='".$_POST['vid_wof_id']."' and delete_status='NDL'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		$rows=mysqli_num_rows($exec_query);
		if($rows>0){
			while($row=mysqli_fetch_array($exec_query,MYSQLI_ASSOC)){
				$bannerData[]=str_replace("^","'",$row);		
			}
		}
		return $bannerData;
	}
	function video_wof_update($curdate){
		$title=str_replace("'","^",$_POST['title']);
		
		$sql= "update tbl_video_without_filter set title='".$title."',link='".$_POST['link']."',updated_by='".$_SESSION['login_user']."',update_date='".$curdate."' where vid_wof_id='".$_POST['vid_wof_id']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function video_w_filter_cat_insert($curdate){
		$cat_name=str_replace("'","^",$_POST['cat_name']);
		
		$sql= "INSERT INTO tbl_video_with_filter_category (title,created_by,create_date) VALUES('".$cat_name."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function video_w_filter_cat_autobind($curdate){
		$bannerData=array();
		$sql= "select * from tbl_video_with_filter_category where vid_cat_id='".$_POST['vid_cat_id']."' and delete_status='NDL'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		$rows=mysqli_num_rows($exec_query);
		if($rows>0){
			while($row=mysqli_fetch_array($exec_query,MYSQLI_ASSOC)){
				$bannerData[]=str_replace("^","'",$row);		
			}
		}
		return $bannerData;
	}
	function video_w_filter_cat_update($curdate){
		$cat_name=str_replace("'","^",$_POST['cat_name']);
		
		$sql= "update tbl_video_with_filter_category set title='".$cat_name."',updated_by='".$_SESSION['login_user']."',update_date='".$curdate."' where vid_cat_id='".$_POST['vid_cat_id']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function video_w_filter_cat_delete($curdate){
		$sql= "update tbl_video_with_filter_category set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where vid_cat_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function video_w_insert($curdate){
		$title=str_replace("'","^",$_POST['title']);
		
		$sql= "INSERT INTO tbl_video_with_filter (title,link,created_by,create_date) VALUES('".$title."','".$_POST['link']."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function video_w_delete($curdate){
		$sql= "update tbl_video_with_filter set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where vid_w_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function video_w_autobind($curdate){
		$bannerData=array();
		$sql= "select * from tbl_video_with_filter where vid_w_id='".$_POST['vid_w_id']."' and delete_status='NDL'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		$rows=mysqli_num_rows($exec_query);
		if($rows>0){
			while($row=mysqli_fetch_array($exec_query,MYSQLI_ASSOC)){
				$bannerData[]=str_replace("^","'",$row);		
			}
		}
		return $bannerData;
	}
	function video_w_update($curdate){
		$title=str_replace("'","^",$_POST['title']);
		
		$sql= "update tbl_video_with_filter set title='".$title."',link='".$_POST['link']."',updated_by='".$_SESSION['login_user']."',update_date='".$curdate."' where vid_w_id='".$_POST['vid_w_id']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	
}		
$objVDS=new video_services($conn);
$curdate=date('Y-m-d H:i:s');
if($_POST['req']=='VIDWOFINS'){
	$rtnMsg=$objVDS->video_wof_insert($curdate);
}
else if($_POST['req']=='VIDWOFDEL'){
	$rtnMsg=$objVDS->video_wof_delete($curdate);
}
else if($_POST['req']=='VIDWOFAUB'){
	$rtnMsg=$objVDS->video_wof_autobind($curdate);
}
else if($_POST['req']=='VIDWOFUPD'){
	$rtnMsg=$objVDS->video_wof_update($curdate);
}
else if($_POST['req']=='VIDWFADDCAT'){
	$rtnMsg=$objVDS->video_w_filter_cat_insert($curdate);
}
else if($_POST['req']=='VIDWFAUBCAT'){
	$rtnMsg=$objVDS->video_w_filter_cat_autobind($curdate);
}
else if($_POST['req']=='VIDWFUPDCAT'){
	$rtnMsg=$objVDS->video_w_filter_cat_update($curdate);
}
else if($_POST['req']=='VIDWFDELCAT'){
	$rtnMsg=$objVDS->video_w_filter_cat_delete($curdate);
}
else if($_POST['req']=='VIDWFINS'){
	$rtnMsg=$objVDS->video_w_insert($curdate);
}
else if($_POST['req']=='VIDWFDEL'){
	$rtnMsg=$objVDS->video_w_delete($curdate);
}
else if($_POST['req']=='VIDWFAUB'){
	$rtnMsg=$objVDS->video_w_autobind($curdate);
}
else if($_POST['req']=='VIDWFUPD'){
	$rtnMsg=$objVDS->video_w_update($curdate);
}
mysqli_close($conn);
$json = array("op" =>$rtnMsg);
			
			// send data as json format
			header("Content-Type: application/json",true);
				echo json_encode($json);
?>

X7ROOT File Manager

Editing: video_services.php

Upload File

Create Folder