CREATE DOWNLOADABLE CSV FILE IN PHP

CREATE DOWNLOADABLE CSV FILE IN PHP

<?php
mysql_connect('localhost','root','')
mysql_select_db('your database name');
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=total_student.csv');
//to write the csv file
$output = fopen('php://output', 'w');
//heading of your file
fputcsv($output,array('Class','Total no. of students'));


for($i=1;$i<=12;$i++){
$std="select count(enrollment_no) from student_enrollment where student_curr_class_stand='$i'";
$data=mysql_fetch_array(mysql_query($std));
$class="std".$i;
$student=$data[0];
//insert data in your csv file
fputcsv($output,array($class,$student));
}

?>