Verify a Delete Function

Anon

I would think this would be simple...
But I can't get it for nothing

All I want to do is verify a delete

I'm Using MySQL to store Data I want to delete it but to verify the delete before it does delete, can anybody help

Thanks in advance

Anon

You must select data from table before... Soh you print in html the records returned by select and write a Question to user....

If Ok, then execute delete query...

(you will use hidden fields on a form...)

Anon

Or use a javascript alert and then when they click okay you can submit the form using javascript.

like in the isubmit tag, onClick="verify_delete(); "

where verify_delete() is a function that first prompts for user clicking ok then submits the form

Anon

The best way that I know would to create a check on the page when you submit the info to make an if ( $page == "first_submit ) ... then print out the information you're verifying for delete. In that first printout, just print out all the info you do before teh sql.

Then the next link is "Confirm Delete" on the information. That will set $page == "confirm_delete". Just make another if, just like the first for that, except execute the sql statement.

Example:
if ( $page == "first_submit" ) {
echo ("All the info you're deleting or a id or whatever the item is");
echo ("A submit button that sets id = to that of the record you wanna delete");
} elseif ( $page == "confirm_delete" ) {
$sql = "delete from table where id = 'id'";
$result = mysql_db_query ($database, $sql);
echo ("Item ID:".$id." <b>deleted</b>");

Oh ya and make these all just post to the same file name. You can run almost an entire site off of one page if you're crafty enough. =)
Hope this helps...lil a confusing i spose

Anon

The best/easiest way Richard, would be to use if() statements.

If the user chooses to delete something, the if() statement ask's them if they are sure they want to delete, and if they do, then the delete happens.

Example:

<a href='http://www.domain.com/site.php3?delete=some_file'>Delete Some_File</a>

if(isset($delete))
{
print("<a href='http://www.domain.com/site.php3?confirm_delete=some_file'>Are you sure you want to delete $delete</a>");
if($confirm_delete)
{
rm($delete);
}
}

Hope you understand this. 🙂

[ John

Anon

Bah I said that. =) Same smell =P