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_jaincensus_report.php

<?php

include "Database.php";

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

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

$obj= new Database();

$te="select * from member where 1";

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

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

//echo "hello"; die;

$head=array("S.No","Family Head","Address","State","District","Tehsil","Town","Mobile","Male Count","Female Count","Occupation","Information Provider","Information Provider Contact");

fputcsv($f, $head);

$i=1;

foreach($result as $row) {

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

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

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

$malecount = $obj->getSingleRow($querymale);

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

$femalecount = $obj->getSingleRow($queryfemale);

$array=array(

$i,$result1['name'],$row['address'],$row['state'],$row['city'],$row['tehsil'],$row['town'],$result1['mobile_no'],$malecount['count'],$femalecount['count'],$result1['profession'],$row['information_provider'],$row['information_provider_contact']);

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_jaincensus_report.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation