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

---

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

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

Developing State-enabled Applications With PHP

Installment 1Developing State-enabled Applications With PHPWhen a user is browsing... Read More

12 Tips To Great Websites

Why do some sites succeed while the vast majority of... Read More

7 Questions to Understand Your Customer Better

Customer service questionnaires can help your clients better understand their... Read More

Are You Overlooking the Benefits of Using Sub-Domains within Your Web-hosting account?

One of the most useful features offered by some web... Read More

Do Authors Need a Website?

"I am a writer, not a business-person. I don't want... Read More

Three Way Linking - Webmaster Strategy

Three way linking and concerns.For many years SEO experts were... Read More

Setting Up Your First Website

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

You Need To Treat Your Website Like An Employee - Heres 5 Ways To Do It

People often come to me in a state of crisis... Read More

Do You And Your Website Have Credibility?

I recently received an unsolicited e-mail from some company offering... Read More

The Problem with Paypal On Your Web Page

When I set up my website I felt paypal was... Read More

If Its Done Its Done for: Make Your Website Part of Your Business before You Build

Web sites are an Ongoing Part of Business.All too many... Read More

Build a Strong Foundation for Creating Your First Online Identity ? Notes for Beginners

If you are looking for creating your online presence you... Read More

Warning: The Truth About Having a Web Site!

If you don't have a web site yet, are thinking... Read More

The Number 1 Reason Most Websites Fail

Failure, just like success, is measured differently by each and... Read More

How to Increase Sales with Automation Improvements

How popular is online shopping? And is there room for... Read More

Web Accessibility: The Basics

What is web accessibility & why is it important?Web accessibility... Read More

Ebooks for Webmasters

Internet has opened a whole new world for web developers... Read More

Conceptualize, Build and Publish a Web site

Conceptualize, Build and Publish a Web site - What's required... Read More

Why Your Business Needs a Website

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

3 Ways To Increase Your Websites Conversion rate

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

How to Promote Your Law Firm Website On the Internet for Maximum Profit

Making maximum profit from your law firm website is important,... Read More

7 Profit Producing Reasons Why Every Successful Service Professional Needs A Web Presence

Your business website is a critical aspect of being able... Read More

Get a Website!, Register Your Domain!: To Website or Not to Website?

If you're fairly new to the Internet scene, you may... Read More

Frequent Business Question: How Do You Start a Web Business?

Today it seems everyone is jumping on the entrepreneur bandwagon,... Read More

Why a CSS Website Layout Will Make You Money

Although CSS layouts have been around for years, they haven't... Read More

How Improving Your Sites Usability Can Increase Your Buyers by 40% and Boost Each Order By 10%!

With all of the factors involved in designing and building... 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

Search Engines and Customers Want Focused Web Site Content

How do you decide on the content, products and or... Read More

The Internet Road Map

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

KISS Your Website!

Many web developers today are starting to KISS their website,... Read More

Having a Domain Name And Web Site Gives Your Business The Key To The Door

Just like all things in life, the ways to run... Read More

Websites for Writers ? Why You Need One and How to Get Started Today

It may seem like the publishing industry's equivalent of Beanie... Read More