如何将ajax放入确认按钮？

Hi friends i am trying to put ajax url in confirm button to update something in Database.

So i do this in JavaScript Section

function freeze_account() {
    $.confirm({
        title: 'Confirm!',
        content: 'This dialog will automatically trigger \'cancel\' in 6 seconds if you don\'t respond.',
        type: 'red',
        typeAnimated: true,
        boxWidth: '30%',
        useBootstrap: false,
        buttons: {
            confirm: function() {
                var manager_id = $('#manager_id').val();
                $.ajax({
                    url: "update_freeze.php",
                    type: "POST",
                    data: {
                        'manager_id': manager_id
                    },
                    success: function() {
                        location.reload();
                    }
                });
            },
            cancel: function() {}
        }
    });
}

and this is code for update

$manager_id = $_POST['manager_id'];
$state = '0';
$update=runQuery("UPDATE `users` SET `userStatus` =:userS WHERE `userID`=:user_id");
$update->bindparam(":userS",$state);
$update->bindparam(":user_id",$manager_id);
            $update->execute();

My problem is when i press confirm button ajax works and go to another page but nothing happen in database. What is wrong in my code Or Maybe I miss something?

any help any idea i will be grateful

Best Regards

look how i solved my problem Maybe one benefit of my code Thanks for every one suggestions or helping me

function freeze_account() {


            var pid = $('#manager_id').val();


            bootbox.dialog({
              message: "Are you sure you want to Freeze this account ?",
              title: "<i class='glyphicon glyphicon-trash'></i> Freeze !",
              buttons: {
                success: {
                  label: "No",
                  className: "btn-success",
                  callback: function() {
                     $('.bootbox').modal('hide');
                  }
                },
                danger: {
                  label: "Freeze!",
                  className: "btn-danger",
                  callback: function() {




                      $.post('update_freeze.php', { 'pid':pid })
                      .done(function(response){
                          bootbox.alert(response);

                          location.reload();
                      })
                      .fail(function(){
                          bootbox.alert('Something Went Wrog ....');
                      })

                  }
                }
              }
            });


}

You need to set up an event listener on your button. Firstly, ensure you have an ID on your button so we can grab it.

Now, we create the event listener:

$("#button").on("click", freeze_account());

And, now when you click the button the ajax call should go through successfully.

However, it will still redirect yo due to its default behaviour.

To override this, simply prevent the default event:

function freeze_account(event) {

    event.preventDefault(); // stops the button redirecting

    $.confirm({
        title: 'Confirm!',
        content: 'This dialog will automatically trigger \'cancel\' in 6 seconds if you don\'t respond.',
        type: 'red',
        typeAnimated: true,
        boxWidth: '30%',
        useBootstrap: false,
        buttons: {
            confirm: function() {
                var manager_id = $('#manager_id').val();
                $.ajax({
                    url: "update_freeze.php",
                    type: "POST",
                    data: {
                        'manager_id': manager_id
                    },
                    success: function() {
                        location.reload();
                    }
                });
            },
            cancel: function() {}
        }
    });
}