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: export_data_consolidate_income.php

<?php

include "Database.php";

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

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

$obj= new Database();

$temple=$_POST['temple'];

$income=$_POST['income'];

$town=$_POST['town'];

$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'";

}

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

if($income!='')

{

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

}

if($town!='')

{

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

}

//$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","Member Count","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);

$query12 = "select * from `member_info` where `member_id`='".$row['member_id']."' ";

$result12 = $obj->numRows($query12);

# object oriented

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

$to   = new DateTime('today');

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

$array=array(

$i,$row['name'],$age,$result12,$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_income.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation