PDA

View Full Version : Smart idea or not?


-fedexer-
05-21-2008, 05:48 PM
Ok, well i am currently creating a site for a group of parents at my school, but they want to be able to make updates themselves (also easing workload for me due to studies) but they do not know anything about web design and therefore they would not be able to do it themselves.

This is where i question whether or not storing the page content in a DB would be advisable, and then they can create pages on the fly via php script, add/delete/edit pages etc... but i don't know if this is the done thing or not.

I don't know if this is done by different businesses , as if it were a common industrial method of operating?

Also i was wondering how i would get a text entry system like the ones forums have (this text area where i am currently typing) ? As it would be needed if i were to do it via storing the page data from user entry.

Thanks alot
-fedexer-

davidj
05-21-2008, 08:10 PM
you need a CMS

Joomla is a popular one (http://www.joomla.org/)

full reviews here (http://www.opensourcecms.com/index.php?option=content&task=view&id=388&Itemid=143)

-fedexer-
05-21-2008, 08:43 PM
I figured that, but i want to really do this without using a precreated CMS as i could use this as part of a portfolio when i'm older, and i feel using a CMS i would be cheating.

davidj
05-21-2008, 08:58 PM
ok

check out the tuts in my signature

-fedexer-
05-21-2008, 09:36 PM
I get PHP, i understand enough, i was just asking whether or not saving page sources into a db to then be retreived by PHP is advisable?

pete
05-21-2008, 09:50 PM
I get PHP, i understand enough, i was just asking whether or not saving page sources into a db to then be retreived by PHP is advisable?

Yes it is fine to use a DB, one advantage is that the content can be made searchable using MySQL Full Text Search or simply LIKE '%%'. You can use the free Tiny MCE editor http://tinymce.moxiecode.com/ or the FCK Editor http://www.fckeditor.net/ to create your own custom CMS.

It is also possible to just save the page as a htm file and use the above editors in your custom CMS.

While many hosts dislike Joomla and similar (resource hogs and secuirty risks) they are as Dj has stated suitable solutions and sometimes can be a better option depending on the requirements of the project.

-fedexer-
05-22-2008, 11:13 AM
Thanks Pete, and yeah i was wondering how i would have had the content searchable, but as you say, having it in the database makes life easier.