Export Data ke Excel dengan PHP

Teman 🙂 ini ada postingan untuk mengexport data ke excel, dengan menggunakan header , gak ribet..! 🙂

<?php

error_reporting(E_ALL^E_NOTICE);
$conn = mysql_connect(‘localhost’,’root’,”)or die(‘gagal koneksi’);
$db = mysql_select_db(‘db_akademik’)or die(‘gagal database’);

$qry=”SELECT m.kdmk, m.matakuliah, AVG (nilai) AS rata
FROM nilai n
JOIN matakuliah m ON m.kdmk=n.kdmk
GROUP BY matakuliah”;

$res = mysql_query($qry);

$filename=”data.xls”;
header(‘Content-type: application/ms-excel’);
header (‘Content-Disposition: attachment; filename=’.$filename);

$content = ”
<table border=1>
<tr>
<th>Kode Mata Kuliah</th>
<th>Mata Kuliah</th>
<th>Rata-Rata</th>
</tr>
“;
while($data = mysql_fetch_array($res)){
$content .=”
<tr>
<td>”.$data[‘kdmk’].”</td>
<td>”.$data[‘matakuliah’].”</td>
<td>”.$data[‘rata’].”</td>
</tr>
“;

}
$content .=”
</table>

“;
echo $content;
?>