MYSQL Databases - Why you need it!
Database Reasons
What is such a database and what can you use it for on your web site? Basically, a database is used to quickly store and later retrieve structured data. Data is stored in tables. On web sites it is used to store users with their names, passwords, preferences etc. If you are tracking links to and from your site you may want to store them in a links table. You could store all this information in text files and in the early days of the internet, this was the case. Scripts for guest books and the like would not rely on a mysql database but directly update an HTML file instead. This sort of works for a guest book with a few dozen entries but is not suitable for a message board or customer management system with potentially thousands of entries.
Typically the database is accessed by a script installed on your web server. These scripts may be written in perl or php. You can write such scripts yourself or install ready-to-go solutions which you only configure to suit your needs. Often your web hosting company will provide such scripts preinstalled.
But even if you have only one mysql database, you can install several such packages. E.g. your customer management system could be using tables in mysql with table names customers, purchases, correspondence.
Your advertising campaign might be using tables etc.
Further on you could use the mysql database to keep track of visitors that were referred from external web sites like search engines or discussion boards. You could store all your referral urls in a table called referring URLs.
Good Enough?
With out databases there is no way to dynamically create or store data fast efficiently or easily.
This is where we come in and are able to create something as simple as a way to modify and maintain links. All the way to a complex shopping cart system custom built with user and member management, including admin sections alowing you to easily modify your site.