How can i run script as soon as mysql database is update (cronjob)

Question

How can i run a script as soon as mysql database is updated. I have a script in test.php, and i want to run every time, i get sms into (or entry u can say) my database example if massage is received at 10:20:56 sec script should run at 10:20:57 sec.. any thing will do like cronjob java php .any script

Checkout [MySQL Triggers](http://dev.mysql.com/doc/refman/5.0/en/triggers.html) — Aaron W., May 14 '12 at 10:45

score 1 · Answer 1 · edited May 23 '17 at 11:48

1

You could try to create ON UPDATE trigger and try to invoke PHP script. Here is more about that.

edited May 23 '17 at 11:48

Community

1
1

answered May 14 '12 at 10:46

Alex Stybaev

4,623
3
30
44

score 0 · Answer 2 · answered May 14 '12 at 10:44

Take a look at triggers in conjunction with your mysql database. With that you can run a sql-query on every update, insert or modification.

Simplified Syntax:

CREATE
    TRIGGER trigger_name trigger_time trigger_event
    ON tbl_name FOR EACH ROW trigger_body

score 0 · Answer 3 · answered May 14 '12 at 10:47

0

If value is inserted via your code you can just add call of script just after insert. If it is inserted in code, that is not managed by you, than you should poll your database every N seconds and check for new records and call your php script.

answered May 14 '12 at 10:47

dbf

6,399
2
38
65

database is updated my sms so i dont have control in incoming sms – Harinder May 14 '12 at 11:07

How can i run script as soon as mysql database is update (cronjob)

3 Answers3