php approve database entry?

Question

Is there a way that I can create a page to approve submissions to my database from other users before they post to the database?

Answer 1

There are two particular approaches to this that are fairly common. One uses two database tables to separate approved and unapproved posts, where the page you want to create will copy the data from an unapproved post to a new record in the approved table and delete the record from the unapproved table. The other approach uses a single table for all posts and uses a single column to indicate whether or not posts are approved or not, generally using some kind of default value (like NULL) to indicate unapproved posts. You can then modify the page to display approved submissions to filter the data is displays depending on which method you use.

Answer 2

If the entry is one line and you are checking like the email address field was indeed email one good way is to use JavaScript to verify entry before submit.