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 a previous ezinearticles.com article,"I Need real visitors, Not Search... Read More
I had a client say something to me the other... Read More
As increasing numbers of people search for information on the... Read More
Is Your Web Site an Expense or an Investment?Why don't... Read More
Server Side Includes (SSI) with ASP People often... Read More
An interesting eCommerce success factor that isn't precisely overlooked, but... Read More
You've decided to create a website to market your products... Read More
1) Data CaptureOne easy way to collect e-mail addresses and... Read More
The Internet car buyer is an elusive animal. Trying to... Read More
One of the most important parts of establishing a new... Read More
Even with the steady growth of the World Wide Web,... Read More
If you ever want to create a state directory, article... Read More
SummaryHere's the scoop on what you must know when designing... Read More
Dan Kennedy once said that if you can't make money... Read More
QUESTION: Should I build and maintain my business Web... Read More
Designing and creating your own website does not have to... Read More
When you publish a content site there are times when... Read More
So you have a good idea for a business and... Read More
I can't think of any business alive today that couldn't... Read More
Project Safekids provides webmasters a valuable tool which could save... Read More
You've just finished congratulating your marketing team. After six months... Read More
After years of working with entrepreneurs who developed their first... Read More
Your content is what gets you in search engines, speaks... Read More
One of the best tools you have as a webmaster... Read More
Rosalind wants to share her inspirational poetry with a wider... Read More
Like wine cars get more attractive to collectors as years... Read More
This simple question can take on several different forms, but... Read More
1. Address your targeted audience on your business site. Example:... Read More
What do you mean, you don't have a website for... Read More
Every small business owner knows that they need a website,... Read More
Q. Hey, Cathy: I'm just setting up a website. What... Read More
1. Choose a big enough font size. A size 12... Read More
80% of your Web site is Maintenance!Once your Web site... Read More


Website, website, website, everyone says you need one. But do... Read More
If you're fairly new to the Internet scene, you may... Read More
Your site is fast and getting traffic, but conversion rates... Read More
I'm one of those people that always wanted a website,... Read More
Optimal website design is the art of logical navigation.It will... Read More
Starting and maintaining a business is challenging enough without the... Read More
Conceptualize, Build and Publish a Web site - What's required... Read More
The definition of the phrase "Content Management" depends on what... Read More
The Internet has opened a whole New World of opportunity... Read More
You've put up a website to promote a product or... Read More
An interesting eCommerce success factor that isn't precisely overlooked, but... Read More
Although there are significant differences among the various types of... Read More
1) Word of Mouth The single most powerful form of... Read More
A website is lifeline of internet home business. In order... Read More
Better Web Site ROIHow to increase your business profitability by... Read More
--------------------------------Why Should You Create a website?--------------------------------A. What do you want... Read More
A common dilemma most small and medium businesses face when... Read More
Creating a content management system either from scratch,... Read More
If you are developing your website on a host that... Read More
A professional online reputation is essential to the flourishing of... Read More
Directory Generator, a product from Armand Morin and Marc Quarles,... Read More
Making a web site is easy. Making a good web... Read More
Creating and maintaining an effective presence on the Web has... Read More
Today it seems everyone is jumping on the entrepreneur bandwagon,... Read More
Thinking about starting up a business? The web is the... Read More
Many executives and investors are skeptical that software products can... Read More
Everyone wants one.Everyone wishes they knew how to make one.SOME... Read More
Affiliate programs are a great way to earn an income... Read More
Thousands of people are now making a living online and... Read More
There are several reverse bid freelance sites out there. Beyond... Read More
Webmaster tools are vital to becoming both efficient and effective... Read More
Web sites are an Ongoing Part of Business.All too many... Read More
A website is the most versatile and cost-effective marketing tool... Read More
Web Development |