|
|
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
The Problem with Automated Accessibility Testing Tools
An automated accessibility tool is a piece of software which can test a web page, or even an entire website, for accessibility. Automated accessibility tools are useful because they can save you a huge amount of time. Don't want to check images for alt text on each and every page on your website? Run the site through an automated tester and it'll do it all for you!
Ten Major Tips to Develop a Multilingual Web Site to Work
If you are living in a country that its native language is something rather than English language, then you may like to develop your website to offer content in the language of your own country.
Profitable Websites for Exclusive Industries
In the region where my company is located, South Bend, Indiana, the demand for web design and associated services could be described as: leery. It's not that the locale is horribly lacking evolvement technologically; rather that so many proprietors in this area are very uncertain as to what the internet can do and how they can go about forming profitable web sites for their exclusive industries.
You Need a Website!
No matter the size of your business, having a web site is a low cost way to market your services and products twenty-four hours a day. Web sites are a constant advertisement for your business and will help you reach your targeted customers effectively. Your business will not be able to compete without a well-designed web site. There are several key elements to consider when you make the decision to start a new web site:
Websites for Writers ? Why You Need One and How to Get Started Today
It may seem like the publishing industry's equivalent of Beanie Baby madness- everyone is talking about writer's websites. Freelancers and authors everywhere are jumping on the bandwagon, publishing sites to promote themselves and their work. This craze leaves many writers wondering if it's just a fad or if it's really worth the expense and effort. While it may seem like an overwhelming or frivolous endeavor, there are some solid business reasons why you should consider setting up your own website.
PIM Team Case Study: Creating Text Effects With PHP and GD
See how you can create graphic effects on text with PHP and GD - drop shadows, arcs, fonts and colors.
Create Huge Income From Your Web Site - 10 Easy Ways
The cost of setting up a web site is dirt cheap nowadays. You can register a domain for less than $2.00 as I write this (for .info domains). Hosting is also very cheap, and getting cheaper all the time.
Building a Great Intranet Taxonomy
While it may seem like a "quick and easy" task, defining the navigation structure and organization of your intranet site will be one of the most challenging tasks you will face in the course of your project. It is also one of the most critical success factors. The site structure, also referred to as the information architecture or taxonomy, is the foundation of your intranet. Creating an effective taxonomy is as much an art as it is a science. Use the wrong terms and your users won't be able to navigate by intuition. Make your site too deep and they will never find the content they're looking for.
Get a Website!, Register Your Domain!: To Website or Not to Website?
If you're fairly new to the Internet scene, you may just be a bit overhelmed with family members, friends, collegues, and advertisements urging you to get your own website for your business. Typically, this is good advice for businesses. However, for most small local businesses, running your own website may not be the best idea. Here's why:
Whats Your Business Online Attitude?
This article was prompted by some customer support work I was involved in for a private members site. One of the paid subscription members wanted someone to look over his website and give an opinion of what we thought of its design.
Benefits Of An Accessible Website: Part 2 - The Business Case
The DDA (Disability Discrimination Act) states that service providers must not discriminate against disabled people. A website is regarded as a service and therefore falls under this law, and as such must be made accessible to everyone.
A Beginners Guide to Server Side Includes
An Introduction to Server Side Includes
5 Essential Traits Of A Home Business Website
So you've decided to start an online work at home business and are just beginning to build your website. You probably have a million different ideas for what you want the site to look like. You will want to take into consideration that your idea of a great website may differ drastically from what a website designed to make sales should be like.
How to Increase Sales with Automation Improvements
How popular is online shopping? And is there room for improvement? Let's check out some pros and cons of automated shopping and see.
Building Websites with Directory Generator
Directory Generator, a product from Armand Morin and Marc Quarles, builds directory-style websites for you in a matter of minutes. It is simple to use, it's reliable, it does what it claims to do. The tool is essentially a push-button site builder - all you really have to do is upload the generated pages to your host system. There are no fancy technical skills involved.
Adding Word Rich Content to Your Website
You have permission to publish this article electronically, in print, in your ebook or on your web site, free of charge, as long as the author bylines are included.
From Concept to Website
You've decided to create a website to market your products or services. More and more people start their information searches online, so having a website is the logical next step. But without web development skills or knowledge, how do you build and market a website?
I Did It: Six Months to a Successful Website
For years now I've been looking to start my own business, but my highest priority has always been to spend less time working, and more time with my family, while still giving them everything they need (and most of what they want). It's a common dream, right? No boss to answer to, less stress, more vacation, more quality family time... I wanted to get away from the 9 to 5 and the traffic. (I bet you do, too.)
Is Your Website Innovative? Increase Your Business Over Night!
While studying online for IT investment opportunities, I found that one main factor was constant. All of the biggest money makers have eye-catching, simple, innovative, and the cleanest websites online!
Website Development: Become Your Own Expert
Starting and maintaining a business is challenging enough without the additional financial burden of hiring a web site expert to put your vision on paper. If you are starting your business on a "shoe string budget," hiring someone to take your written materials to type in a basic format, add a few pictures and edit what you tell them periodically may not be sound money management.