PHP Driver: If I KIll a PHP process will it also kill SQL Server Process (query)?

Question

Hello all,

I am using PHP SQL Server driver - is there a way to kill the last query sent by sqlsrv_query function?

If not, if I kill the PHP process will it also kill the query in turn?

I appreciate any help.

Answer 1

Yes you can do this.

Take a look at MySQL's kill command, that should help you with what query to use.

When do you want to invoke it? If its inline with your PHP, then just write up a query and execute it. If you want to do it if the page is closed, you may want to consider setting up a second PHP page that runs the command, and then hitting it with AJAX with JavaScript's event for closing pages.

Comment if you have any questions