Tiny File Manager

Back Back Up Advanced Editor

<?php
	//include connection file 
	require_once("./include/connection.php");
	 
	// initilize all variable
	$params = $columns = $totalRecords = $data = array();

$params = $_REQUEST;

//define index of column
	$columns = array( 
		0 =>'id',
		1 =>'FILE_NAME', 
		2 => 'CATEGORY',
		3 => 'UPLOADED_BY'
	);

$where = $sqlTot = $sqlRec = "";

// check search value exist
	if( !empty($params['search']['value']) ) {   
		$where .=" WHERE ";
		$where .=" ( FILE_NAME LIKE '".$params['search']['value']."%' ";    
		$where .=" OR CATEGORY LIKE '".$params['search']['value']."%' ";

$where .=" OR UPLOADED_BY LIKE '".$params['search']['value']."%' )";
	}

// getting total number records without any search
	//$sql = "SELECT * FROM `employee` ";
	$sql="SELECT * FROM `upload_data`";
	$sqlTot .= $sql;
	$sqlRec .= $sql;
	//concatenate search sql if value exist
	if(isset($where) && $where != '') {

$sqlTot .= $where;
		$sqlRec .= $where;
	}

$sqlRec .=  " ORDER BY ". $columns[$params['order'][0]['column']]."   ".$params['order'][0]['dir']."  LIMIT ".$params['start']." ,".$params['length']." ";

$queryTot = mysqli_query($conn, $sqlTot) or die("database error:". mysqli_error($conn));

$totalRecords = mysqli_num_rows($queryTot);

$queryRecords = mysqli_query($conn, $sqlRec) or die("error to fetch files data");

//iterate on results row and create new index array of data
	while( $row = mysqli_fetch_row($queryRecords) ) { 
		$data[] = $row;
	}

$json_data = array(
			"draw"            => intval( $params['draw'] ),   
			"recordsTotal"    => intval( $totalRecords ),  
			"recordsFiltered" => intval($totalRecords),
			"data"            => $data   // total data array
			);

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