Page 258 - Open Soource Technologies 304.indd

Web Technologies-I

Notes 6. The command ALTER TABLE is use to:
(a) Change a table (b) Delete a table
(c) Remove a table (d) None of these
7. The connection string for connecting to the database with PEAR DB is:
(a) driver://username:password@/database
(b) driver://:password@host/database
(c) driver://username:password@host/database
(d) None of these

True or False:
8. The values array contains the values for the placeholders in the query.
(a) True (b) False
9. PEAR DB allow us to use a single API for working with many different types of databases.
(a) True (b) False
10. The What parameter is a string identifying the database feature to list.
(a) True (b) False
11. PEAR DB allows you to use a single API for working only one type of database.
(a) True (b) False

10.5 Summary

• A database is simply an organized data. A database contains tables which are basically
descriptions of types of data. Table in turn contain record which is the actual data.
• PHP has support for over 20 databases, including the most popular commercials and open
source varieties. Relational database systems such as MySQL, PostgreSQL, and Oracle are
the backbones of most modern dynamic web sites.
• A PHP database connection tells Dreamweaver, that the current site is going to create
PHP pages, and refer to a specific database to store or display data.

• As one of the most powerful tools, computers give us the ability to store and search data.
Early applications stored data for programs in files and used indexes to search the files
for particular bits of data.
• Relational databases also have excellent security. In most database programs there is a
special database that contains access permissions for users and databases. This allows a
database administrator the ability to tune permissions to needs.
• PEAR supplies a number of open source extensions to PHP including its DB package,
which provides a database abstraction layer.
• RDBMSs support transactions, in which a series of database changes can be committed (all
applied at once) or rolled back (discarded, with the changes not applied to the database).

10.6 Keywords

Database: A database is an organized collection of data for one or more purposes, usually in
digital form. The data are typically organized to model relevant aspects of reality, in a way that
supports processes requiring this information.

252 LOVELY PROFESSIONAL UNIVERSITY