Pending and Approval process

Posted by zen on Programmers See other posts from Programmers or by zen
Published on 2012-07-09T19:24:49Z Indexed on 2012/07/09 21:22 UTC
Read the original article Hit count: 198

So let's say I have a DB table with 8 columns, one is a unique auto-incrementing used as ID. So I have a page that pulls in the info for each row based on query string ID. I want to give my users the ability to propose changes. Kinda like a wiki setup. So I was thinking I should just have another duplicate table or maybe database altogether (without the auto-incrementing column and maybe with a date edited column) that keeps all proposed changes in queue and then when I approve them, the script can move the row from the proposed DB to the real DB.

Does this sound good or is there a better process for this?

© Programmers or respective owner

Related posts about web-development

Related posts about programming-practices