Yii2 abort request and sql query

Question

After page fully loaded, i make ajax request to an action.

While waiting for response from action (it takes 2 or 3 seconds), if user clicks on other link, i want to abort previous request and kill mysql process at once.

How can i do this?

I tried to do like this

var xhr = $.ajax({
/*
params
*/
});

//before unload page 
xhr.abort();

but i think, that it will not kill sql process.

score 0 · Answer 1 · answered Sep 04 '17 at 07:37

0

Make a named ajax. Here is ajx is named

var formData = {};//Your data for post
var ajx = $.ajax({
    type: "POST",// Http verbs
    url: "filename.php",// file to request
    data: formData,
    success: function(response){
        console.log("ajax completed");
        console.log(response);
    }
});

Stop ajax request by clicking button

$( "#button_id" ).click(function() {
    ajx.abort();
});

answered Sep 04 '17 at 07:37

Niklesh Raut

34,013
16
75
109

It stops an ajax request, but mysql query continues to execute. Mysql query not aborting on ajx.abort() – Ruslan Nasrutdinov Sep 04 '17 at 07:54
to stop your mysql process you need to make another ajax to make this command from server side : https://stackoverflow.com/a/9938302/2815635 – Niklesh Raut Sep 04 '17 at 08:26
Good idea, but i cant send another request, untill the previous one is finished. – Ruslan Nasrutdinov Sep 08 '17 at 11:55

Yii2 abort request and sql query

1 Answers1