However, i want to see if i can take this one step further.
I want to be able to delete entries into this database from this same page. Does anyone have a suggestion?
Thank you for helping a newbie
Moderator: General Moderators
Code: Select all
if (isset($_POST[confirm])){//delete record
$id=$_POST[id];
$query="DELETE * from tablename WHERE idname='$id'";
mysql_query($query) or die ("Couldn't delete");
exit("Done");
}
$id1=$_REQUEST['item_id'];
//check right record and confirm delete
$query1="SELECT FROM tablename WHERE idname='$id1'";
$result=mysql_query($query1);
$row=mysql_fetch_assoc($result);
//output row
//form for confirm
echo "Are you sure you want to delete?";
echo "<form action=deleterecord.php method=post>";
echo "<input type=hidden name=id value=$id1>"
echo "<input type=hidden name=confirm value=y><input type=submit>";Code: Select all
<form action="delete_record.php" method="post">
<input type="text" name="record_to_delete" />
<input type="submit" value="Delete Record" />
</form>
Code: Select all
<?php
if(!empty($_POST['record_to_delete']))
{
mysql_query("DELETE FROM `table` WHERE `id` = '".$_POST['record_to_delete']."'") or die(mysql_error());
}
?>