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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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