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. http://www.isitebuild.com. You can read more of his in-depth articles at: http://www.isitebuild.com
Wood Dale Chicago prom limo .. Lockport Chicago limo O’HareWhen visitors add your web site to their Favorites or... Read More
Project Safekids provides webmasters a valuable tool which could save... Read More
When web content gets discussed on webmaster bulletin boards, the... Read More
I am just a learner who likes to delve in... Read More
Your website conversion rate should concern you. This simply refers... Read More
The definition of the phrase "Content Management" depends on what... Read More
"How do I improve web site sales figures?" The CEO... Read More
Design and layout can make your communication come alive and... Read More
Your web site will be your window to the world.... Read More
This simple question can take on several different forms, but... Read More
One of the things that Internet excels is disseminating information... Read More
Succeeding with an eCommerce website is a dream for many... Read More
Many executives and investors are skeptical that software products can... Read More
Functions and Subroutines in ASP If you read... Read More
Failure, just like success, is measured differently by each and... Read More
Everyday thousands of new businesses make the leap and take... Read More
A company must earn and keep trust or sales don't... Read More
Better Web Site ROIHow to increase your business profitability by... Read More
If you like the Internet and surfing through the billions... Read More
The Internet car buyer is an elusive animal. Trying to... Read More
More and more non-profit organizations are developing websites to help... Read More
Like any area of business your website needs some effort... Read More
1. SiteSpinner V2 - On Sale www.deprice.com/sitespinner.htmSiteSpinner is a user-friendly... Read More
A professional online reputation is essential to the flourishing of... Read More
While creating a Web site may seem like... Read More
Antigo wedding limo ..The Internet has opened a whole New World of opportunity... Read More
So you want to take a look at a real... Read More
When used to describe a web site, the term "sticky"... Read More
Dance is how you pamper your soul and satiate your... Read More
A website is the most versatile and cost-effective marketing tool... Read More
The growth in Internet usage around the world is astounding... Read More
Everywhere you look these days, people are telling you that... Read More
In the region where my company is located, South Bend,... Read More
I've heard several prominent web marketers mention in their classes... Read More
When we review the sites of potential clients, there are... Read More
Webmasters deal with a myriad of complex design challenges every... Read More
Making maximum profit from your law firm website is important,... Read More
Most interactive websites nowadays require data to be presented dynamically... Read More
Writing for the web is totally different to writing for... Read More
To the starting internet entrepreneur, there is nothing more discouraging... Read More
There are hundreds of millions of Web surfers today. Each... Read More
I had a client say something to me the other... Read More
Creatively marketing your corporate site takes time in the set... Read More
One of the most important parts of establishing a new... Read More
One of the things that Internet excels is disseminating information... Read More
Web sites are an Ongoing Part of Business.All too many... Read More
Three way linking and concerns.For many years SEO experts were... Read More
I talk with so many people who have small businesses... Read More
Losing website sales and traffic is sometimes simply a case... Read More
Your business website is a critical aspect of being able... Read More
Web Development |