Confirm Box in PHP?

Question

I'm developing a web application and I want to get the answer(yes or no) from user when the deactivate button is pressed. I want to ask him if you want or not to deactivate the account. I'm using PHP to set active status to = 1 when deactivated and 0 to activated.

I want to get the result and verify in PHP if the query runs or not.

I would appreciate if someone helps me, thanks. Here is the code:

 if(isset($_POST['desativar']))
{

  $login = $_SESSION['login'];


   mysqli_query($conexao,"UPDATE usuarios SET ativo_usuario = 1 WHERE login_usuario='$login'");

}

[Little Bobby](http://bobby-tables.com/) says [your script is at risk for SQL Injection Attacks.](http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php) Learn about [prepared](http://en.wikipedia.org/wiki/Prepared_statement) statements for [MySQLi](http://php.net/manual/en/mysqli.quickstart.prepared-statements.php). Even [escaping the string](http://stackoverflow.com/questions/5741187/sql-injection-that-gets-around-mysql-real-escape-string) is not safe! — Jay Blanchard, Jun 06 '16 at 14:10

Alexis · Answer 1 · 2023-02-13T10:01:35.093

2

You can use onsubmit attribute.

Example

function confirmDesactiv()
{
   return confirm("Are you sure ?")
}

<form method="POST" action="yourphp.php" onsubmit="return confirmDesactiv()">
    <button type="submit">Delete my account</button>
</form>

edited Feb 13 '23 at 10:01

answered Jun 06 '16 at 14:06

Alexis

5,681
1
27
44

kiran gadhvi · Answer 2 · 2016-06-07T06:07:58.300

0

**JS**

    <script type="text/javascript">
    function confirmDesactiv()
    {
       var flag = confirm("Are you sure ?");
       if(flag)
            window.open("yourphp.php?id=" + 1);
        else
            window.open("yourphp.php?id=" + 0);
    }

</script>
**HTML**    



    <form method="POST" action="">
    <button type="submit" onclick="confirmDesactiv()">Desactiv my account</button>
    </form>



**PHP**   

<?php
echo $_GET['id'];
if(isset($_GET['id']) && $_GET['id'])
{
    //your update query will come here
}
?>

edited Jun 07 '16 at 06:07

answered Jun 06 '16 at 13:58

kiran gadhvi

228
2
16

How can I get the result to PHP runs the query or not? Thanks. – VitorTech Jun 06 '16 at 14:03
2

Why should the OP try this? A ***good answer*** will always have an explanation of what was done and why it was done in such a manner, not only for the OP but for future visitors to SO. – Jay Blanchard Jun 06 '16 at 14:10

score 0 · Answer 3 · answered Jun 06 '16 at 14:02

0

try it.

function confirm_delete(){
    if(confirm("Are you sure you want to delete this..?") === true){
        return true;
    }else{
        return false;
   }
 }

 <input type="button" Onclick="confirm_delete()">

answered Jun 06 '16 at 14:02

Keyur Chavda-kc1994

1,045
1
13
28

2

Why should the OP "try this"? A ***good answer*** will always have an explanation of what was done and why it was done in such a manner, not only for the OP but for future visitors to SO. – Jay Blanchard Jun 06 '16 at 14:10
How can I get true of false to use in PHP? – VitorTech Jun 06 '16 at 14:12

score 0 · Answer 4 · answered Jun 06 '16 at 14:14

You can use PHP to make something like a confirmation box. Below is a little smaple code to show you how:

<?php
session_start();

if (isset($_POST['submit'])) {
    $_SESSION['postdata'] = $_POST;
    header("Location: ".$_SERVER['PHP_SELF']);
    exit;
} else if (isset($_POST['confirm']) && $_POST['confirm'] == 'yes') {
    // Do stuff that should only be done after confirming
} elseif (isset($_POST['confirm']) && $_POST['confirm'] == 'no') {
    // Cancelled, redirect back to page
    header("Location: ".$_SERVER['PHP_SELF']);
    exit;
}
?>

<?php if (isset($_SESSION['postdata']) && !isset($_POST['confirm'])): ?>
    <form method="POST" action="<?= $_SERVER['PHP_SELF']; ?>">
        Are you sure you want to do this?<br />
        <input type="submit" name="confirm" value="yes">
        <input type="submit" name="confirm" value="no">
    </form>
<?php else: ?>
    <!-- Your form here -->
<?php endif; ?>

score 0 · Answer 5 · answered Jun 06 '16 at 14:29

If you don't want to use AJAX, and assuming your page is called index.php:

<?
   $deactivateStatusDisplay = "display: none"; // Initially, do not display a status.
   $deactivateStatusMsg = ""; //Status message is initialized as blank.
   $queryRan = false; // Just a flag to know if the user clicked deactivation link.

   if( 1 === $_GET['deactivate'] ){
      $deactivateStatusDisplay = "display: block";
      $deactivateStatusMsg = "Your account will be deactivated.";
      $queryRan = true;
   }
?>

<!DOCTYPE html >
<html>
     <head>
       <!-- ALL YOUR METADATA -->
     </head>
     <body>
         <div>Do you want to deactivate your account?</div>
         <a href="index.php?deactivate=1">DEACTIVATE</a>
         <div id="status" style="<? echo $deactivateStatusDisplay ?>"><? echo $deactivateStatusMsg ?></div>
     </body>
</html>

Confirm Box in PHP?

5 Answers5