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: events_main_category_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 prod_mcat_id ";
$sql.=" FROM tbl_events_main_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 prod_mcat_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_events_main_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 prod_mcat_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['prod_mcat_id']."' class='mCatUpdateTrigger'><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='mCatDeleteTriger' data-value='".$row['prod_mcat_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: events_main_category_grid.php

Upload File

Create Folder