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

Free Space:

32.43 GB

🔧 Quick Actions

✏️ Editing: jaincensus_report_test_new.php

<?php

* For more details

* please check official documentation of DataTables  https://datatables.net/manual/server-side

* Coded by charaf JRA

* RefreshMyMind.com

/* IF Query comes from DataTables do the following */

if (!empty($_POST) ) {

* Database Configuration and Connection using mysqli

define("HOST", "jaindirectory.in");

define("USER", "jaindire_jaind");

define("PASSWORD", "#jaind#2015");

define("DB", "jaindire_members");

define("MyTable", "member");

$connection = mysqli_connect(HOST, USER, PASSWORD, DB) OR DIE("Impossible to access to DB : " . mysqli_connect_error());

/* END DB Config and connection */

* @param (string) SQL Query

* @return multidim array containing data array(array('column1'=>value2,'column2'=>value2...))

function getData($sql){

global $connection ;//we use connection already opened

$query = mysqli_query($connection, $sql) OR DIE ("Can't get Data from DB , check your SQL Query " );

$data = array();

foreach ($query as $row ) {

$sql1="select * from member_info where member_id='".$row['id']."' and relation='self'";

$query1 = mysqli_query($connection, $sql1);

foreach ($query1 as $row1 ) {

$row['name']=$row1['name'];

$row['mobile_no']=$row1['mobile_no'];

$row['profession']=$row1['profession'];

}

$sql2="select count(*) as count from `member_info` where member_id='".$row['id']."' and gender='Male'";

$query2 = mysqli_query($connection, $sql2);

foreach ($query2 as $row2 ) {

$row['count1']=$row2['count'];

}

$sql3="select count(*) as count1 from `member_info` where member_id='".$row['id']."' and gender='Female'";

$query3 = mysqli_query($connection, $sql3);

foreach ($query3 as $row3 ) {

$row['count2']=$row3['count1'];

}

/* $row['password']=$query1['name']; */

$data[] = $row ;

}

//echo "<pre>";

//print_r($data);

return $data;

}

/* Useful $_POST Variables coming from the plugin */

$draw = $_POST["draw"];//counter used by DataTables to ensure that the Ajax returns from server-side processing requests are drawn in sequence by DataTables

$orderByColumnIndex  = $_POST['order'][0]['column'];// index of the sorting column (0 index based - i.e. 0 is the first record)

$orderBy = $_POST['columns'][$orderByColumnIndex]['data'];//Get name of the sorting column from its index

$orderType = $_POST['order'][0]['dir']; // ASC or DESC

$start  = $_POST["start"];//Paging first record indicator.

$length = $_POST['length'];//Number of records that the table can display in the current draw

/* END of POST variables */

$recordsTotal = count(getData("SELECT * FROM ".MyTable));

/* SEARCH CASE : Filtered data */

if(!empty($_POST['search']['value'])){

/* WHERE Clause for searching */

for($i=0 ; $i<count($_POST['columns']);$i++){

$column = $_POST['columns'][$i]['data'];//we get the name of each column using its index from POST request

$where[]="$column like '%".$_POST['search']['value']."%'";

}

$where = "WHERE ".implode(" OR " , $where);// id like '%searchValue%' or name like '%searchValue%' ....

/* End WHERE */

$sql = sprintf("SELECT * FROM %s %s", MyTable , $where);//Search query without limit clause (No pagination)

$recordsFiltered = count(getData($sql));//Count of search result

/* SQL Query for search with limit and orderBy clauses*/

$sql = sprintf("SELECT * FROM %s %s ORDER BY %s %s limit %d , %d ", MyTable , $where ,$orderBy, $orderType ,$start,$length  );

$data = getData($sql);

}

/* END SEARCH */

else {

$sql = sprintf("SELECT * FROM %s ORDER BY %s %s limit %d , %d ", MyTable ,$orderBy,$orderType ,$start , $length);

$data = getData($sql);

$recordsFiltered = $recordsTotal;

}

/* Response to client before JSON encoding */

$response = array(

"draw" => intval($draw),

"recordsTotal" => $recordsTotal,

"recordsFiltered" => $recordsFiltered,

"data" => $data

);

echo json_encode($response);

} else {

echo "NO POST Query from DataTable";

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: jaincensus_report_test_new.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation