Greetings,
I'd like for you to create the following tool:
A php script that loops through the contents of a subdirectory and reads each file and executes the SQL query contained within the file, with the resulting recordset from the query exported as an xls file and emailed.
Basically I have about 4-5 monthly reports that I run and I'd like to receive and email for each. I'll provide the sql.
Your deliverable:
A php script that when called loops through a subdirectory called "sql" and does an export and email for each sql file atttached using the name of the sql file for the attachment name and email subject. For example, if there are 3 text files within the sql folder named report1 report2 and report3 - there would be three emails sent - one with a csv file named [login to view URL], another email with a csv file named [login to view URL], and a third email with a csv file named [login to view URL]
The export could be csv or xls. Please include the text phpxls06052013 as the first word on the first line of your response for consideration.
php version is 5.3.3
mysql version is 5.0.95
mailer is sendmail
Potential File Structure
/
[login to view URL]
--/sql/
[login to view URL]
[login to view URL]
[login to view URL]
I am expecting this project to require less than 4 hours to complete.
Thanks and good luck bidding!