export data to xls format

[sejal17]

Dear Sir,
Can you tell me how to export data from MySQL database to a xls file using php code?I have to export data from different tables of mysql database to a single xls file.Please help me!!!

Regards,
Sejal Mandaliya

[zabsmarty]

Hello Sejal Mandaliya,
I send you the script that make your work easy....

Reply me hows its worked.


Regards
zabsmarty

<?php
//include db connection file

include 'connection.php';

$query = "SELECT first_name, last_name, preferred_name, nick_name, ethnicity, gender, email, mobile, phone, line_1,line_2, subrub, city,country, graduating_university, year_graduation, level_training, level_training_year, hospital_main, vocational_interest_1 FROM members ";

$result = mysql_query($query) or die('Error, query failed');

$tsv = array();
$html = array();
while($row = mysql_fetch_array($result, MYSQL_NUM))
{
	$tsv[]  = implode("\t", $row);
	$html[] = "<tr><td>" .implode("</td><td>", $row) . "</td></tr>";
}

$tsv  = implode("\r\n", $tsv);
$html = "<table>" . implode("\r\n", $html) . "</table>";

$fileName = date("d-m-Y").'_mysql.xls';
header("Content-type: application/vnd.ms-excel"); 
header("Content-Disposition: attachment; filename=$fileName");

//echo $tsv;
echo $html;

//include 'library/closedb.php';
header('location:thanks.php');
?>

Dear Sir,
Can you tell me how to export data from MySQL database to a xls file using php code?I have to export data from different tables of mysql database to a single xls file.Please help me!!!

Regards,
Sejal Mandaliya

[sejal17]

Thanks,
Thank you very very much.Your code is working properly.But the lines are not enalbed in xls file.Data is displayed properly but the lines are not enabled in xls file.

[zabsmarty]

Thanks to reply, and no problem for thanks, Sejal i does not understand this problem please clarify me so i make to solve this problem for you. reply me soon.

Ragards
zabmsarty

Thanks,
Thank you very very much.Your code is working properly.But the lines are not enalbed in xls file.Data is displayed properly but the lines are not enabled in xls file.

[pbmods]

Heya, Sejal.

Check out the Spreadsheet_Exc el_Writer class.