PHP and MySQL

[timcclayton]

Hello all.

I have a webpage called "vapireps.php". The top half of this page contains a form in which the user enters their data in fields and then clicks the "Submit" button to call another PHP script which adds their data to the MySQL database. The bottom half of this page shows the last 10 database entries. After much searching I have managed to get these two sections working perfectly.

What I want to do now is this: As soon as the user comes along, enters their data and clicks the "Submit" button, I want to add their data as a new record in the database and then immediately refresh this "vapireps.php" page so that the bottom half of the page now shows this latest entry.

Is this possible...?

Many thanks in advance,
Tim.

[js_thind]

You can simply set the form's action attribute to 'vapireps.php' and then move your data handling code to the top of the vapireps.php script.

Or if you are submitting the data to another script (say vapireps-submit.php), you can redirect back to vapireps.php page using the header() function.

Or you can use AJAX.