| |
| |
|
Web Development Information |
|
|
|
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. 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
MORE RESOURCES:
Web-Development - Google News |
|
|
|
RELATED ARTICLES
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. Tips for Building a Great Business Website A website is lifeline of internet home business. In order to succeed you must have a website that that meets the general criteria of accepted standards. Allocating Your Web Site's Budget Properly I had a client say something to me the other day that I thought was rather interesting. He mentioned that he almost considers SEO as a marketing expense even though its really a web expense. Build It and They Will Come Build it and they will come is not always true; you have to form a relationship with the company before you will get quality attendees or participants for a free service.The key to a human's heart is through food. The Disability Discrimination Act (DDA) & Web Accessibility There's been widespread speculation about the new legislation being introduced under the DDA (Disability Discrimination Act), which will ensure that websites are accessible to blind and disabled users. Try to find specific information about it on the Internet and chances are you'll come up empty handed. 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. Be Creative Before You Purchase Or Create A Website Before you jump into spending coutnless hours on designing and publishing your website, or spending hundreds on having it done by anyone else you should plan out your full design (or structure). This is very important so that when it comes time to do this long-lasting project you will be well prepared. Entangled in the World Wide Web I am just a learner who likes to delve in websites as a hobby. Hobbies are what make life so enjoyable for me. Let Your Customers Redesign Your Website! When you purchase a new item from a Yahoo! Store, you are asked if you'd like to provide feedback on the transaction. About two weeks after the initial purchase, an email from Yahoo! Stores shows up, asking you to provide feedback for the vendor. 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. Flash Deadly Sins (That Can Kill Your Web Business) Looks like every client wants a Flash site these days but the reality is.. Having a Domain Name And Web Site Gives Your Business The Key To The Door Just like all things in life, the ways to run a business are rapidly changing and evolving. The potential involved with having a domain name/web site is staggering to say the least. Websites: You Get What You Pay For! So you finally decided to invest in a web presence or upgrade your current site? There are many available choices in "web designers" to choose from. This decision is an important one! You may have a relative or friend of a friend who will do your web site at a very low cost from the comfort of their house. Growing Your Meetings In CyberSpace As increasing numbers of people search for information on the Internet, it becomes more imperative to have a compelling Website to promote and support your meetings.Here is my list of "The Seven Most Important Things You can do Online":1. From Search to Sale The Internet car buyer is an elusive animal. Trying to hunt them down for the kill is not to be taken lightly. 4 Rock Solid Reasons For Building Your Own Website What is the point of having a website, you may ask, when the affiliate programme you have joined has provided you with your own web page to promote? This is a fair question. The answer has to be that with your own site - and of course your own domain name - you will have a lot more control over your business. 4 Marketing Tips for Resourceful Webmasters! The internet is a sea of knowledge. Getting your information to 'float' by the right audience can be like finding that one special grain of sand on the seashore. Website For The Company Store If your company own one or more stores, you might be wondering if it would be a good idea to have a website. You might also be wondering if a website for the company store would be profitable for your business. Guidelines for Web Page Optimization Below, I have listed 8 simple steps that you can take to optimize your web pages. By following these, you will improve your chances of increasing your rankings:1) Target one word for each page: A huge mistake that many beginners make is cramming numerous keywords onto every page. Your Website Should Be Selling It may come as some surprise to a traditionally off-line business that their website should be attracting new sales, or at least supporting the sales they have made. There is a common misconception that a website is more of a cost than an asset.
|
| home | site map |
| © 2006 |