How to Build a Database Driven Web Site

If you ever want to create a state directory, article directory, dating site or link directory, you need to know about creating database driven web sites. This may seem like a daunting task at first, if you have never done it, however I was in the same boat as you. It is not as difficult as you think.

Benefits of building database driven web sites

-Store vast amounts of information about your products or services.

-Efficient data sorting and retrieval

-Complex queries and statistical analysis performed relatively easily

-Separate site design from site's content

-Create new pages on the fly without manually creating or editing new web pages

-Makes it easy for client to post content, update records without the need to know html or rely on a web developer.

-Advanced search capabilities

-Attract repeat visitors with fresh and constantly updated content.

-Update site information online without the need to upload web pages.

-Site maintenance greatly reduced.

-Enhance web interactivity

Requirements

MySQL - to retrieve information from a database, you first need to have a database. That's where MySQL comes in. MySQL is a relational database management system, or RDBMS. It's a software package that is very good at organizing and managing large amounts of information. MySQL also makes that information readily accessible by using a server-side scripting language like PHP.

PHP - this is a server-side scripting language. With PHP installed, your Web server will be able to read a new file (called a "PHP script") that can retrieve information instantly from a database and insert it into a web page before sending it to the browser that requested it. PHP is completely free to download and use.

Check with your current Web host. Make sure they have already installed MySQL and PHP on your Web server. Most web hosting companies already have it installed. If not find a web host that provides this service.

Steps to building a database driven web site:

You will be building a link directory site using a mySQL database and the WSN Links Script (a PHP script). Here's an example of the "Colorado Business Directory Site" that was built, based on following the 7 steps below:

http://www.hereiscolorado.com

1. Check that your web host has PHP 4.10+ (or PHP 5) and MySQL 3+ installed on the server.

2. To create the mySQL database on the web server:

-login to the cpanel of your server ie domainname/cpanel with your user name and password.
-click on 'MySQL Databases' icon.
-enter database name
-click 'add db'
-click on 'go back'
-under 'Users' enter user name and password for database
-click 'add user'
-click on 'go back'
-click on 'add user to database'

You should now get the reply that your database installation was successful.

3. Download the PHP script files to your desktop at: WSN links - http://www.isitebuild.com/cgi-bin/a/t.cgi?wsnlinks

4. Extract files from the ZIP folder and save them to a folder on your computer.

5. Upload all the extracted files to your hosting space

6. Set the correct permissions for your files.

7. To complete the installation and to customize the script, read the manual at:

http://www.isitebuild.com/cgi-bin/a/t.cgi?wsnlinks

You can continue to customize or edit your site online by accessing the admin panel within your web site.

Adding, sorting, retrieving, searching data, creating new pages, links etc can now easily be accomplished.

Congratulations!... you successfully have built yourself a database driven web site.

Herman Drost is the Certified Internet Webmaster (CIW) owner and author of http://www.iSiteBuild.com Affordable Web Site Design and Web Hosting. Subscribe to his ?Marketing Tips? newsletter for more original articles. subscribe@isitebuild.com. You can read more of his in-depth articles at: http://www.isitebuild.com/articles

More Web Development Articles

9 Keys to an Effective Website
Many small companies choose not to invest in a professionally designed website, although a well-designed Web site may raise the company's level of professionalism and exposure ? AND drive business and sales!Make sure your website is working for you with the following characteristics:Usability enables your users to get the most out of your site. This means that the site's navigation is consistent, clear and easy to follow; forms and links are in working order; and the information on the site is current and answers incoming clients' potential questions.

A Web Site for Your Small Business: How to Set Up a Website
Your web site will be your window to the world. Even if you are not selling any product online still you need your customers to access you 24 hours a day 365 days in a year and you can pass important information to them by hosting frequently asked pages, product descriptions, product improvements etc.

How to Increase Sales with Automation Improvements
How popular is online shopping? And is there room for improvement? Let?s check out some pros and cons of automated shopping and see.Digital carts offer convenience for people around the globe 24 hours a day.

Now You Have a Web Site - Have You Ever Heard of Accessibility?
An accessible Web site is easily approached, easily understood, and useable for all. There are accessibility standards set forth by the World Wide Web Consortium, which all sites should adhere to as much as possible.

How To Convert More Sales On Your Website
One of the biggest mistakes that most online retailers make is they do not take into account typical buyer behaviour. The conversion from real world to online provides many benefits to the retailer, but present some real challenges for the customer because their buying decision is made more difficult in an online environment.

The Cost Of A Web Site
Just starting out, you can start with a simple informational site, which is all most need initially, and build up to a fuller site (e-commerce and/or interactive) when you can afford it.Your goal should be to get an online presence.

7 Reasons Why Your Small Business Needs A Web Site
Many small businesses have the misconception that their business can not benefit from a website; that websites are too expensive or that because they don?t use a computer neither do their potential clients. Here are 7 reasons why your small business NEEDS a website:1.

Guide to Internet Business - Website Setup
After planning the design and content of your website, it's time to actually physically set up your website. This is the step where you put all your designs and plans into action, creating a website that will attract visitors and earn income.

So You Want To Have A Website
So you want to have a website. You have gone on to the internet and surfed but you have no idea what developing a website involves.

Getting a Web Site Can Be Fast, Easy, and Inexpensive When You Know Your Options
So what do you do if need to get a web site but you're not sure how to go about getting one. The good news is you have several options.