Is there any way I can execute a PHP script from MySQL?

Question

I want to invoke and execute a PHP script from a MySQL procedure. Is this possible?

CREATE PROCEDURE simpleproc (OUT param1 INT)
    BEGIN
         Call my php script here
    END//

[EDIT]
I am in fact trying to raise an event when a condition is met — for instance when my table field value matches the current time. Then, I want to capture the event and send an email.

No You cant!! Share your exact problem we try to find alternative solutions. — Suresh Kamrushi
– Suresh Kamrushi, Commented Dec 26, 2012 at 11:56
No you can't thou you could retrieve php script from the database and call eval function, but whatever you are doinbg it would be plain wrong — Linas
– Linas, Commented Dec 26, 2012 at 11:58
Try to look at do_system() in databasesecurity.com/mysql/HackproofingMySQL.pdf — Bogdan Burym
– Bogdan Burym, Commented Dec 26, 2012 at 12:02
possible dup of stackoverflow.com/questions/2943205/execute-php-via-mysql?rq=1 — antony.trupe
– antony.trupe, Commented Dec 26, 2012 at 17:02
A cron script is probably better than using a database trigger for this — Mark Baker
– Mark Baker, Commented Dec 28, 2012 at 14:05

Mark Baker · Accepted Answer · 2012-12-26 12:03:50Z

20

It's possible, See the MySQL FAQ for an explanation of how

Can triggers call an external application through a UDF?

But it's likely to be bad design on your part if you have to resort to this

answered Dec 26, 2012 at 12:03

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

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

Comments

daniel__ · Accepted Answer · 2012-12-26 12:22:13Z

12

DELIMITER @@

CREATE TRIGGER Test_Trigger
AFTER INSERT ON MyTable
FOR EACH ROW
BEGIN

DECLARE cmd CHAR(255);
DECLARE result int(10);
SET cmd=CONCAT('/usr/bin/php ', '/home/test/beta/demo.php');
SET result = sys_exec(cmd);

END;
@@
DELIMITER ;

source

answered Dec 26, 2012 at 12:22

daniel__

11.9k16 gold badges67 silver badges91 bronze badges

1 Comment

Bogdan Burym Over a year ago

Dont have time to test.. Does it really work? Did you test? Looks great!

newman · Accepted Answer · 2012-12-26 12:21:25Z

3

For solve your problem you can create table for tasks. From stored procedure you can put to this table any string for task. On server you can run PHP script by crontab. Script will check this table and make some operation.

answered Dec 26, 2012 at 12:21

newman

2,71919 silver badges24 bronze badges

Collectives™ on Stack Overflow

Is there any way I can execute a PHP script from MySQL?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related