Introduction

This section provides materials on connecting to a database from a programming language. PHP is chosen as the language and PDO the library in PHP, because PHP is the most accessible web programming language and PDO now comes as part of a standard PHP package meaning there is no need to download additional libraries.

I use the free webhosting service 000webhost in my course, mainly because it is free. If you are using a different platform, language or database library, you will have to modify the instructional materials.

The current contents are:

• Introduction
• Database Programming With PHP PDO
• Programming REST with PHP PDO

Any questions or comments should be directed to: The creator's email

Database Programming With PHP PDO

Materials for teaching how to use PHP PDO with a database are here. The contents include a lab exercise and the accompanying PHP file (zipped to allow downloads).

• The lab exercise is found here.
• The accompanying zipped PHP file is found here.

Any questions or comments should be directed to: The creator's email

Programming REST with PHP PDO

This lab activity teaches how to develop REST interfaces for a web page that communicate with the web page using HTTP GET and JSON.

• The lab exercise is found here.
• The accompanying zipped PHP file is found here.

Any questions or comments should be directed to: The creator's email