Solarpitch Posted October 17, 2006 Share Posted October 17, 2006 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. Link to comment https://forums.phpfreaks.com/topic/24254-being-able-to-moderate-submitted-entries/ Share on other sites More sharing options...
hostfreak Posted October 17, 2006 Share Posted October 17, 2006 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. Link to comment https://forums.phpfreaks.com/topic/24254-being-able-to-moderate-submitted-entries/#findComment-110244 Share on other sites More sharing options...
LazyJones Posted October 17, 2006 Share Posted October 17, 2006 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. Link to comment https://forums.phpfreaks.com/topic/24254-being-able-to-moderate-submitted-entries/#findComment-110246 Share on other sites More sharing options...
hostfreak Posted October 17, 2006 Share Posted October 17, 2006 ^ah didn't even think about that. Good idea. Link to comment https://forums.phpfreaks.com/topic/24254-being-able-to-moderate-submitted-entries/#findComment-110247 Share on other sites More sharing options...
Solarpitch Posted October 17, 2006 Author Share Posted October 17, 2006 Thanks guys! I cant believe i didnt think of that . . . so simple! Sometimes the answer is right under yout nose! :)Cheers! Link to comment https://forums.phpfreaks.com/topic/24254-being-able-to-moderate-submitted-entries/#findComment-110249 Share on other sites More sharing options...
Solarpitch Posted October 17, 2006 Author Share Posted October 17, 2006 Yup . . I just implemented that and it worked great! Thanks LazyJones . . the validation option was very clever! Link to comment https://forums.phpfreaks.com/topic/24254-being-able-to-moderate-submitted-entries/#findComment-110284 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.