export mysql database to excel by php

Question

Hi I want to export my database to an excel file by php,I need a source code in php to do this

Answer 1

The following exports the table as a .CSV file (comma seperated values) which can be easily imported in Excel.

$out = '';
$fields = mysql_list_fields('database','table',$db);
$columns = mysql_num_fields($fields);

// Put the name of all fields
for ($i = 0; $i < $columns; $i++) {
     $l=mysql_field_name($fields, $i);
     $out .= '"'.$l.'",';
}
$out .="\n";

// Add all values in the table
while ($l = mysql_fetch_array($rsSearchResults)) {
     for ($i = 0; $i < $columns; $i++) {
          $out .='"'.$l["$i"].'",';
     }
     $out .="\n";
}
echo $out;

Answer 2

This might be of some help. MySql To Excel. If you just need the sourcode why don't you just google it?

Answer 3

I'm not going to write your whole program for you (that's not what this site is about) but if you have a specific problem, feel free to post another question.

It looks like PHP has a built-in function to export an array to a line in a CSV file: fputcsv. So run your query and for each row returned, call fputcsv.

Or, just use mysqldump which claims to support dumping to natively support dumping a database to CSV.

Answer 4

PLEASE NOTE!

Exporting Records to .csv is not the same as exporting records to MX Excel .csv.

First and foremost, the source code is out there. Not problem finding it.

The difference though is with Excel, with you are separating with commas and encapsulating with ", Excel escapes quotes (") with an additional quote (so it looks like "").

This means you can't simply use addslashes when trying to export.