I know this should be very simple, but I just don't get it.
I want to delete a record from a mysql table, but prior to deleting the
record I want to receive an option to confirm the deletion. On page one
(kb_areas_add.php) I have a form for inputting the field (area_todelete) for
the record I want to delete. The form action goes to page two
(kb_areas_delete) on which I am asked to confirm the deletion. I want to be
able to press the delete button to delete the record, or the cancel button
to cancel the operation.
The way the code is written, the record gets deleted immediately upon
clicking the submit button on page one. Is there some way I can keep the
script on page two from executing until after I press the confirmation
button?
Thanks for any suggestions.
/* FORM FOR SELECTING AREA TO DELETE */
<form action='kb_areas_delete.php' method="post" name="DeleteAnArea">
<input type="submit" name="DeleteArea" value="Delete Area" border="0">
Area: <input type="text" name="area_todelete" size="24" border="0">
</form>
/* FORM TO CONFIRM DELETION */
<?php
//Delete Areas and All Subjects for the Area
$host = "localhost";
$user = "root";
$pass = "pwd";
$database = "new_kb";
// Connecting to the Database
$connect = mysql_connect($host, $user, $pass) or die("could not connect to
server");
$db_select = mysql_select_db($database) or die("could not select the
database");
// Get Area ID
$sql = "SELECT id FROM kb_areas WHERE area = '$area_todelete' ";
$result = mysql_query($sql) or die("could not complete your query for Area
ID");
$area_id = mysql_result($result, 0, "id");
?>
<p>Confirm Deletion</p>
<p>Are you sure you wish to delete the general area, <b><?php echo
$area_todelete?></b></p>
<form action='kb_areas_add.php' method="post" name="DeleteTopic">
<input type="submit" name="DeleteArea" value="Delete" > <b><a
href="kb_areas_add_test.php">Cancel</a></b>
</form>
<?php
//Delete area from kb_areas
$sql2 = "DELETE FROM kb_areas WHERE id = $area_id";
$result2 = mysql_query($sql2) or die("couldn't complete your query to delete
the areas");
?>
<?php
//Delete subjects from kb
$sql3 = "DELETE FROM kb WHERE area_id = $area_id";
$result3 = mysql_query($sql3) or die("couldn't complete your query to delete
the subjects");
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
