如何使用php在删除查询之前从用户获取删除确认

Question

Below is my delete code using php,I want to get confirmation after delete link was clicked from the user using php.

 <?php
 include('conn.php');
 $query=mysql_query("DELETE FROM mark WHERE student_id='$_GET[st_id]'");
 if($query)
    {
        echo ("<SCRIPT LANGUAGE='JavaScript'>
    window.alert('Succesfully deleted')
    window.location.href='mark-details1.php';
    </SCRIPT>");
    }
    else
    {
        echo "Check your Server";
    }
    ?>

Please anyone can tell me how to do this? Thanks in advance!

Answer 1

you can use this javascript event on your html tag.

onclick="return confirm('you sure?');"

you can also use this :
if your link will send a get like "?delete=(id)"

<?php
include('conn.php');
if(isset($_GET['delete']) && is_numeric($_GET['delete'])==1){
    echo (a page with a form with confirmation question content that will sent a get for example (?checked_delete=(id)));
}elseif(isset($_GET["checked_delete"]) && is_numeric($_GET["checked_delete"])==1){
    // TODO : deleting record.
    $query=mysql_query("DELETE FROM mark WHERE student_id='$_GET[checked_delete]'");
    header("location:mark-details1.php")
}else{
    echo (normal page);
}
?>