Database Driven Contents

[Stefano Mtangoo]

Don't get me wrong, I don't ignore the power behind CMSes.
I want to make a Database driven contents. Here is the approach I want to take, correct me/Add opinion as you it!

1. Integrate TinyMCE editor for wariting contents (WYSIWYG)
2. Have database with table contents and three columns (ID, heading, contents)
3. Feed heading and contents to table
4. Display contents by querying the DB for data using a php script

Is it right approach?
Any suggestion/modifications?

Thanks :)

[diafol]

Yep, that's about the size of it.

I'd put the TinyMCE widget to just control the 'content' part. Use a normal textbox for 'heading'. I would suggest that you add 'description' and 'updated_date' fields (and textarea + textbox to the form) so that you can keep track of the various records. I find TinyMCE pretty 'heavy' for most apps. There are many other text editors out there. Spaw2 is quite small as is the Yahoo! version. I like Spaw2 due to the file uploading feature.

[Stefano Mtangoo]

Thanks alot.
I will incorporate your Ideas. They are great!
Thanks