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: gallery_cat_grid.php

<?php
header('Access-Control-Allow-Origin: *');
	//include connection file 
	include_once("db_config.php");
	include_once("header.php");
	 
	
// storing  request (ie, get/post) global array to a variable  
$requestData= $_REQUEST;

$columns = array( 
// datatable column index  => database column name
	0 =>'title', 
	
		
	
);

// getting total number records without any search
$sql = "SELECT gal_cat_id ";
$sql.=" FROM tbl_gallery_with_filter_category";
$query=mysqli_query($conn, $sql) or die("tbl_prpty-grPrpty_Id-data.php: get tbl_prptys");
$totalData = mysqli_num_rows($query);
$totalFiltered = $totalData;  // when there is no search parameter then total number rows = total number filtered rows.

$sql = "SELECT gal_cat_id,title,date_format(create_date,'%d/%m/%Y %H:%i:%s') as create_date,date_format(update_date,'%d/%m/%Y %H:%i:%s') as update_date FROM tbl_gallery_with_filter_category where delete_status='NDL'";

if( !empty($requestData['search']['value']) ) {   // if there is a search parameter, $requestData['search']['value'] contains search parameter
	$sql.=" AND ( title LIKE '".$requestData['search']['value']."%' )";   
	
}
$query=mysqli_query($conn, $sql) or die("tbl_prpty-grPrpty_Id-data.php: get	 tbl_prptys");
$totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result. 
$sql.=" order by gal_cat_id  desc  LIMIT ".$requestData['start']." ,".$requestData['length']."   ";

/* $requestData['order'][0]['column'] contains colmun index, $requestData['order'][0]['dir'] contains order such as asc/desc  */	
$query=mysqli_query($conn, $sql) or die("tbl_prpty-grPrpty_Id-data.php: get tbl_prptys");

$data = array();
$i=1+$requestData['start'];
while( $row=mysqli_fetch_array($query) ) {  // preparing an array
	$nestedData=array();

$nestedData[] = "#".$i ;
	if($row['title']==''){
		$nestedData[] = "-";
	}
	else{
		$nestedData[] = str_replace("^","'",$row["title"]);
	}
	if($row['update_date']!=''){
		$nestedData[] ='<a href="javascript:void(0)" class="badge badge-primary" style="color:#fff">'.$row['update_date'].'</a>';
	}
	else{
		$nestedData[] ='<a href="javascript:void(0)" class="badge badge-primary" style="color:#fff">'.$row['create_date'].'</a>';
	}
    $nestedData[] ="<div class='btn-group' role='group' aria-label='Basic example'>
																	<a href='javascript:void(0)' data-value='".$row['gal_cat_id']."' class='updateTrigger'><button type='button' class='btn btn-success' style='padding:6px 8px;margin-right:5px'>
																		<i class='fa fa-edit' style='color: #fff;padding: 0;margin: 0;font-size: 18px;'></i>
																	</button></a>
																	<a href='javascript:void(0)' class='catDeleteTriger' data-value='".$row['gal_cat_id']."'><button type='button' class='btn btn-danger' style='padding:6px 8px;'>
																		<i class='fa fa-trash' style='color: #fff;padding: 0;margin: 0;font-size: 18px;'></i>
																	</button></a>
																</div>";
	
	
	$data[] = $nestedData;
	$i++;
}

$json_data = array(
			"draw"            => intval( $requestData['draw'] ),   // for every request/draw by clientsPrpty_Ide , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw. 
			"recordsTotal"    => intval( $totalData ),  // total number of records
			"recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData
			"data"            => $data   // total data array
			);

echo json_encode($json_data);  // send data as json format

X7ROOT File Manager

Editing: gallery_cat_grid.php

Upload File

Create Folder