[RESOLVED] Decision tree

[Jon12345]

I have a page that deletes an entry in a MySQL db. There is no safety check though. So, I would like the question posted first, by button or hyperlink.

e.g. Are you sure you wish to delete this entry?

Yes, delete No, do not delete

<?

include('dbconnect.inc');
mysql_query("DELETE FROM products WHERE ProductID='$id'");

mysql_close();

header("Location: admin.php"); 
?>

[devinemke]

<?php
echo '<form action="" method="POST">';

if (!isset($_POST['submit']))
{
	echo '
	ProductID: <input type="text" name="ProductID">
	<input type="submit" name="submit" value="delete">
	';
}

if (isset($_POST['submit']) && $_POST['submit'] == 'delete')
{
	echo '
	are you sure you wish to delete ProductID ' . $_POST['ProductID'] . '?
	<input type="hidden" name="ProductID" value="' . $_POST['ProductID'] . '">
	<input type="submit" name="submit" value="confirm">
	';
}

if (isset($_POST['submit']) && $_POST['submit'] == 'confirm')
{
	include('dbconnect.inc');
	mysql_query("DELETE FROM products WHERE ProductID = '" . $_POST['ProductID'] . "'") or exit(mysql_error());
	header('location: admin.php');
	exit();  

}

echo '</form>';
?>

or use javascript

[Jon12345]

That is brilliant! However, I arrive at my delete.php page via a hyperlink:

echo "<a href='edit.php?id=".$row['ProductID']."'>edit</a> | <a href='delete.php?id=".$row['ProductID']."'>delete</a>";

How can I modify the code so I don't have to type in the Product ID?

[devinemke]

use $GET['ProductID'] instead of $POST['ProductID']

[Jon12345]

I am a bit confused really. I'm looking for something that has a Yes or No link or button to confirm the delete, rather than just one button that says Delete, as is shown currently.