Just looking for a second, third, fourth... oppinions on the possibility of:
I have a central Offsite MySQL server which serves an IntrAnet application to several seperate store locations (all over secure links using ip filtering)
Each "store" also has a seperate standalone PHP/Apache server in order to integrate with that sites specific backend systems (via ODBC).
I basically want to be able to login to my central server, and request dynamic reports from each store. Sometimes it will be the same report from all stores, sometimes differant reports from each store.
I can write a shell PHP script to run nightly on each stores PHP/apache server which will then connect to the central server and look for pending requests in a database.
My Question is how do I get the necessary PHP code from the CENTRAL SERVER to the individual stores. Do I store this PHP code in MySQL, and when the store asks for it each night transmit it to the store and save it as a FILE, or is there some nifty trick to run the PHP code from a Variabble ($myCode=mysql_fetch....).
I would like to be able to do this without having to manually upload new PHP files to each store, rather having the files (or prefabbly just the code) storeed in a database and sent to each store upon request.
These report templates just issue ODBC query's on each store's backend system and return the information to the CENTRAL MySQL server.
