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