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. [email protected]. You can read more of his in-depth articles at: http://www.isitebuild.com/articles

In The News:

KPS3 Hires Vivek Bhardwaj as Web Developer  Nevada Business Magazine

Web Content Strategy 101

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

The Power Is In The Pipes: How To Get Maximum Leverage From Your Website

What is the most important part of your online business?Many... Read More

MySQL Database Handling in PHP

Most interactive websites nowadays require data to be presented dynamically... Read More

3 Ways To Increase Your Websites Conversion rate

Everywhere you look these days, people are telling you that... Read More

Do Dancers Need A Website?

Dance is how you pamper your soul and satiate your... Read More

You Dont Know Which One

I still remember it very clear ... It was almost... Read More

What Does An Ex-Basketball Coach Know About Pulling Web Metrics?

In my previous life.....Actually, my previous JOB life, I was... Read More

New Years Resolutions: Is Improving Your Website One of Them?

With the New Year upon us yet again, it's time... Read More

Creating Dynamic Website Content with PHP - MySQL

Fresh website content for your visitors can be of real... Read More

Build a Web Site that Works...Even for a Safari Hobby!

My life's greatest passion is a safari hobby. And what... Read More

Building a Web Store on Shoestring Budget in less than Four Hours

Starting a business online is no longer as difficult as... Read More

The Secret Benefit Of Accessibility: Part 1 - Increased Usability

Web accessibility has so many benefits that I really do... Read More

Preventing Repeat Form Submission Using PHP Sessions

We've all seen those messages on some websites warning not... Read More

So You Want To Have A Website

So you want to have a website. You have gone... Read More

Topics to Add When Creating an Alternate and Modern Medicine Web Directory

Alternate medicine finds its own place in the hearts and... Read More

Server Stats ? Analyzing Traffic To Your Site

Analyzing traffic to a site is a key factor in... Read More

PHP Redirect

A PHP Redirect automatically transfers a web user from one... Read More

3 Rules of Website Designing and Layout

Now that you have got your domain name registered, your... Read More

Selecting a Web Content Management Product

So you want to take a look at a real... Read More

Growing Your Meetings In CyberSpace

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

Are You Being Scammed By Your Web Design Company?

This is a growing concern amongst many business owners. Does... Read More

Web Analytics - Getting it Right

Understanding and using web analytics.In recent years, website marketers were... Read More

Web Site Promotion: How To Advertise Your Website For Profits

Making money with your web site is the dream and... Read More

Your Content for Nothing and Your Clicks for Free

The first thing my business consultant (read brother-in-law) asked me,... Read More

Top 7 Tips for Building an Antique Car Website

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