RE: [PHP-DB] running program after insert w/MySQL 4.1
If you can make Access execute a shell function, maybe you can use cURL or wget to signal a web PHP script to run (and/or run the PHP program -- if it is not accessible through a URL). Regards, Dwight -Original Message- From: bill [mailto:[EMAIL PROTECTED] Sent: Friday, July 07, 2006 2:11 PM To: php-db@lists.php.net Subject: [PHP-DB] running program after insert w/MySQL 4.1 I have an Access database connecting via ODBC to a local MySQL machine and doing inserts. It does these inserts throughout the day. After each insert, I need a PHP program run. Alas, MySQL 4.1 doesn't do triggers, etc., and upgrading to 5.x looks non-trivial. What else can I do? Is there any way to trigger something via the ODBC connection? A cron job? I'm open to suggestions. kind regards, bill -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] running program after insert w/MySQL 4.1
cron or Windows Task Manager would work if you want to check the status of the data periodically, but I believe you can also use Access to hit a web address (it doesn't have to display anything) so you could, at time of insert, have Access activate a PHP script on your web server that does the database check. You could probably get the last inserted ID number as well and pass that to the PHP script if you want to check specific records right after they're inserted. -TG = = = Original message = = = I have an Access database connecting via ODBC to a local MySQL machine and doing inserts. It does these inserts throughout the day. After each insert, I need a PHP program run. Alas, MySQL 4.1 doesn't do triggers, etc., and upgrading to 5.x looks non-trivial. What else can I do? Is there any way to trigger something via the ODBC connection? A cron job? I'm open to suggestions. kind regards, bill ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] running program after insert w/MySQL 4.1
You should be able to open a web page from access (might need to write a module) and call a page that would then run your script Bastien From: bill [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] running program after insert w/MySQL 4.1 Date: Fri, 07 Jul 2006 15:11:07 -0400 I have an Access database connecting via ODBC to a local MySQL machine and doing inserts. It does these inserts throughout the day. After each insert, I need a PHP program run. Alas, MySQL 4.1 doesn't do triggers, etc., and upgrading to 5.x looks non-trivial. What else can I do? Is there any way to trigger something via the ODBC connection? A cron job? I'm open to suggestions. kind regards, bill -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] running program after insert w/MySQL 4.1
Access is the backend for a proprietary front end. I just checked with the company and they can't understand why anybody would want to change the program(!). In any case, they won't allow it. So, I'm stuck with the ODBC call from the Win computer sending data to the mysql db on the linux computer. How can I get a web page called after the ODBC call? Am I stuck with a cron job on the linux box? Bastien Koert wrote: You should be able to open a web page from access (might need to write a module) and call a page that would then run your script Bastien From: bill [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] running program after insert w/MySQL 4.1 Date: Fri, 07 Jul 2006 15:11:07 -0400 I have an Access database connecting via ODBC to a local MySQL machine and doing inserts. It does these inserts throughout the day. After each insert, I need a PHP program run. Alas, MySQL 4.1 doesn't do triggers, etc., and upgrading to 5.x looks non-trivial. What else can I do? Is there any way to trigger something via the ODBC connection? A cron job? I'm open to suggestions. kind regards, bill -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php