How To Build A Database Driven Web Site
|
|
If you ever want to create a state directory, articledirectory, dating site or link directory, you need to know aboutcreating database driven web sites. This may seem like adaunting task at first, if you have never done it, howeverI was in the same boat as you. It is not as difficult asyou think.
Benefits of building database driven web sites
-Store vast amounts of information about your products orservices.
-Efficient data sorting and retrieval
-Complex queries and statistical analysis performed relativelyeasily
-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 recordswithout 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 webpages.
-Site maintenance greatly reduced.
-Enhance web interactivity
Requirements
MySQL - to retrieve information from a database, you firstneed 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 PHPinstalled, your Web server will be able to read a new file(called a "PHP script") that can retrieve information instantlyfrom a database and insert it into a web page before sendingit to the browser that requested it. PHP is completely free todownload and use.
Check with your current Web host. Make sure they havealready 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 mySQLdatabase and the WSN Links Script (a PHP script). Here's anexample of the "Colorado Business Directory Site" that wasbuilt, based on following the 7 steps below:
http://www.hereiscolorado.com
1. Check that your web host has PHP 4.10+ (or PHP 5) andMySQL 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 databaseinstallation 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 themto 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 newpages, links etc can now easily be accomplished.
Congratulations!... you successfully have built yourself adatabase driven web site.
Herman Drost is the Certified Internet Webmaster (CIW)owner and author of http://www.iSiteBuild.com AffordableWeb Site Design and Web Hosting. Subscribe to his "Marketing Tips" newsletter for more original articles.subscribe@isitebuild.com. You can read more of hisin-depth articles at: http://www.isitebuild.com/articles
|
|
|
Created & Maintained by Empower! CMS Web Sites
Host2Sell Web Hosting | Emarketing Workshops | Site SEO Review | FREE NewsletterPlanning A Usable Website: A Three-step Guide
A website is like an information flow, with you as the provider and your site visitors as the receivers of the information....(related: Web Development)
Let Marketing Manage Your Website Content
The definition of the phrase "Content Management" depends on what the organization may need or a vendor may offer. There is no general purpose or standard content management system that can satisfy today's diverse business needs across the board. And so, factors for successfully implementing a content management system vary depending on individual business needs.Conducting a thorough assessment of an organization's specific business application or processes prior to installation is one of the keys to implementing a successful content management system. T...(related: Web Development)
Do You And Your Website Have Credibility?
I recently received an unsolicited e-mail from some company offering me their search engine optimization services for $199. Even though I had absolutely no interest in the offer, just out of curiosity, I decided to check out this company with the various search engines.Incredibly, they were nowhere to be found! I couldn't find them on Google, Yahoo, Dogpile, anywhere! That's because they didn't really exist. They never did. They were just another on...(related: Web Development)
How To Evaluate Your Web Sites Performance
Setting up a website is the very first step of an Internet marketing campaign, and the success or failure of your site depends greatly on how specifically you have defined yourweb site goals.If you don't know what you want your site to accomplish, it will most likely fail to accomplish anything.Without g...(related: Web Development)
Your Website Reflects Your Business
Some left shoes are in isle 5, while the right shoes are in isle 3. Shoe hills are in random places. You can barely walk through the store without stumbling over a shoe.No employees are in sight. As you are desperate for help, you finally make it past the heaping hill of shoes to the back of the store and find a button that says "Page for Help". You press the button and out comes a card that says "please leave your mailing address, we'll send you a letter". Frustrated, you leave the store, and finally realize there is a Footlocker across the street.We all know how first impressions can make or break a potent...(related: Web Development)
In Business? 10 Reasons Why You Need A Website -- Now!
1) Word of Mouth The single most powerful form of new business creation is word of mouth. Your past customers, friends, acquaintances and staff aren't likely to carry your brochure or even your business card everywhere they go. The can however carry your domain name, in their heads! Every time they have a conversation that leads to your kind of business they j...(related: Web Development)
Tell Me What Your Website Does!
You know exactly what your organisation does and what your website offers its users. This information has probably become second nature to you, but first-time visitors to your site won't know this. As such, make sure you don't forget to tell them what you do.As soon as new site visitors arrive at y...(related: Web Development)
User Interface Design: Key To Achieve Best Web Development
From early days of www, the Internet sites that are added day by day are increasing tremendously. When you will consider this pool of web, may be they are about computers, industry, entertainment, search engines, fashion, organizational or even individual, all of these sites are concerned about one major part of web development apart from the logic or programming efforts behind it is 'User Interface Design'.Any web site will gain your interest by its appearance in front of you as well as eas...(related: Web Development)
Flash Deadly Sins (that Can Kill Your Web Business)
Looks like every client wants a Flash site these days but the reality is...as flashy as these sites may look, there are many negatives you may want to consider before delving into Flash.Deadly Sin One - Long Load TimesThis is the most obvious problem with most Flash sites. Flash files can get large in a hurry and if the page takes too long to load, your visitor will move on without even seeing your site. Ideally, you would want your Flash web page to load just as fast as a 'regular' page with text and images. And yes, it can be done!Problem #1 - ImagesThe whole reason why Flash was developed was to be able to use vector graphics on web ...(related: Web Development)
Instant Relevant Web Site Content - No Its Not A Bot
In about the Time it takes to Watch a Reality TV Show (About 1 Hour) I added 10 Pages of Relevant Content to my Web Page without a Bot.Adding content to your Page Fast is Easy with the Use of Free Articles you Can Reprint. The Advantages of using Reprinted Articles1. Dynamic Relevant Content Fast (Search Engines Love Content)
2. Reciprocal Links To You (See Step 6 Thank the Author)
3. Great Way to Promote an On or Off Line Business
4. People Friendly Content
5. Well Written Professional Content1 - What Do You Want to Promote
The First thing you need to Do is Decide what you Want to Promote. In this Example we are Promoting a Pre Launch of aHome Based Business ...(related: Web Development)
How To Make Your Website More Successful? (part I)
Building a website and getting it online is easy. Driving visitors to it is the more difficult part. Most people are not patient enough when it comes to build up traffic. They expect thousands of visitors a week after they go live with their website. But that is not how it works. We share some secrets of how to make your website more successful.A) Provide content: Search engines love content. As...(related: Web Development)
The Road To Better Results
A lot has changed in the way sites are optimized for search engines since last year. For one thing, Google is not the only search engine worth looking into anymore; Yahoo has definitely managed to take away some of Google's oomph over the past twelve months. Another important change is that the intelligence...(related: Web Development)
site-map - Copyright © 2006 Empower! Web Design | All Rights Reserved. | Web Development