mysql trigger with php script

Question

I have the next mysql trigger:

DELIMITER @@

CREATE TRIGGER Test_Insert
BEFORE INSERT ON sat_clientLocation
FOR EACH ROW 
BEGIN
DECLARE cmd CHAR(255);
DECLARE result int(10);
SET cmd=CONCAT('/usr/bin/php ', '/var/www/html/poi/insertTest.php' , NEW.idLocation);
SET result = sys_exec(cmd);

END;
@@
DELIMITER ;

It's possible to use NEW.idLocation in my php file? I try some methods, but don't work.

$sql ="SELECT txPostCode, id FROM users WHERE id=(SELECT idClient FROM sat_clientLocation where idLocation= NEW.idLocation)"; — Isabella Popa
– Isabella Popa, Commented Mar 14, 2018 at 12:37
It is not correct, i put idLocation= NEW.idLocation because there i want to use NEW.idLocation — Isabella Popa
– Isabella Popa, Commented Mar 14, 2018 at 12:37
What do you mean with "to use NEW.idLocation in my php file"? Could you add the PHP code you already have? — simon
– simon, Commented Mar 14, 2018 at 12:41
"I try some methods, but don't work." what doesnt work? Because sys_exec isn't a MySQL's out off the box function i believe there is a plugin for it.. You might need to use /usr/bin/php -f instead -f option stands for file execution. — Raymond Nijland
– Raymond Nijland, Commented Mar 14, 2018 at 14:05

davidbaumann · Accepted Answer · 2018-03-14 12:43:30Z

0

According to that solution:

SET cmd=CONCAT('/usr/bin/php ', 
               '/var/www/html/poi/insertTest.php?location=' ,
               NEW.idLocation);

That will be passed to your script as $_GET[] variable:

<?php
echo $_GET['location'];
?>

edited Mar 14, 2018 at 12:43

answered Mar 14, 2018 at 12:39

davidbaumann

2182 silver badges14 bronze badges

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

1 Comment

Isabella Popa Over a year ago

The php file is not seen by php exec. Why?

Collectives™ on Stack Overflow

mysql trigger with php script

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related