ekspor data ke excel di php

<?php
$dbhost = "localhost"; // Usually localhost.
$dbname = "tes"; // Database name.
$dbuser = "root"; // Database username.
$dbpass = ""; // Database password.
$dataname = "web-data"; // FILENAME PREFIX THAT WILL BE ADDED TO XL FILE.
$tablename = "tabel_a"; // name of table to extract data from.
$fields = "id_a, nama, jenkel, pekerjaan"; // the fields in the table you want. seperated with comma. Example ($fields = "field1, field2, field3";)
/*
//////////////////////////////////////////////////
/////////// DO NOT EDIT THIS PART OF FILE ////////
//////////////////////////////////////////////////
*/
$datestamp = date("d-m-Y");
$dbh=mysql_connect ($dbhost, $dbuser, $dbpass) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($dbname);
$query = ("SELECT $fields FROM $tablename");
$result=mysql_query($query) or die('Error, unsuccesseful when querying database');
$myarray = array();

$myarray[] ="<table>";
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
    $myarray[] ="<tr>";
    foreach($row as $v) $myarray[] ="<td>$v</td>";
    $myarray[] ="</tr>";
}
$myarray[] ="</table>";

 foreach($myarray as $v)
{
    $s.=$v;
}
$filename = "$dataname-$datestamp.xls";

header("Content-Disposition: attachment; filename=$filename");
header("Content-Type: application/vnd.ms-excel");

echo $s;
?>