Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache

System:

Linux 4.18.0-553.100.1.el8_10.x86_64

PHP Version:

7.2.34

User:

jaindirectory

Directory:

/home/jaindirectory/www

Free Space:

32.08 GB

🔧 Quick Actions

✏️ Editing: search_sub.php

<?php

## Database configuration

$host = "jaindirectory.in"; /* Host name */

$user = "jaindire_eway"; /* User */

$password = "@n!?8aY-zde?"; /* Password */

$dbname = "jaindire_eway"; /* Database name */

$con = mysqli_connect($host, $user, $password,$dbname);

// Check connection

if (!$con) {

die("Connection failed: " . mysqli_connect_error());

}

## Read value

$draw = $_POST['draw'];

$row = $_POST['start'];

$rowperpage = $_POST['length']; // Rows display per page

$columnIndex = $_POST['order'][0]['column']; // Column index

$columnName = $_POST['columns'][$columnIndex]['data']; // Column name

$columnSortOrder = $_POST['order'][0]['dir']; // asc or desc

$searchValue = $_POST['search']['value']; // Search value

## Search

$searchQuery = " ";

if($searchValue != ''){

$searchQuery = " and (name like '%".$searchValue."%' or

s_o like '%".$searchValue."%' or

mobile_no like '%".$searchValue."%' or

family_mo like '%".$searchValue."%' or

address like'%".$searchValue."%' or

family_id like'%".$searchValue."%') ";

}

## Total number of records without filtering

$sel = mysqli_query($con,"select count(*) as allcount from member_info as m join member as i on m.member_id=i.id where name!='' ");

$records = mysqli_fetch_assoc($sel);

$totalRecords = $records['allcount'];

## Total number of record with filtering

$sel = mysqli_query($con,"select count(*) as allcount from  member_info as m join member as i on m.member_id=i.id where name!='' ".$searchQuery);

$records = mysqli_fetch_assoc($sel);

$totalRecordwithFilter = $records['allcount'];

## Fetch records

$empQuery = "select * from  member_info as m join member as i on m.member_id=i.id where name!='' ".$searchQuery." order by ".$columnName." ".$columnSortOrder." limit ".$row.",".$rowperpage;

$empRecords = mysqli_query($con, $empQuery);

$data = array();

while ($row = mysqli_fetch_assoc($empRecords)) {

$mobile=$row['mobile_no'].','.$row['family_mo'];

$data[] = array(

"name"=>$row['name'],

"s_o"=>$row['s_o'],

"mobile_no"=>$mobile,

"address"=>$row['address'],

"family_id"=>$row['family_id']

);

}

## Response

$response = array(

"draw" => intval($draw),

"iTotalRecords" => $totalRecordwithFilter,

"iTotalDisplayRecords" => $totalRecords,

"aaData" => $data

);

echo json_encode($response);

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: search_sub.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation