Trouble calling a php script from mysql trigger

Question

I am using phpmyadmin. I am using a trigger in mysql which calls a php script after inserting something in a table. But i cant create the trigger it shows an error msg..

#1064 sql syntax error

Help me with this... My code inside a trigger

DECLARE result INT;
SET result=select sys_exec('C:/xampp/php/php.exe C:/xampp/htdocs/mysite/hello.php');

Or bundle the PHP with a script that will execute it (e.g. by putting the PHP in the DATA section of a perl script and having the script pipe the data to a PHP interpreter). Although, to clarify, I'm providing that solution simply for variety; nl-x's solution makes more sense. — Parthian Shot
– Parthian Shot, Commented Jun 26, 2014 at 13:43

nl-x · Accepted Answer · 2014-06-26 14:04:12Z

1

You should use something like select (This is why you get the syntax error.)

And you should use some executable what will run that PHP file. (EG PHP.EXE)

Try something like:

DECLARE result INT;    
SET result = (select sys_exec('C:/path/to/PHP.EXE C:/xampp/htdocs/mysite/hello.php'));

edited Jun 26, 2014 at 14:04

answered Jun 26, 2014 at 13:41

nl-x

11.9k7 gold badges36 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user3496195 Over a year ago

may i know what is C:/path/to/PHP.EXE and where i can get this php.exe file.. I am a beginner plz help me... Thanks..

nl-x Over a year ago

@user3496195 Did you try c:\xampp\php\php.exe ? Does that exist on your disk ?

user3496195 Over a year ago

yes php.exe is exists... but after altering my code as you suggest i got the same error... is there any other error in my code.. editted my code in my question too...

nl-x Over a year ago

@user3496195 I think it is missing extra parens () . I have edited my answer

user3496195 Over a year ago

now the trigger was created but i cant insert any thing to the table it shows error as #1305 - FUNCTION db2.sys_exec does not exist

|

Collectives™ on Stack Overflow

Trouble calling a php script from mysql trigger

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related