RE: [PHP-DB] running program after insert w/MySQL 4.1
| From: | Dwight Altman | Date: | Fri, 07 Jul 2006 19:42:31 +0000 |
| Subject: | RE: [PHP-DB] running program after insert w/MySQL 4.1 | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42191@lists.php.net to get a copy of this message | ||
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:bill@billtron.com]
> 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
>
> --