[RESOLVED] Problem with POST page being refreshed

[jheitz]

Hi all,

I have a web page that I use to create records in a database table. The web page will allow users to create projects and assign materials to those projects. As such, it has a post form that, when submitted, sends the user to the same page (I want to do this, as the user should be able to add several materials to a project, and the form has a list of the materials already assigned to the project).

When the form is posted (ie: the POST variables are set) I call the relevant STORED PROCEDURES to create the project and/or materials for that project.

Now, what I want to acomplish is that, once the material is added, the list of materials for this projects is refreshed. I thought about doing this by refreshing the page using javascript (I use: "window.location.reload( true );" is there a better way?), but I have 2 problems:

1) The page issues a warning asking for confirmation to reload a POST page.
2) The page-reload goes into a loop, as the POST variables are set and therefore the database insertion and refresh is executed again and again...

I am sure there must be a much simpler/better approach but I am quite new to Php. Any ideas/suggestions? Many thanks,

Javier

[laserlight]

Instead of displaying the page with the old material listing, simply retrieve the new materials list and display that.

[devinemke]

i suggest the following basic logic:

• if the form has not been submitted then echo out the form
• if the form has been submitted then first INSERT the data and then echo out the form again.
• if there is relavant data that needs to be available for each subsequent form submission then store that in a [man]session[/man].

[jheitz]

How simple was that? Sorry for the silly question... kind of forgot that after the POST evaluation the page will load again anyways and is at this point the list will get refreshed given I put the correct code to do so. Thanks