When a user wants to delete a row from a database via my webpage, I want to prompt a message-box asking, "Are you sure you want to delete?". Then in my php code, I want to track if the user press Ok
or Cancel
and execute the delete operation as shown bellow. I am new to web-programming and any help would be appreciated.
<?php
.
.
.
if (user wants to delete a row from database)
{
echo "<script type=\"text/javascript\"> confirm(\"Are you sure you want to delete?\"); </script>";
if(user press OK to delete")//How can I get input from the dialog box?
{
$deleterow = "DELETE FROM ElectronicShop WHERE WorkOrder = $i";
$datadelete = sqlsrv_query($connectString, $deleterow) or die(print_r(sqlsrv_errors(SQLSRV_ERR_ALL), true));
if($datadelete)
echo "<br>you have deleted: $i Successfully";
else
echo "<br>could not be deleted: $i";
}
else
echo "User pressed Cancel";
}
?>