Using jquery / javascript to create a popup confirm box

Question

Here is the extract code of how to make a confim box when delete,

For html part: A link is to trigger JS code , but it will trigger the php code at same time

For JS part: popupbox is triggered

For php part: Process the sql query, it should be ok

The problem are:

I should use js to trigger the php page?But how can i let the php page know that which ListID i want to delete?
What should i put in the html link?

Thank you

html

<a id="delete" href='delete.php?id=$set[ListID]'>Delete</a>

Js

$(function(){
  $("#delete").click(function() {
    $.messager.alert('Warning','The warning message');  
    $.messager.confirm('Confirm','Are you sure you want to delete record?',function(r){  
        if (r){  
            alert('ok');  
        }  
    });  
 });
});

php

//connection db
INSERT  INTO delete_list SELECT * FROM list WHERE ListID=?;    
INSERT  INTO delete_user_list SELECT * FROM user_list WHERE ListID=?;    
INSERT  INTO delete_require_attributes SELECT * FROM require_attributes WHERE ListID='2';    
INSERT  INTO delete_subscriber SELECT * FROM subscriber WHERE ListID=?;    
INSERT  INTO delete_subscriber SELECT * FROM subscriber WHERE ListID=?;    
DELETE FROM list WHERE ListID = '1'

What if i want to include the list name in the popup box e.g. do you want to delete list A ,where list A is a variable already. The only thing is how can i append it to the popup box

"<tr><td>".$set['ListName']."</td><td>"

Fabrizio Calderan · Accepted Answer · 2012-03-20 14:02:30Z

1

I don't know what $.messager does, but I suppose this should work

$(function(){
  $("#delete").click(function(evt) {
    evt.preventDefault();
    var urlscript = this.href;  /* read link url (e.g. delete.php?id=314159) */

    $.messager.alert('Warning','The warning message');  
    $.messager.confirm('Confirm','Are you sure you want to delete record?',function(r){  
        if (r) {                  
           $.ajax(urlscript); /* make ajax call to that url with the right id */    
        }  
    });  
 });
});

and I supposing that your source code is actually showing smthg like

<a id="delete" href='delete.php?id=314159'>Delete</a>

so on the ajax call you're sending that id.

edited Mar 20, 2012 at 14:02

answered Mar 20, 2012 at 13:55

Fabrizio Calderan

124k26 gold badges172 silver badges183 bronze badges

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

1 Comment

Leo Chan Over a year ago

Thank you , since the php code is delete based on a ID e.g. delete.php?id=$set[ListID] , how can i post it to the php if i am using js? Thanks

Alytrem · Accepted Answer · 2012-03-20 13:55:38Z

0

Try this:

if (confirm("Question?")) {
     // IF OK CLICKED
     $.get('delete.php?id=MyID', function(data) {
         alert('List DELETED');
    });
}

answered Mar 20, 2012 at 13:55

Alytrem

2,6101 gold badge14 silver badges13 bronze badges

1 Comment

Leo Chan Over a year ago

What if i want to include the list name in the popup box e.g. do you want to delete list A ,where list A is a variable already.

ThiefMaster · Accepted Answer · 2012-03-20 13:55:59Z

0

$("#delete").click(function(e) {
    e.preventDefault();
    var url = this.href;
    $.messager.confirm('Confirm','Are you sure you want to delete record?',function(r){  
        if (r){  
            location.href = url;
        }  
    });

answered Mar 20, 2012 at 13:55

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

Comments

Shyju · Accepted Answer · 2012-03-20 13:56:00Z

0

Let the link trigger the javascript code to show the popup window for delete confirmation. at the same time, you can update value of a hidden field in your page with the selected item id. When you user confirms the deleting by clicking on the "Yes" button in the confirm box. Read the value of the hidden input and then post that to the server (php) page to do the actual deletion from the database.

answered Mar 20, 2012 at 13:56

Shyju

220k106 gold badges421 silver badges499 bronze badges

Comments

Manatok · Accepted Answer · 2012-03-20 14:00:37Z

0

I wouldnt send the ID as a GET, else people can increment the value and delete your records?

<a class="delete" id="someId" >Delete</a>

$('.delete').click(function() {
  var id = $(this).attr('id');

  $.messager.alert('Warning','The warning message');  
  $.messager.confirm('Confirm','Are you sure you want to delete record?',function(r){  

   if (r) {       
      $.post('delete.php', {id:id}, function(response) {
         //check the status of the reponse
      });  
   });
});

answered Mar 20, 2012 at 14:00

Manatok

5,7263 gold badges26 silver badges32 bronze badges

1 Comment

Leo Chan Over a year ago

Sorry but a link is not pressable?

Collectives™ on Stack Overflow

Using jquery / javascript to create a popup confirm box

5 Answers 5

1 Comment

1 Comment

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related