Beginner: PHP Header Error - MySQL

manpreet Best Answer 3 years ago

I am a complete beginner with PHP/MySQL and HTML but the help I have received from this forum in aid of me learning has be astonishing. Really apprecaite it.

My latest problem comes when I am deleting a record from my database and my html table outputted onto a page. I click delete and the record is deleted straight away, however if possible, Id like a dialogue box to say "Are you sure you want to delete this order?"

index.php:

php
include('connection.php');
$result = mysql_query("SELECT * FROM orderform ORDER BY id ASC");
echo "border='1' >
";while($row = mysql_fetch_array($result)){
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";

echo "";}
echo "

ID
Date
Product
Product Comments
Name
Address
Age
Delivery
Order Complete?




" . $row['id']. "
" . $row['date'] . "
" . $row['product'] . "
" . $row['productcomments'] . "
" . $row['name'] . "
" . $row['address'] . "
" . $row['age'] . "
" . $row['delivery'] . "
.$row['id']."\">Yes
";
?>

deleterow.php:

php
$id = $_GET['id']; //this needs to be sanitized 
if(!empty($id)){
    include('connection.php');
    $result = mysql_query("DELETE FROM orderform WHERE id=".$id);
}
header("Location: index.php");
?>

All help is greatly appreciated