How to execute a MySQL Stored Procedure asynchronously in PHP

Question

I would like to execute a stored procedure, and return immediately back to the script, and the SP shall run in the background until complete, and should not be killed by the PHP process.

How can this be done in PHP?

score 4 · Accepted Answer · answered Feb 28 '11 at 08:28

4

I believe you can make it work by using mysql events. I haven't tried personally, but it seems like what you are looking for.

answered Feb 28 '11 at 08:28

a1ex07

36,826
12
90
103

score 2 · Answer 2 · edited May 23 '17 at 11:51

2

You could trigger the execution of a separate PHP script that would run asynchronously (and execute the stored procedure~)

Asynchronous PHP

edited May 23 '17 at 11:51

Community

1
1

answered Feb 28 '11 at 08:18

Shad

15,134
2
22
34

I don't know if this is true or not, but is it considered poor practice to run the shell and execute commands directly? Honest question. – rockerest Feb 28 '11 at 08:22
2

I say, if it's something you can't do in PHP directly, why not? (my take) – Shad Feb 28 '11 at 08:25

How to execute a MySQL Stored Procedure asynchronously in PHP

2 Answers2