How do you create CSV files with PHP/MySQL

[DeepakJ]

I essentially want to save my entire database onto a CSV file. Can someone explain the process in detail? Thanks

[hitman6003]

What is a CRV file?

 

If you want to backup your database, use mysqldump

 

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

 

Using a web based solution will be very limited in total dump size.  If you want an example/solution, use phpMyAdmin.

[DeepakJ]

oops comma seperated values. I want to do this inorder to be able to print out a spreadsheet with the data in it.

[hitman6003]

I think you mean CSV...comma seperated values

 

http://dev.mysql.com/doc/refman/4.1/en/select.html#id3341530

 

which yeilds....

 

SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM test_table;

[DeepakJ]

Hmm I don't get how you make a csv file like that? What would like a sample script look like? Can you link me to one?

[DeepakJ]

help please

[Vizor]

PHP has an fputcsv() function, not sure if it's part of the standard package though.