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.87 GB

🔧 Quick Actions

✏️ Editing: export_detail_csv.php

<?php

include "Database.php";

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

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

$obj= new Database();

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

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

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

//echo "hello"; die;

$head=array("S.No","Information Provider","Name","S/O OR W/O","Relation","Gender","DOB","Marital Status","Education","Profession","Mobile Number","Blood Group","User Name","Address","State","City","Town","Monthly Income","Family Mobile Number","Establishment","Establishment Address","Establishment Name","Relation To Temple","Created Date");

fputcsv($f, $head);

foreach($result as $row) {

$sql="select * from user where id=".$row['user_id'];

$user = $obj->getSingleRow($sql);

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

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

//print_r($user); die;

$array=array(

$row['id'],$row['information_provider'],$row['name'],$row['s_o'],$row['relation'],$row['gender'],$row['dob'],$row['mariatal_status'],$row['education'],$row['profession'],$row['mobile_no'],$row['blood_group'],$user['name'],$row['address'],$row['state'],$row['city'],$row['town'],$row['income'],$row['family_mo'],$row['establishment'],$row['establishment_address'],$row['establishment_name'],$temple['name'],$row['created_date'],

);

fputcsv($f, $array);

}

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

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation