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
If one more business owner tells me their website sucks... Read More
Many small businesses have the misconception that their business can... Read More
SummaryHere's the scoop on what you must know when designing... Read More
What to put your the website if you are an... Read More
Before you start building your site, ask yourself "WHY?". Why... Read More
The Internet is a remarkable publishing medium. With just a... Read More
When I set up my website I felt paypal was... Read More
Like any area of business your website needs some effort... Read More
Creating a content management system either from scratch,... Read More
Many small companies choose not to invest in a professionally... Read More
The first step in setting up an online business...Starting an... Read More
After planning the design and content of your website, it's... Read More
--------------------------------Why Should You Create a website?--------------------------------A. What do you want... Read More
Wow, we`ve already taken a domain and chosen a web... Read More
Go to any internet marketing forum you want these days... Read More
Although designing a great web site is an important part... Read More
Yahoo has long offered email, an online calendar, notes, bookmarks,... Read More
2 Golden Rules for an Engaging Website35% of visitors fail... Read More
When building a relationship, listening is more important than talking.A... Read More
The needs of screen magnifier users are overlooked when implementing... Read More
If you're anything like most small business owners, you probably... Read More
When you consider the billions of individuals and companies on... Read More
Profiles are one of the best kept secrets around regarding... Read More
Does My Web Site Require A Web Database?If your web... Read More
D.zigns dzignerwebs The Basics Before starting on... Read More
Making maximum profit from your law firm website is important,... Read More
If you're anything like most small business owners, you probably... Read More
Internet has opened a whole new world for web developers... Read More
When you started reading this sentence you assumed lo acabar?a... Read More
Web sites are an Ongoing Part of Business.All too many... Read More
One of the best tools you have as a webmaster... Read More
A website is the most versatile and cost-effective marketing tool... Read More
The Internet has opened a whole New World of opportunity... Read More
Creating a content management system either from scratch,... Read More
The DDA (Disability Discrimination Act) states that service providers must... Read More
Is your website Really useful?I had a 'rep' in yesterday... Read More
Spend time planning your Web site. Before you design a... Read More
Have you ever thought the secret behind the success of... Read More
80% of your Web site is Maintenance!Once your Web site... Read More
"Don't Sell the Steak, Sell the Sizzle."Have you heard of... Read More
Making a web site is easy. Making a good web... Read More
Every online entrepreneur I talk to is asking the same... Read More
First, an eye opener. Making your fortune through affiliate programs... Read More
QUESTION: Should I build and maintain my business Web... Read More
No matter the size of your business, having a web... Read More
Many websites I come across don't have a single link... Read More
How popular is online shopping? And is there room for... Read More
1) Data CaptureOne easy way to collect e-mail addresses and... Read More
"I have a small business with just a couple of... Read More
There are millions and millions of websites on the Internet.... Read More
Web Development |