Can triggers call PHP Scripts?

Question

I have written a trigger, but mysql doesn't like it:

Code :

create trigger triggers_on_comand_line AFTER UPDATE on test1 
for each row 
begin 
IF total_volume >= used_volume
THEN
\! echo "php -f /home/test.php" 
END;

I got this error :

** MySQL said: Documentation 1064 - 064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '! echo "php -f /home/test.php" at line 6 **

Thanks

I don't like it too. :) And I don't like your question, because you provide little information. :) What do you mean by "doesn't like"? Do not run? Throw an exception? Just silently do nothing? — J0HN, Oct 05 '11 at 08:31
i Provided the Error message i executedmy trigger in phpMyAdmin — Rjaibi Mejdi, Oct 05 '11 at 08:33
Hm, wait. Per UDF maybe.. take a look at [Invoking a PHP script from a mysql trigger](http://stackoverflow.com/q/1467369/693207) — Jürgen Thelen, Oct 05 '11 at 08:35

score 1 · Answer 1 · answered Oct 05 '11 at 08:30

1

You are writing in MYSQL language, and execute in query language, but the line "system php -f /home/test.php" is written in PHP language.

answered Oct 05 '11 at 08:30

cat

327
1
5
14

I want to execute php script inside my trigger any solution plz – Rjaibi Mejdi Oct 05 '11 at 08:31

score 1 · Accepted Answer · answered Oct 05 '11 at 08:32

1

Yes, you can call php scripts if you install mysql_udf_sys

answered Oct 05 '11 at 08:32

N.B.

13,116
3
42
52

score 0 · Answer 3 · answered Oct 05 '11 at 08:33

0

Tx to this post 1, use :

\! echo "php -f /home/test.php"

answered Oct 05 '11 at 08:33

Guilhem Hoffmann

944
5
13

Can triggers call PHP Scripts?

3 Answers3