Exporting MYSQL data into Excel/CSV via php

Question

i want to Export MYSQL data into Excel/CSV via php. so that i can use my database later or someone can use and understand it.

Answer 1

To create a .CSV file with syntax suitable for EXCEL you can use basic SQL:

SELECT * FROM mytable
INTO OUTFILE '/mytable.csv'
FIELDS ESCAPED BY '""'
TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';

See the manual here.