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.