I need a PHP script that dumps several tables in a single database to a single zip file and downloads it to my client machine. The tables need to be dumped in this format:
- CSV for MS Excel
- Field names in first row
- Replace NULL with ""
I am currently doing this manually using phpMyAdmin, but it is cumbersome as phpMyAdmin can not save the setup and does only one table at a time.
This should be a single php file with all variables hard coded in the file itself. I need to be able to set the host, user, pwd, db, and tables (multiple tables, so an array).