I would like a PHP script that will take a mysql query and run it across a group of databases.
First Input to the script would be a file with the mysql details: host, dbname, user, pass.
Second input to the script would be the query to run. Such as delete from tblTempLog .
The script would process the query on each mysql db in the input file. Result of the query would be shown on screen durning the process and emailed as a result at the end of processing.
The script should work whether or not the browser is closed or not. In other words, I should be able to fire off the process and have it run through after I close the browser.
The script should log any connection / mysql errors and continue running on the additional databases.
Please include the code 777 in your bid to prevent autobidding.
PM me if you have any questions.
Thanks!