The School for Champions is an educational website that shows you how to achieve your dreams.
|
|
|
SfC Home > Web Design > Explanation of database-driven websites. Also refer to dynamic web page, e-commerce, e-learning, Microsoft SQL Server, MySQL, Access, PHP, ColdFusion, ASP, Active Server Pages, JSP, Perl, Ron Kurtus, School for Champions. Copyright © Restrictions Database-Driven Websitesby Ron Kurtus (revised 12 May 2008) A database-driven website allows some of its content to be accessed from a database and displayed dynamically. Updating web pages is then done through updating the database. It also allows users to perform such operations as sorting on the page. Dynamic pages are useful in e-commerce for displaying product catalogs and in e-learning to show class material. MySQL and Microsoft SQL server are common databases used. PHP, ASP and ColdFusion are common languages used to access the database information and display it on the web pages. Questions you may have include:
This lesson will answer those questions. There is a mini-quiz near the end of the lesson. Database-driven websiteThe typical website consists of a set of individual web pages, connected to each other or to a table of contents page through the use of hyperlinks. Updating data must be done on the individual pages. When the site consists of a large number of web pages—especially if they change often—updating individual pages can become overwhelming. This can be seen for an e-commerce site, displaying a catalog of products. The solution to this problem is to put the information in database tables and then access and display that information into select areas of a web page template. This has the advantage in that the owner of the data only needs to update the database and not worry about updating individual web pages. ApplicationsDatabase-driven web sites have numerous applications and possibilities. e-CommerceCommercial websites can display information on a large catalog of products, including pictures and documentation by locating the material in a database have accessing it dynamically on the web pages. A company doing e-commerce can have all their goods for sale in a database on their web server. When a customer accesses the web site and asks for information on a specific type of product, a web page will display the information desired. This is how many search engines work, but the capabilities in this case are greater, because the information can be formatted in other ways that a simple list. When new products are introduced or information on them changes, only the database needs to be updated. e-LearningWhen a student accesses an online course, he or she may be able to selected the level or the type of information needed. Since the course material is in a database, only what is requested will be displayed. Also, updating the education or training material can be done without having to worry about HTML coding issues. The information is simply put in the database. Database and softwareThere are a number of database and software solutions to having data-driven web sites. DatabaseTypical databases used in dynamic websites are:
Individuals who want to have database-driven material in their websites can use their own copy of the Microsoft Access database. Unfortunately, Access is limited and does not work well if several people want to access the database information at the same time. Most large companies use the Microsoft SQL Server database. MySQL is the most popular database, because it almost has the power of Microsoft SQL Server but has the advantage of being free or costing very little. PHP and ColdFusion are typically used with MySQL databases. Programming languagesCommon web programming languages used to access database information are:
PHP is the most popular, especially since it is free. It is often paired with the MySQL database. Most larger businesses use ASP paired with the MS SQL Server database. ColdFusion is the easiest to program and maintain, but your Internet host must have a ColdFusion server and usually charges extra for the service. It can be used with Access, MySQL or SQL Server databases. (See ColdFusion Development for more information.) JSP and Perl are also used in some dynamic websites. SummaryA database-driven website allows content to be accessed from a database and displayed dynamically. Pages are then updated through the database. Dynamic pages are useful in e-commerce and in e-learning. MySQL and Microsoft SQL server are common databases used. PHP, ASP and ColdFusion are common languages used to access the database information and display it on the web pages. Be aware of what is happening around you ResourcesThe following resources provide information on this subject: WebsitesBooks
Top-rated books on Website Design MiscellaneousMini-quiz to check your understanding1. What is an advantage of a database-driven website? 2. How can an e-commerce site effectively use dynamic pages? 3. What is the main reason My SQL and PHP are used in many database-driven sites? If you got all three correct, you are on your way to becoming a Champion in Web Design. If you had problems, you had better look over the material again. What do you think?Do you have any questions, comments, or opinions on this subject? If so, send an email with your feedback. We will try to get back to you as soon as possible. Share linkFeel free to establish a link from your website to pages in this site. 
Or use our form to send this link to yourself or a friend. Students and researchersThe Web address of this page is Please include it as a reference in your report, document, or thesis. Where can you go from here?
|
The School for Champions helps you become the type of person that can be can be called a Champion.
