File Manager

✏️ Edit File: /home/coemyoza/sms.coeminna.edu.ng/students/export_file/csv_export_membership_report.php

<?php
include('../../db/dbc.php');

$filename=date('d-m-y_h:m:sa').'-export-report.csv';
header('Content-Type: text/csv'); 
header('Content-Disposition: attachment;filename='.$filename);

$sql = "select * from `membership_app` order by id desc";	
	  $res = mysqli_query($link,$sql);
	  $num=mysqli_num_rows($res);

if($num > 0){

echo 'S/N, PIN/USERNAME, NAME, COMMAND, RANK, MONTHLY CONTRIBUTION(NGN), EFFECTIVE DATE OF DEDUCTION, STATUS, APPLICATION DATE';
	echo "\r\n";
	$i=1;
	while($row=mysqli_fetch_array($res)){

//start search for equipment		  
$name = strtoupper($row['sname']). " " .ucwords($row['oname']);
								
if($row['status'] == 0) { $status = 'Pending'; }
elseif($row['status'] == 1) { $status = 'Processing'; }
elseif($row['status'] == 2) { $status = 'Approved'; }
else { $status = 'Declined'; }
//end search for equipment 
		 
		echo $i.','.$row['pin'].','.$name.','.$row['cmd'].','.$row['rank'].','.$row['ain_figure'].','.$row['deduction_date'].','.$status.','.$row['app_date'];
		echo "\r\n";
		$i++;
	}
}else{
	echo 'No Data Found';
}

Batal

⬅ Naik ke students 5 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘csv_export_contributions_scheldule_report.php	php	1.8 KB	2024-08-05 07:55	✏️ Edit 👁️ View
🐘csv_export_loan_repayment_scheldule_report.php	php	1.8 KB	2024-08-05 07:55	✏️ Edit 👁️ View
🐘csv_export_loan_request_report.php	php	1.6 KB	2024-08-05 07:55	✏️ Edit 👁️ View
🐘csv_export_membership_report.php	php	1 KB	2024-08-05 07:55	✏️ Edit 👁️ View
🐘csv_export_revcont_request_report.php	php	1.6 KB	2024-08-05 07:55	✏️ Edit 👁️ View