To make users feel better

[Anon]

To make users feel better, I want to add some functionality. I have my entire project coded in PHP and it is working like a dream.

I have a function that deletes records from a database. I'm using PHP and MySQL to do this.

I want to throw up either a message box, or small window, or something that says basically, "Are you sure? Yes/No". And then of course, reacts accordingly. As PHP is all server side, I'm having a hell of time figuring this out.

Are there any MySQL functions that do this from the server?

Has anyone had to do this for themselves?

I know...this is one of the oldest questions in the history of programming, but I've been searching all day and still haven't found anyone with the answer. Other than, "you can't"....
Thanks. You all rule.

[Anon]

You need to use a client-side javascript to accomplish this. It's very easy, just run a search on google.com for javascript confirmation or something.

[Anon]

rather than have your website running with DELETE privileges you might want to consider having a live field with possible values Y or N which can be changed on an UPDATE and determines whether a record is considered live

you can always later run some private scripts later to do any deletes

as a good practice i always try to run my sites with the minimum of privileges

paulsbooker

[cowboy_x]

Here's some quickie javascript that should do the trick...

<script type="text/javascript" >
function areYouSure()
{
if (confirm("Are you sure you want to delete this data?") )
{return true;}
else
{return false;}
}
</script>

<form action="deletePage.php" method="post" name="deleteForm" onsubmit="return areYouSure();" >
blah blah blah
<input type="submit" value="click here to delete data" />
</form>