tailieunhanh - Website Database Basics With PHP and MySQL

The World wide web (www) does only one thing: provide information. If you have information about something, share it with the world by building a website. As your website grows you may run into problems: 1/ Your website has so much information that visitors can't quickly find what they want. 2/ Visitors want to give you information | 1 23 - Drive safe. Website Database Basics With PHP and MySQL By Thomas Kehoe http January 11 2000 Printed from URL http Server_Side PHP DB_Basics Before the Beginning Why put a database on a website Why PHP and MySQL Reference documentation Software applications you ll need Running PHP Running MySQL Why put a database on a website The World Wide Web WWW does only one thing provide information. If you have information about something you can share it with the world by building a website. As your website grows you may run into two problems 1. Your website has so much information that visitors can t quickly find what they want. 2. Visitors want to give you information. Both of these problems can be solved by building a database on a website. My Stuttering Science Therapy Website has a page for persons who stutter to find penpals. This page became very popular. Nearly one thousand stutterers poured out their life stories wanting to share their experiences with like souls. Men women young old students attorneys nurses firefighters from all over the world. Eventually the file took the better part of an hour to download on a modem. Maintaining the webpage took too much of my time. For every stutterer s request I approved I rejected two or three requests from people who hadn t bothered to read that this webpage was for stutterers. Usually these were from teenagers. Some of these were sexually explicit. Then there were the bad e-mail addresses. AOL users didn t understand that they had to attach @ at the end of their e-mail address. I needed a database. Users would fill out neat forms listing their age location profession etc. Other users could search just for the people they wanted to meet . nursing students who stutter or young women who stutter in Ohio. Within seconds users would find just who they were looking for. The software could check if e-mail addresses were valid. Teenagers who didn