I am doing my software project implemetation system using the php language and i have ran the following code expecting it to delete a row from the database after i click the yes button but it does not perform as expected.
Language: PHP
<?php
error_reporting(0);
include("C:\Program Files\EasyPHP-5.3.3\www\project\connect.php");
connectToDB();
$ownerID =$_GET[';OwnerID';];
$SQL = "SELECT ownerID, ownerName, ownerSurname FROM owner WHERE ownerID=';$ownerID';";
$result = mysql_query($SQL);
while($row = mysql_fetch_array($result)){
$ownerID = $row[';ownerID';];
$ownerName = $row[';ownerName';];
$ownerSurname = $row[';ownerSurname';];
}
if(isset($_REQUEST["yes"])){
$query = "DELETE FROM owner WHERE ownerID=';$ownerID';";
$results = mysql_query($query);
header ("Location: adminDelete1.php");
}
if(isset($_REQUEST["no"])){
header("location:adminDelete1.php");
}
?>
// form
<?php echo "Are you sure you want to delete <font color=';lime';><b> $ownerName $ownerSurname</b></font> from a list of owners? ";?>
// button YES and NO
//close form
if i click the yes button it goes to the right location but it does not delete. Can anyone pls tell me where i got it wrong.