Delete Y/N Option

[aztec]

Hello

 

Part of my database management modules includes an option to delete an entire row from the database, this works without any problems.

 

However I would like to include an option that after the DELETE is clicked a YES or No button would be displayed before the actual delete in the MYSQL database took place, to allow second thoughts.

 

i.e. click YES to delete or click NO to cancel the delete operation.

 

I have been searching both the forum and the Web with no success.

 

Any help or guidances much appreciated.

 

Kind Regards

[Northern Flame]

you can do this with javascript:

something like

 

<script type="text/javascript">
function confirmDelete(){
var answer = confirm("Delete Row?");
if(answer){
alert("Row Deleted!");
window.location = "http://www.yourwebsite.com/delete-row.php";
} else{
alert("Row was not deleted!");
}
}
</script>
<a href="javascript:void(0)" onClick="confirmDelete()">Delete</a>

[tippy_102]

This is easy:

<a href="delete.php" onClick="return confirm('Delete item?');">Delete</a>

[aztec]

Hello

 

Many thanks for your response. Obviously I will try all options but at this time there is no javascript used in the modules therefore I would prefer to use PHP if at all possible.

 

<a href="delete.php" onClick="return confirm('Delete item?');">Delete</a>

 

Is onClick a javascript function.

 

Regards

[marcus]

Yes, it is.

 

for php you can do something like

 

<form method="post" action="deleterow.php">
<input type="hidden" name="row" value="<?php echo $row['id']; ?>">
<input type="submit" name="submit" value="Yes"><input type="submit" name="submit" value="No">
</form>

 

//deleterow.php

<?php

$submit = $_POST['submit'];

if($submit == 'Yes'){
// delete row
}else {
// do something else
}

?>