i wish to Export MYSQL data into Stand out/CSV via php. to ensure that i'm able to use my database later or someone may use and comprehend it.
To produce a .CSV file with syntax appropriate for Stand out you should use fundamental SQL:
SELECT * FROM mytable INTO OUTFILE '/mytable.csv' FIELDS ESCAPED BY '""' TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
Begin to see the manual here.
Try the fputcsv function. Even the MySql CE (5.2) Work bench is a great tool for conveying the information and becoming an image from the database like a diagram.
I believe this is exactly what you're searching for
You may create your personal file by checking this address: http://www.programmingfacts.com/export-mysql-data-into-excelcsv-via-php/
I can not add working code in here sth is wrong =/
but make all t to t and all sorts of n to n