query/results/edit and redirect back to results page

adamsca

I have a form (page1.php) that I use to query a mysql database. The resulting page (page2.php) has an option to modify one field using a drop-down menu and another option to delete entire records via checkboxes. This works fine. After submitting either a modification or deletion, the user is sent to another page (page3.php) that gives them some feedback like "Your records have been deleted", with a link back to the search page. I would like the user to be redirected to the previous results page, minus the records that have been deleted, or with the modifications that were made.

So, do I use sessions, or somehow pass a results variable to another page to display the previous results of the query. Some pointers would be most welcome.

Here is the code for page3.php does the actual deletions and modifications.

if($POST['Modify'])
{
foreach($POST['id'] as $id)
{

  $sql1="UPDATE documents SET status='".$_POST["status".$id]."' WHERE id='".$id."'";
  $result1=mysql_query($sql1);

}
}

if($result1)
{
echo "Your record(s) have been modified. <a href='NEWindexGOOD.php'>Search again</a>";
}

if($POST['delete'])
{
$checkbox = $POST['checkbox'];
for($i=0;$i<count($checkbox);$i++)
{

$del_id = $checkbox[$i];
$sql2 = "DELETE FROM documents WHERE id='$del_id'";
// echo $sql2;
$result2 = mysql_query($sql2);
}
}

if($result2)
{
?>
<html>
<head>
<title>Title</title>
</head>
<body>

<center><h2>Blah blah blah</h3>
<table align="center" width = 400>
<tr><td> Your record(s) have been deleted. <a href="NEWindexGOOD.php'>Search again</a></td></tr>
</table>
<?php

}
?>
</body>
</html>

Pikachu2000

I would think you could modify and submit the form to itself instead of directing the user to the third form.

adamsca

Thank you for your reply. I had tried to submit the form to itself. However, it queried the entire database rather than using the search parameters specified in the search.

So, I have a page1.php that has a form. This form submits to page2.php, which shows the results of the search. At the bottom of the page, I have the

if($_POST['Modify'])

{

}

and

if($_POST['delete']) {

}

If I do it like this and submit to the same page, I get everything in the database rather than results based on my search parameters. Just to avoid getting all that junk, I removed the above and put in in page3.php and submitted the Modify or Delete to page3.php. It doesn't solve my problem, but at least all I get is the feedback and links to do another search.

So, what am I missing? Does it have something to do with the order of the blocks of text, where the 'if' statements are and how I use these qualifers? If done right, should I be able to submit the Modify or Delete and get back the updated results based on my original search parameters?

I can post entire page code if needed.