Confirm button before running deleting routine from website

Question

I have a page on my website that is dynamically created with information from an SQL database  As well as the data being displayed a delete link is also created for each record which links to a php file called deleteRecord php that deletes that record from the database     Is there any way I can incorporate a confirmation message so that when the Delete link is clicked it will only run the deleteRecord php file if the response is Yes

User · Answer

You have 2 options  1  Use javascript to confirm deletion  use onsubmit event handler   however if the client has JS disabled  you re in trouble   2  Use PHP to echo out a confirmation message  along with the contents of the form  hidden if you like  as well as a submit button called  confirmation   in PHP check if   POST  confirmation   is set

User · Answer

Call this function onclick of button    pass whatever you want instead of id    function doConfirm id        var ok   confirm  Are you sure to Delete         if  ok            if  window XMLHttpRequest                   code for IE7   Firefox  Chrome  Opera  Safari             xmlhttp   new XMLHttpRequest              else                  code for IE6  IE5             xmlhttp   new ActiveXObject  Microsoft XMLHTTP                       xmlhttp onreadystatechange   function                 if  xmlhttp readyState    4  amp  amp  xmlhttp status    200                    window location    create dealer php                                    xmlhttp open  GET    delete dealer php id     id              file name where delete code is written         xmlhttp send

User · Answer

Try this one      lt script type  text javascript  gt        var baseUrl  http   example com         function ConfirmDelete                       if  confirm  Delete Account                      location href baseUrl   deleteRecord php              lt  script gt      echo   lt a type  button  onclick  ConfirmDelete    gt DELETE ACCOUNT lt  a gt

User · Answer

You can do it with an confirm   message using Javascript

User · Answer

You could use JavaScript  Either put the code inline  into a function or use jQuery    Inline    lt a href  deletelink  onclick  return confirm  Are you sure     gt Delete lt  a gt   In a function    lt a href  deletelink  onclick  return checkDelete    gt Delete lt  a gt    and then put this in  lt head gt     lt script language  JavaScript  type  text javascript  gt  function checkDelete        return confirm  Are you sure        lt  script gt    This one has more work  but less file size if the list is long  With jQuery    lt a href  deletelink  class  delete  gt Delete lt  a gt    And put this in  lt head gt     lt script src  http   code jquery com jquery-1 11 1 min js  gt  lt  script gt   lt script language  JavaScript  type  text javascript  gt    document  ready function           a delete   click function e           if  confirm  Are you sure                  e preventDefault                return false                    return true               lt  script gt

User · Answer

x000D   x000D   lt  php  x000D   con   mysqli connect  localhost   root   root   EmpDB   or die mysqli error  con    x000D   if isset   POST add    x000D     x000D    sno   mysqli real escape string  con   POST sno    x000D      name   mysqli real escape string  con   POST sname    x000D      course   mysqli real escape string  con   POST course    x000D    x000D      query    insert into students sno name course  values  sno   name    course     x000D       echo  query  x000D      result   mysqli query  con  query   x000D     printf   New Record has id  d  n   mysqli insert id  con    x000D    mysqli close  con   x000D      x000D       x000D    gt  x000D     x000D   lt html gt  x000D   lt head gt  x000D   lt title gt mysql insert id Example lt  title gt  x000D   lt  head gt  x000D   lt body gt  x000D   lt form action    method  POST  gt  x000D  Enter S NO   lt input type  text  name  sno   gt  lt br  gt  x000D  Enter Student Name   lt input type  text  name  sname   gt  lt br  gt  x000D  Enter Course   lt input type  text  name  course   gt  lt br  gt  x000D   lt input type  submit  name  add  value  Add Student   gt  x000D   lt  form gt  x000D   lt  body gt  x000D   lt  html gt  x000D   x000D   x000D

[php] Confirm button before running deleting routine from website

Examples related to php

Examples related to html