mySQL Content Management

Greg_Baker

I'm using a very simple, custom written, content management system on my webpage. I am also using phpBB2. If a user is logged in as an administrator in phpBB, then they have access to a page with a form and two fields. One allows them to enter a header and the other allows them to enter a message. On submittal, the user is sent to index.php. index.php executes checks to see if $submit == true. If it is, it takes the the content from the form from the previous page and adds it to a database. The code then goes through that database and creates a <div> for every entry and prints them on the page. My problem is that if a user submits an entry and is redirected to the home page and then refreshes the page, the information will be resent and there are duplicate posts on the page.

I would like to put the code to add the data into the database within the page that takes the user's input but I am not sure what the best way to do this is. Any Help?

Thanks,
--Greg Baker

tsinka

Hi,

that way could work:

Change the action of your form script to PHP_SELF. Move the code for testing the submit and inserting the data into the database to the form script. After the data has successfully been inserted into the database, redirect the user to the index.php (or whatever the name of the home page script is) with e.g. header("Location: index.php"). Make sure that there is no output prior to calling header, you would get error messages otherwise.

That would ensure that the users won't post the data twice because subsequent refreshes would only refresh the index.php and not the form page.

One more:

If you want to prevent the users to post the form several times by clicking on submit several times because e.g. it takes some time to post the data, you can prevent this with a little bit of javascript.

Give the form a name e.g. <form name="myform".....

change the submit button from type="submit" to type="button" and add the following javascript code into the input tag:

onClick="this.disabled=true;document.forms.myform.submit();"

The button will be disabled after the first click and the form will be submitted afterwards.