Moderated submissions...

[cobaltblue]

Hello everyone,

 

I'm looking for a simple way to pull this off, and I'll try to explain it as detailed as possible...

 

My goal is to have users input text, submit it, where it goes to a system to be approved/rejected by human moderators on a password protected page. The approved submissions are then posted to a page viewable by everyone, and the rejected submissions are obviously dropped.

 

In case that was unclear, here's a simple diagram:

 

Input textbox -> Submit -> Moderation system -> Approved to other page

 

 

The problem is simply I don't know how to make this work. I am a beginner when it comes to PHP, and I just need someone to point me in the right direction.

 

Thanks to anyone who can help me out.

[trq]

Simply save the data in a database along with a approved field set with a default of 0. Once you have approved the data, update the approved filed to 1.

 

Then simply query for approved data to display.

[MadTechie]

What do you need to know ?

 

its probably best to use a mysql database, do you have a Moderation/User system inplace ?

[cobaltblue]

What do you need to know ?

 

its probably best to use a mysql database, do you have a Moderation/User system inplace ?

 

I just need to know how to actually go about doing it.

 

I don't have a user system in place yet, but it wouldn't be that hard to set up.

[MadTechie]

setup one and add another table, for data and a tinyint for approve 1=approved, as thorpe says

[cobaltblue]

Thanks so much both of you