I need to create a very simple CMS to add/edit and remove pages. Not allowed to use a third party CMS, as it has to be created from scratch.
Just a little confused with how I should structure the DB? I only have a pageID, pageName and pageComment thus far. should I store page content in the DB ? or just a link where I can get the page contents. Also what other fields should I include?
Thanks
Simple CMS DB setup
Moderator: General Moderators
It all depends on what you're trying to do. Will you have multiple users, will the pages be sorted in any certain matter (by date, id, title, other?)...
You could start out with a pageID, pageTopic, pageContent. I tend to have additional fields such as date, category, author, type, security level, and so on, but once again, it's all up to what you're trying to achieve.
You could start out with a pageID, pageTopic, pageContent. I tend to have additional fields such as date, category, author, type, security level, and so on, but once again, it's all up to what you're trying to achieve.