Returning to blank form after data submission

[JGuiher]

I have a simple website for our restaurant that logs our deliveries.

It allows those who order to know if their order is still being made or out for delivery. I use a small php form with the $_post method that logs the phone number, price, payment method and if they order via internet or phone.

It keeps a list below this single line form of the deliveries and we assign them to a driver and mark them complete when we deliver them.

Everything works great, but I have one really annoying issue that I can't figure out how to fix. When it goes from form.php to processform.php and processes, I can not figure out how to get it to automatically return back to form.php.

Could I do this with a function that process the form within form.php?

Thanks.

[shwagman]

with out seeing how your code works its a little hard for me to answer but this is how it works in my blog area of my site. you could try this at the end of your function of the process page. so after it process the info it would go to your linked page.

firesql($sql_query,'');
					$link="put url of first page here";
		}
		go2($link);

sorry if this doesn't work but maybe you might want to post the code your using for both pages. usally helps to see how the code works.
shwagman

[JGuiher]

Here is the form (minus the db variables)

<?php

mysql_connect($db_hostname, $db_username, $db_password)or die(mysql_error());
mysql_select_db("$db_name") or die(mysql_error());

$result = mysql_query($query_delivery_outfordelivery) or die(mysql_error());
$rowcount = 0;
while($row = mysql_fetch_array($result)) {
if ($row['delivered'] == "no")
{
$rowcount += 1;
echo "<form action=\"processoutfordelivery.php\" method=\"post\"><select name = \"id\"><option>".$row['id']."</option></select>".substr($row['phonenumber'],0,3)."-".substr($row['phonenumber'],3,3)."-".substr($row['phonenumber'],6,4)." ".$row['ordertime'];
echo" <input type=\"submit\" value=\"Delivered\" /> </form><br/>";
}
}
if ($rowcount == "0")
{
echo "No Orders Out for Delivery<br/>";
}
?>

Here is the process form code minus the db variables

<?php 

$id = $_POST["id"];

$inkitchen_query = "UPDATE delivery SET delivered = 'yes' WHERE id = '$id'";

mysql_connect($db_hostname, $db_username, $db_password)or die(mysql_error());
mysql_select_db("$db_name") or die(mysql_error());

mysql_query($inkitchen_query) or die(mysql_error());

?>

[coldwerturkey]

a simple method to put the processing in the same page as the form, you can do something similar to,

<?php

if (isset($_POST['name'])) {
	//process
	//echo thank you message or confirmation
} else {
	//form
}

?>

[djjjozsi]

you can process the values in another page, and use the

header("Location: form.php?message=ok");

if evrything is fine,
but on error/warningmust visible, use:

header("Location: form.php?message=not_ok");

And in form.php you can check the $_GET["message"] variable with an IF condition/Switch Case
to print the suitable message.

Why is it better then process the form in the same file? becouse on page refresh you won't process the form once. Just think of a rank system, or a poll machine.

And i've never heard a php function which shwagman mentioned:

go2($link);

[meltmedown]

You should try this method. I've used it with my website and works great.

This form should be in form.php. Please note the name of the submit button.

<form method="post" action="processform.php">
<input type="text" name="field_name">
<input type="submit" name="submit" value="Submit">
</form>

Now in processform.php you should add this code.

<?php

if (isset($_POST['submit'])) {

print "<script language='javascript'>
history.go(-1);
</script>";
}

?>