Confirmation When delete a record

[Fari]

Hello , I want to add a confirmation before I delete a record . For example if the user wants to delete they press "Yes" otherwise "NO" and go back.
The code I have now is:

<?php

//delete user
$sSQL = "DELETE FROM user WHERE (userid = ".$_GET['record_id'].")";

$result = mysql_query($sSQL) or die(mysql_error());

echo "<h1> User deleted succesfully</h1><br>";

?>
Can someone help me. Thanks.

[Tyree]

I do this with javascript. I guess you could do it with php, but, it's so easy with javascript! 😃

[Fari]

It would be nice if you could help me. I like to see the javascript code

[bradgrafelman]

<a href="delete.php?id=5" onclick="return confirm('Are you SURE you wish to delete this row?')">Delete</a>

Also, your script is very likely open to SQL injection vulnerabilities - consider running the $_GET[] value you wish to use through a function such as [man]intval/man (since you're expecting an integer) before using it in your query. If you were expecting a string, you could use something like [man]mysql_real_escape_string/man. For more information, search the board or the web for 'sql injection'.

[christillis]

A previous thread relating to this