PHP: Delete from a Database with some prompts from javascript

Question

My code is below, I am trying to delete records from mysql database but before deleting the browser has to prompt the user whether the deletion should continue. My problem is my logic is not working its deleting the record no matter what. Any help will be appreciated.

   if (isset($_POST['outofqcellchat'])){
?>
<script type ="text/javascript">
var question = confirm("Are you sure you want to unsubscribe\nThis will delete all your facebook information in QCell Facebook");
if(question){
<?php
$delusr = mysql_query("delete  from `chat_config` where `phone` = '$phonenumb'");
$row = mysql_num_rows($delusr);
if($row>=1){
header("Location:http://apps.facebook.com/qcellchat");
}
?>
alert("Unsubscribed, You can register again any time you wish\nThank You");
}else {
alert("Thanks for choosing not to unregister \nQCell Expand your world");
}
</script>
<?php
}
?>

Thats my code. Please help

Answer 1

The PHP runs on the server before the client even sees the JavaScript. Use AJAX or a form submission instead.

Answer 2

You have a fundamental misunderstanding between PHP and Javascript here. The PHP code will be executed regardless of any JavaScript conditions (which will be processed long after PHP is done, in the browser).

You will need to change the logic so that confirming the deletion redirects the user to a PHP page that deletes the record, or starts an Ajax request with the same effect.

Answer 3

you want to prompt the user upon click of a anchor tag or button. For eg using anchor tag

<a href="delete.php" onclick="return javascript:confirm("Are you sure you want to delete?");" />Delete</a>

This will prompt user.

Or you might use a javascript function such as

    <a href="delete.php" onclick="return check();" />Delete</a>

    <script type="text/javascript">
    function check(){
    var question = confirm("Are you sure?");
    if(question){

    return true;

    }else{

    alert("Thanks for not choosing to delete");
    return false;

    }

    }
</script>

Hope this helps.