this is working but I also want the coloum header with the data can any one tell me the code that how can i export data with coloum name from mysql to .csv format

thanks guys,…

hi, i would like to know how to include the column names into the csv file

@ Hilton Becker:

write the full path in the file field

@ Max:
Hello,

I would like to know how to change the location (path) where the file is saved. Is this possible? If so what do i need to do.

many thanks in advance
Hilton

Hi all, my script is running, thanks for the ideas. But I need to rewrite the file with the same name each time. How can I do that? Thanks!

In linux the place where this file is /var/lib/mysql/database_name/file.csv

Hi! Sean asked this by email as well and the problem is that the correct “dump” method name is

$mid_excel->WriteSQLDump($query, ‘ceementor’, ‘mentoruser’, ‘*******’, ‘mydbs1.ce.gatech.edu’);

That will do the trick. Sorry about the confusion.

Regards,
Iván

I can’t seem to get Ivan’s IAM_XLS to work. When I modify the example.php file and access it via my website I get the following:

Fatal error: Call to undefined method IAM_XLS::dump() in /export/home3/www/mentor/admin/example.php on line 8

Yes I do have the iam_xls.php file in the same directory and have modified it to use my db settings, userid, password etc…

Here is what my example.php file looks like:

dump($query, ‘ceementor’, ‘mentoruser’, ‘********’, ‘mydbs1.ce.gatech.edu’);
?>

If anyone could help it would be greatly appreciated!

Thanks,

[quote comment=”6382″]Hi! I had the same problem and I developed 2 PHP classes to solve the problem.
One is IAM_XLS, which exports data in Excel’s BIFF format. The class supports only text, integer and float value types but it’s kind of handy when all you need to do is dump a query result. It also has a “dump” function that does just that for you.

The other, named IAM_CSVDump, does the same as your SQL statement but adds a couple of features that make downloading the file a nicer experience.

Kind regards,
Iván[/quote]

Perfect. Note the default location the file is saved in windows is, eg:
C:\Program Files\MySQL\MySQL Server 5.0\data\myDatabaseName