Thread: Online Updation
View Single Post
  #9 (permalink)  
Old September 23rd, 2004, 12:14 AM
madhukp madhukp is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Cochin, Kerala, India.
Posts: 463
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to madhukp
Default

IMO, database is more suitable for content management.

You can use XML also. But you have to decide the methods very clearly. You have to define XML format very clearly and then design parser according to it. In future when the client requirements changes, you may have to modify both XML format and parser.

Using database
--------------
You can have a table for storing the contents of pages. One page may itself have more than one "dynamic" portions. You need one record for each such section. An approx. design for this table will be

PageID primary auto-increment
PageName varchar(50)
DynamicSectionName varchar(50)
Content Text

You need a WYSIWYG editor to help admin users edit the content without the knowledge of HTML. There are many such editors available online.
Reply With Quote