File Manager

✏️ Edit File: /home/coemyoza/sms.coeminna.edu.ng/admins/export_file/csv_export_all_results.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 registered_courses";	
	  $res = mysqli_query($link,$sql);
	  $num=mysqli_num_rows($res);

if($num > 0){

echo 'S/N, MATRIC NO, COURSE CODE, COURSE TITLE, UNITS, DEPARTMENT, LEVEL, SESSION, SEMESTER, COURSE STATUS, TEST SCORES, EXAM SCORES, TOTAL, GRADE';
	echo "\r\n";
	$i=1;
	while($row=mysqli_fetch_array($res)){

//search for student department
$rs_role = mysqli_query($link,"select * from `default_department` where id = '".$row['deptid']."'"); 
while ($rec = mysqli_fetch_array($rs_role)) { $dept = $rec['title']; }

//search for student level
$rs_role = mysqli_query($link,"select * from `default_level` where id = '".$row['levelid']."'"); 
while ($rec = mysqli_fetch_array($rs_role)) { $level = $rec['title']; }

//search for semester level
$rs_role = mysqli_query($link,"select * from `default_academic` where id = '".$row['sesid']."'"); 
while ($rec = mysqli_fetch_array($rs_role)) { $ses = $rec['programs']; }

//search for semester level
$rs_role = mysqli_query($link,"select * from `default_semester` where id = '".$row['semid']."'"); 
while ($rec = mysqli_fetch_array($rs_role)) { $sem = $rec['title']; }

//search for course status
$rs_role = mysqli_query($link,"select * from `course_status` where id = '".$row['cstatus']."'"); 
while ($rec = mysqli_fetch_array($rs_role)) { $title = $rec['title']; }
		 
		echo $i.','.$row['matno'].','.$row['ccode'].','.$row['title'].','.$row['unit'].','.$dept.','.$level.','.$ses.','.$sem.','.$title.','.$row['test_score'].','.$row['exam_score'].','.$row['total_score'].','.$row['grade'];
		echo "\r\n";
		$i++;
	}
}else{
	echo 'No Data Found';
}

Batal

⬅ Naik ke admins 4 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘csv_export_all_courses.php	php	1.5 KB	2024-08-05 07:55	✏️ Edit 👁️ View
🐘csv_export_all_results.php	php	1.8 KB	2024-08-05 07:55	✏️ Edit 👁️ View
🐘csv_export_all_students.php	php	944 B	2024-08-05 07:55	✏️ Edit 👁️ View
🐘csv_export_all_users.php	php	971 B	2024-08-05 07:55	✏️ Edit 👁️ View