Question:

(a) Write down short notes on PEAR and its coding standards.

(b) Consider a server with the following settings:

servername: localhost
username: alfred
password: bond007

How does PHP allow you to open a connection to a MySQL database?

(c) Referring to Question (b), list the PHP statements that allows you to :

(i) create the database named staffDB

(ii) create the database table tblLecturer

(iii) add the three fields: FirstName, LastName and Age.

(d) Referring to Question (b) and (c), write extract codes to display all the records from the tblLecturer table and the results sorted by the Age column.