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

<?php
include "Database.php";
header('Content-Type: application/csv');
header('Content-Disposition: attachment; filename=jaindirectory_unmarried.csv;');
$obj= new Database();
$query = "select * from member as m join member_info as n on n.member_id=m.id where m.relation_temple in (SELECT id from temple WHERE sub_community_id='0') and n.mariatal_status in ('Unmarried','Single') order by n.id desc";
$result = $obj->getAllData($query);

$f = fopen("abc.csv", "w");
//echo "hello"; die;
$head=array("Name","Age","Qualification","Address","Income","Mukhiya"," Mobile-No.","family_no","male/female");
 fputcsv($f, $head);
 
foreach($result as $row) {
	$query1 = "select * from `member` where `id`='".$row['member_id']."' ";
					$result1 = $obj->getSingleRow($query1);
	$from = new DateTime($row['dob']);
							$to   = new DateTime('today');
							 $age=$from->diff($to)->y;
							 if($age>'20' && $age<'100') { 
	//print_r($user); die;
	
$array=array(
			$row['name'],$age,$row['education'],$result1['address'],$result1['income'],$row['s_o'],$row['mobile_no'],$result1['family_mo'],$row['gender']);
    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_unmarried_report.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation