Continued from page 1
The content management system also would allow you to add, edit or remove content from your site without editing many webpages. You'd simply have separate pages setup which allow you to edit information stored in database.
Why Do I Want To Do This? -------------------------
There are many reasons to use a database-driven content management system as opposed to many static webpages. Several are:
1. Easier To Change Site Design
With a database-driven site, there is really only one webpage. The content of site is inserted into this page dynamically when it is requested based on information passed to page (such as article number).
This means changing look of entire site can be as easy as changing HTML in that one page. The page would contain both HTML and programming code for whatever language you chose.
2. Easier To Update Your Site
Using a database-driven content system, you no longer have to create a separate webpage for each piece of content you want on your site. By setting up a form which submits information to add to your database, you can update site just by copying and pasting a piece of content into form, and adding it to database. If you write site to take articles based on date, for example, new content could appear immediately on your site.
How Do I Create a Content Management System? --------------------------------------------
Here are several places you can learn about building a database- driven website, specifically with PHP and mySQL:
WebMonkey's PHP Programming section has many well-written articles and tutorials dealing with both PHP programming and interacting with mySQL. They even have a "PHP/mySQL Tutorial."
WebMonkey's Backend Databases section includes information about choosing a database system, an introduction to databases, several tutorials and more.
The Web Developer's Virtual Library has several good tutorials and information about PHP language and how to use it in conjunction with mySQL databases.
There are many uses of databases in websites, and a content management system is just one of them. Hopefully this article has informed you on exactly what a database is and has provided you with several links to good starting points for those who are interested in using a database in their site.
Dan Grossman runs http://www.websitegoodies.com where you can find over 250 hand-picked resources, articles, and tools! Dan also publishes the free weekly "WebDevPortal" newsletter for website owners! Subscribe today and get articles like this every week: mailto:firstname.lastname@example.org?subject=article-subscribe