From PHP to MySQL to ACCESS and back
Posted: Thu Jun 30, 2011 11:43 am
We are buiding a web application that books reservations. An ACCESS database on a local computer cotains the reservation data.
1. When someone tries to register for a room, the PHP application populates the MySQL database.
2. Meanwhile, the ACCESS database "watches" the MySQL table for changes, when there is a reservation, ACCESS returns to the MySQL table a confirmation of availability.
3. Meanwhile, the PHP script is in a loop, checking the MySQL table for an update to the confirmation status. When the status changes or the loop times out, the response is sent to the browser.
If the above description seems like the most idiotic process on earth, then, well, that's why I'm here. What we need is a way to display to the applicant the response from the ACCESS database. Has anyone dealt with a similar situation and found an elegant solution? Any ideas?
1. When someone tries to register for a room, the PHP application populates the MySQL database.
2. Meanwhile, the ACCESS database "watches" the MySQL table for changes, when there is a reservation, ACCESS returns to the MySQL table a confirmation of availability.
3. Meanwhile, the PHP script is in a loop, checking the MySQL table for an update to the confirmation status. When the status changes or the loop times out, the response is sent to the browser.
If the above description seems like the most idiotic process on earth, then, well, that's why I'm here. What we need is a way to display to the applicant the response from the ACCESS database. Has anyone dealt with a similar situation and found an elegant solution? Any ideas?