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

In The News:


pen paper and inkwell


cat break through


Creating Compelling Content , Write It and They Will Come

In a previous ezinearticles.com article,"I Need real visitors, Not Search... Read More

Allocating Your Web Site?s Budget Properly

I had a client say something to me the other... Read More

Growing Your Meetings In CyberSpace

As increasing numbers of people search for information on the... Read More

What ROI You Should Expect From Your Web Site

Is Your Web Site an Expense or an Investment?Why don't... Read More

Server Side Includes (SSI) with ASP

Server Side Includes (SSI) with ASP People often... Read More

Building eCommerce Websites that Work - Part 3

An interesting eCommerce success factor that isn't precisely overlooked, but... Read More

From Concept to Website

You've decided to create a website to market your products... Read More

The Internet Road Map

1) Data CaptureOne easy way to collect e-mail addresses and... Read More

From Search to Sale

The Internet car buyer is an elusive animal. Trying to... Read More

Easy Steps To Website Development and Promotion

One of the most important parts of establishing a new... Read More

Why Your Business Needs a Website

Even with the steady growth of the World Wide Web,... Read More

How to Build a Database Driven Web Site

If you ever want to create a state directory, article... Read More

Make Your Artist Website Sell!

SummaryHere's the scoop on what you must know when designing... Read More

How to Get Your Website In Front of Thousands of Customers At No Cost To You!

Dan Kennedy once said that if you can't make money... Read More

Maintaining Your Business Website

QUESTION: Should I build and maintain my business Web... Read More

How to Make Your Own Free Website in 8.5 Minutes or Less

Designing and creating your own website does not have to... Read More

Product Promoting: Getting The Response

When you publish a content site there are times when... Read More

Sticking To Your Plan

So you have a good idea for a business and... Read More

Get Your Business on the Web

I can't think of any business alive today that couldn't... Read More

FREE Amber Alert Tickers for Your Website

Project Safekids provides webmasters a valuable tool which could save... Read More

Where on Earth is Your Websitee?

You've just finished congratulating your marketing team. After six months... Read More

WYSIWYG Versus Coding: HTML With A Purpose

After years of working with entrepreneurs who developed their first... Read More

Web Content Strategy 101

Your content is what gets you in search engines, speaks... Read More

The Importance of Website Stats to You

One of the best tools you have as a webmaster... Read More

Do You Really Need A Website To Succeed

Rosalind wants to share her inspirational poetry with a wider... Read More

Top 7 Tips for Building an Antique Car Website

Like wine cars get more attractive to collectors as years... Read More

Where?s Your Web Site?

This simple question can take on several different forms, but... Read More

10 Tips For Running A Profitable Web Site

1. Address your targeted audience on your business site. Example:... Read More

How Your Own Website Helps Your Small Business Grow

What do you mean, you don't have a website for... Read More

Why Every Small Business Owner Needs Two Websites

Every small business owner knows that they need a website,... Read More

Setting Up Your First Website

Q. Hey, Cathy: I'm just setting up a website. What... Read More

12 Essential Tips to a Professional Business Website

1. Choose a big enough font size. A size 12... Read More

Bring Your Visitors Back Clamoring for More! Maintain and Improve Your Web Site Weekly - Part 1

80% of your Web site is Maintenance!Once your Web site... Read More