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

Free Space:

31.91 GB

🔧 Quick Actions

✏️ Editing: export_data_consolidate.php

<?php

include "Database.php";

header('Content-Type: application/csv');

header('Content-Disposition: attachment; filename=Export_data_consolidate_list.csv;');

$obj= new Database();

$temple=$_REQUEST['temple'];

$profession=$_POST['profession'];

$blood_group=$_POST['blood_group'];

$income=$_POST['income'];

$town=$_POST['town'];

$tehsil=$_POST['tehsil'];

$gender=$_POST['gender'];

$mariatal_status=$_POST['mariatal_status'];

$te="select * from member as m join member_info as i on m.id=i.member_id where 1";

if($temple!='')

{

$te.=" and m.relation_temple='$temple'";

}

if($profession!='' || $blood_group!='' || $gender!='' || $mariatal_status!='') {

if($profession!='')

{

$te.=" and i.profession='$profession'";

}

if($blood_group!='')

{

$te.=" and i.blood_group='$blood_group'";

}

if($gender!='')

{

$te.=" and i.gender='$gender'";

}

if($mariatal_status!='')

{

$te.=" and i.mariatal_status='$mariatal_status'";

}

} else {

$te.=" and relation='self'";

}

if($income!='')

{

$te.=" and m.income='$income'";

}

if($town!='')

{

$te.=" and m.town='$town'";

}

if($tehsil!='')

{

$te.=" and m.tehsil='$tehsil'";

}

//$query = "SELECT * FROM `member` as m join member_info as i on m.id=i.member_id order by i.id";

$result = $obj->getAllData($te);

$f = fopen("abc.csv", "w");

//echo "hello"; die;

$head=array("S.No","Name","Age","Blood Group","Temple","Address","Mobile Number");

fputcsv($f, $head);

$i=1;

foreach($result as $row) {

$query1 = "select * from `temple` where `id`='".$row['relation_temple']."' ";

$result1 = $obj->getSingleRow($query1);

# object oriented

$from = new DateTime($row['dob']);

$to   = new DateTime('today');

$age=$from->diff($to)->y;

$array=array(

$i,$row['name'],$age,$row['blood_group'],$result1['name'],$row['address'],$row['family_mo']);

fputcsv($f, $array);

$i++;

}

fclose($f);

$file1 = fopen('abc.csv', 'r');

while(!feof($file1)) {

echo fgets($file1);

}

fclose($file1);

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: export_data_consolidate.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation