Data Base

Databases can also be used for storing and accessing customer records. This allows you to tailor your pages according to your customer’s previous purchases. Each page could have a personalized greeting (Welcome back Peter) and when they make another purchase all their personal data including address and credit card number could be pulled from the database so they don’t have to fill in the same form again.

Another use of a database is mailinglists. Many websites send out information to their visitors to remind them about the site and encourage them to visit again. Email addresses can be stored in a database for the purpose of sending out announcements and newsletters. Also the newsletters can be archived in a database so that visitors can browse or search through previous mailings.

Each database can be divided into tables which are a complete set of data, so one database could be used for most of your website information by setting up a number of tables.The number of databases that your site needs depends on how many applications you are going to run.

It’s one thing to have a database, it’s another to access that data. There are several ways to retrieve information from a database so that it can be usefully applied to your website. One of the most popular combinations is PHP along with MySQL. PHP can be used to create dynamic web pages that pull data from a MySQL database. The programming language is quite straightforward and can be used to set up complex interactive forms. Other database applications include MySQL with ASP, MSSQL with ASP, and PostgreSQL with PHP.