Tutorial PHP : Databases / PDF

Sample of the pdf document :

Databases are useful!

Most of the services we use on the Web are provided by webdatabase applications. Web-based email, online shopping, forums and bulletin boards, corporate web sites, and news portals are all database-driven.

The use of databases has several potential advantages.

– separation of design and content, by working with templates
– content often outlasts the design of a Web site
– search and sort capabilities (access to all columns of a DB)
– easy backup and recovery


Databases:

PHP supports over 20 types of databases, both commercial and open source.
In this class we are focusing on the MySQL relational databasesystem, using the Structured Query Language (SQL) tocommunicate with the database.
In a Database Management System (DBMS), running on a database server, the data is structured into tables where eachtable has some number of columns, each of which has a nameand a type (e.g. one table might keep track of all purchaseditems in an e-business where another table stores the billing andshipping address of the customer, connected through a key)


Database terms:

Database
A repository to store data. For example, a database might store all of the data associated with finance in a large company, information about your CD and DVD collection, or the records of an online store.

Table
A part of a database that stores data related to an object, thing, or activity. For example, a table might store data about customers. A table has columns, fields, or attributes. The data is stored as rows or records.

Attributes
The columns in a table. All rows in a table have the same attributes. For example, a customer table might have the attributes name, address, and city. Each attribute has a data type such as string, integer, or date.

Rows
The data entries stored in a table. Rows contain values for each attribute. For example, a row in a customer table might contain the values “Matthew Richardson,” “Punt Road,” and “Richmond.” Rows are also known as records.

Relational model
A formal model that uses database, tables, and attributes to store data and manages the relationship between tables...........

 Click here for  Download PDF / FREE