Confirm before delete

This site is best viewed in a modern browser with JavaScript enabled.

tqmd1

Dear Sir, I have folloiwng codes

if(isset($_POST['delete']))
	{
		// Get values from form 
		$sno = $_POST['txtsno'];
		$pro = $_POST['txtpro'];
		$wet = $_POST['txtwet'];

$query = "delete from test WHERE sno={$sno}" ;
$result = mysqli_query($con, $query);

if(!$result){
echo "<script>alert('Record not deleted')</script>";
}else{
echo ("<script>alert('Record deleted successfully')</script>"); 
}
}

It works fine, but I want to need a confirmation box like this before deleting record

Please help

ginerjm

add an onclick event to your submit button. In it point to a JS function that simply returns the result of a confim() call.

<input type='submit' name='delete' value='Delete' onclick='return confirmDelete()'>

Put this in your <head> section.

<script type='text/javascript'>
function confirmDelete()
{
   return confirm("Are you sure you want to delete this?");
}
</script>

tqmd1

[FONT=verdana]Sir, I have following codes

// DELETE 
        if(isset($_POST['delete'])) 
        { 
            // Get values from form  

            $sno = $_POST['txtsno']; 
            $pro = $_POST['txtpro']; 
            $wet = $_POST['txtwet']; 

            //$query = "delete from test WHERE sno='".$sno."'" ; 
            $query = "delete from ghee WHERE sno={$sno}" ; 
            $result = mysqli_query($con, $query); 

            if(!$result)            { 
            echo "<script>alert('Record not deleted')</script>"; 
            }else{ 
            echo ("<script>alert('Record deleted successfully')</script>");  
                  } 
        } 
?> 

      <form name="form1" action="" method="post"> 
        <table border=0; cellpadding="1" cellspacing="1" bgcolor="" align="center" > 
        > 
        <div style=text-align:center;margin-top:20px;> 

          <input type="submit" name="delete" value="Delete" onclick="return (window.confirm('Do you really want to delete this record?') ? 1 : 0);" 
> 

        </div> 
      </form>

[/FONT][/COLOR][FONT=verdana]When I press delete button then confirmation apperas but..[/FONT]
[FONT=verdana]In both cases (Yes or No), record is deleted automaticlly.[/FONT]

[FONT=verdana]I think when Delete button is pressed then this part of codes runs immediately without caring Yes or No option.

 if(isset($_POST['delete']))

[/FONT][/COLOR][FONT=verdana]The record must not be deleted in case NO button is pressed.[/FONT]

[FONT=verdana]Please help again. Thanks[/FONT][FONT=verdana]
[/FONT]

priyankagound

well..., i think you must try out with the below code:
echo"<form method = \"post\" action =\"change.php?change=$productid\">";
echo// form fields here!...
echo"<input type=\"submit\" name = \"delete\" value=\"Delete\" onclick=\"return deleletconfig()\" />";

if (isset($_POST['delete'])){ //delete clicked
//get variables here
//run query delete record from xyz where id=$id

}

var del=confirm("Are you sure you want to delete this record?");
if (del==true){
   alert ("record deleted")
}else{
    alert("Record Not Deleted")
}
return del;
}

</script>

I have used the above code in one of my application and it has worked fine for me.
Hope this helps,

ginerjm

Use the code I gave you EXACTLY the way I gave it to you.

keithljarvis

This works great, THANKS!

ginerjm

A 3 year old post. Hmmmm.

But - I am glad that my suggestion helped someone out! I never heard back from the OP after his disastrous attempt to not follow my post.

HTH!