cms problem

ringo747 · 18 Dec 2006 at 22:12

hi,

im implementing a cms at the moment for a uni project...i have to include a feature for adding articles whereby the user can view a preview of the article before confirming to submit it. Would the best way to do this be to insert all the data into a temporary database table and then view it from there.. then click on submit to copy the article into the proper table?

Any ideas on this would be welcome.

Thanks
Jonny

Stretch · 19 Dec 2006 at 11:56

No, I'd insert the data into the "proper" table and set a status flag on the row to specify whether or not the article is live. Saves a lot of time, copying and temporary tables. You can then have a publishing page allowing the user to select which articles they wish to publish.

ringo747 · 19 Dec 2006 at 12:41

never thought of that! I will also be specifying an activation time for each article so I guess the two could work well together

Thanks for the info

Pr0t0c0L · 20 Dec 2006 at 14:00

add a draft/publish attribute to your arcticle, and make sure your display page on the front end displays all published articles etc