Call a PhP form and return to where I came from....

Ton_Wibier

Hiya Guru's!

Do I have a teenyweeny challenge (problems we don't know, do we?) for you!

I have an HTML page where the surfer can type in his/her name, address etcetera. Of course, there is a submit button to make the page complete.
Also I have an action pointing to the PhP page with the method "Post".

My PhP page is called and everything typed in by the user is stored in the MySQL database. Now, here is my question:
I would like to exit from the PhP page, which, in fact, is some sort of a "subroutine", clear all the fields on my HTML page and return there.

I've tried EXIT, but that doesn't seem to help. Also, RETURN is not an option.
Which command should I use to return to the HTML page after I return from the PhP page?

I hope you can help me out on this one. Thanks a million in advance!

BuzzLY

Simply do a http redirect to your original page. Since it's a new instance of the page, all the form fields will be empty. You can do this with either a meta refresh or a PHP header command.

Ton_Wibier

Buzzly, it isn't working properly. Now, it looks like my PhP page is coming into an infinite loop it can't get out of.

The first loop all the data is written correct into the database, but with all the next loops I get empty entries. The only field which is filled out, is the sequence number field. In MySQL I made it AUTO_INCREMENT. The rest of the fields is empty.

This is the source I use:

<html>
<head>
<LINK href="stylesheet.css" rel="stylesheet" type="text/css">
<title>Gegevens opslaan</title>
<META HTTP-EQUIV="pragma" CONTENT="no-cache">
<META HTTP-EQUIV="refresh" CONTENT="3; nawinvoer.html">
</head>

<body>
<table class="tableattr" align="center">
<tr class="rowheader">
<td>De gegevens worden opgeslagen!</td>
</tr>
<tr>
<td><center><b>Een ogenblik a.u.b.</b></center></td>
</tr>
</table>

<?php
mysql_connect("localhost","","");
mysql_select_db("database");
$SQLString = "INSERT INTO nawbestand
(volgnummer, achternaam, voorletters, tussenvoegsel, geboortedatum, geslacht, NAWpostcode, huisnummer, telefoon, fax, mobiel, email, website, klant, bankgiro)
VALUES('', '" .$POST['achternaam']."', '".$POST['voorletters']."', '".$POST['tussenvoegsel']."', '".$POST['geboortedatum']."', '".$POST['geslacht']."', '".$POST['NAWpostcode']."', '".$POST['huisnummer']."', '".$POST['telefoon']."', '".$POST['fax']."', '".$POST['mobiel']."', '".$POST['email']."', '".$POST['website']."', '".$POST['klant']."', '".$POST['bankgiro']."')";
$result = mysql_query($SQLString);
mysql_close();
?>

</body>
</html>

Again I would like to emphasize that the storage of the input into the database is NOT the problem!

I just want to close the PhP page and get back to the HTML input form. That's it!

I hope one of you can help me. Thanks a lot for your answer. Much appreciated!

suntra

I think the problem is with
<META HTTP-EQUIV="refresh" CONTENT="3; nawinvoer.html">

You should write :
<META HTTP-EQUIV="refresh" CONTENT="3; url=nawinvoer.html">

Also, you can use the header() function :
header("Location: http://www.yourserver.com/yourdirectory/nawinvoer.html\n");
But remember : you must not output anything before calling that function.

Hope it helps.

Rohan_Hill

Yup, PHP redirect is the way to go. Do something like this:

header("Location: http://www.yoursite.com/yourpage.html");

PHP redirects have to be given in full like that, but if you want your script to be able to be run on different servers without having to change the address in the header () function, use this:

header("Location: [url]http://[/url]".$SERVER['HTTP_HOST'].dirname($SERVER['SCRIPT_NAME'])."/yourpage.html");

That will redirect to the file "yourpage.html", in the same directory as the script which is being run 🙂

planetsim

Umm.. ye header("Location: page.php");

you may wanna read up on header if your not sure.. You must have it before any output. That being PHP error or a html tag. If you do however want it in between errors or tags.. Just look up ob_start();