Jump to content

Archived

This topic is now archived and is closed to further replies.

Solarpitch

Being able to moderate submitted entries?

Recommended Posts

Hey guys,

I am developing a site that involves user's being able to submit information in the form of an advertisment of a product they want to sell.

After the user submits the add I want to be able to moderate all the submitted adds before they get updated in the database!

I've thought hard about this but I'am not quite sure where to start, or even how it would be implemented!

I'd love some advice, Ger.

Share this post


Link to post
Share on other sites
I think the best way to go about it would to create another table that contains all the fields that the main table has (the ones you require). Once a user submits something, insert it into the "pending" table. You could then make a page that calls all entries from that table.

Then make another page that allows you to approve or deny etc. If you approve, it will add it to the main table and delete it from the "pending" table. Or if you deny, maybe add in a feature that will have it send a message to them that asks them to contact you for further questioning.

Share this post


Link to post
Share on other sites
Or (to save some resources) have a validation field in the table (simple boolean value. 0 for not validated, 1 for validated). Then you could list all not validated adds and update the validation values for those you want.

Share this post


Link to post
Share on other sites
Thanks guys! I cant believe i didnt think of that . . . so simple! Sometimes the answer is right under yout nose! :)

Cheers!

Share this post


Link to post
Share on other sites
Yup . . I just implemented that and it worked great! Thanks LazyJones . . the validation option was very clever!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.