|
|
Posted by NC on 12/28/07 17:41
On Dec 28, 2:15 am, anu <anunanni2...@gmail.com> wrote:
>
> How to convert MYSQL data result to csv file format.
The high-performance solution is to run a SELECT INTO OUTFILE query:
http://dev.mysql.com/doc/refman/4.1/en/select.html
The drawback of this approach is that the CSV file can only be created
on the machine where MySQL server is running, which may or may not be
feasible in your particular case.
The alternative is to simply dump the data into a file:
// Assume that the DB connection has already been established...
$result = mysql_query('SELECT * FROM myTable');
$fp = fopen('data.csv', 'w');
if ($fp == false) {
die("Could not open data.csv for writing");
}
while ($record = mysql_fetch_row($result)) {
fputcsv($fp, $record);
}
fclose($fp);
Note that fputcsv() is available only since PHP 5.1, so you may have
to write your own CSV formatter if you have an earlier version of
PHP...
Cheers,
NC
Navigation:
[Reply to this message]
|