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
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
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
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
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