Help! My Queries Refresh Page and Clear Vital Data

[San_John]

I have a page called delete.php that can be used to delete any records passed to it. Once the records are deleted I want the page to print a link back to the page that the user came from originally. The problem is that running the delete sql command clears out the page's data so that the "return link" becomes non-functional. How can this be avoided? Here is the code

#Choosing the correct database/establishing connection
$connection = mysql_connect("localhost", "xxxxxx", "xxxxxx") or die("Death!");
$pickdatabase = mysql_select_db("xxxx", $connection)
	   		  or die("Database Connection Problem!");

$delid = $_GET['delid']; 
$dbtable = $_GET['dbtable']; 
$idfield = $_GET['idfield']; 
$origin = $_GET['origin'];


$deleteform="<form align=\"Center\" action=\"$PHP_SELF\" method=\"post\">";
$deleteform.="<p>Are You Sure You Want To Delete This Record?</p>";
$deleteform.="<a href=\"$origin\">Back</a>";
$deleteform.="<input type=\"hidden\" name=dbtable value=\"$dbtable\"></input>";
$deleteform.="<input type=\"hidden\" name=delid value=\"$delid\"></input>";
$deleteform.="<input type=\"hidden\" name=idfield value=\"$idfield\"></input>";
$deleteform.="<input type=\"submit\" name=\"cdelete\" value=\"Confirm Delete\" ></input>";
$deleteform.="</form>";

$cdelete = $_POST["cdelete"];
if($cdelete){
$delid = $_POST['delid']; 
$dbtable = $_POST['dbtable']; 
$idfield = $_POST['idfield']; 
$origin = $_POST['origin'];


$delquery = "delete from $dbtable where $idfield='$delid'";
$rundelquery = mysql_query($delquery, $connection) or die("The Query failed");
echo("Record Deleted");
$origin = $_POST['origin'];
echo("<a href=\"$origin\">Back</a>");
}
else{

echo($deleteform);
}
?>

[laserlight]

in your form tag, append $SERVER['QUERY_STRING'] to $SERVER['PHP_SELF'] in the action attribute's value.

[San_John]

in your form tag, append $SERVER['QUERY_STRING'] to $SERVER['PHP_SELF'] in the action attribute's value.

Do you mean:

$deleteform="<form align=\"Center\" action=\"$_SERVER['PHP_SELF'] \" method=\"post\">";

?

Sorry...I'm just an idiot and I'm not following exactly what you mean oh great PHP guru. 😃

[gabriel_koen]

In case you're still wondering...I believe what laserlight means is:

$deleteform="<form_align=\"Center\"_action=\"$_SERVER['PHP_SELF']?$_SERVER['QUERY_STRING']\"_method=\"post\">";