Unit 2: Object Oriented Programming with PHP and Databases

 Home / MG2I-C0129
Unit 2: Object Oriented Programming with PHP and Databases

This unit forms part of the Course in MCAST Award in Dynamic Web Development Using PHP. Once a learner complete all the units in this course satisfactorily; that is has obtained a pass mark in the assessment and respected the 80% attendance s/he will achieve an award pegged at MQF Level 4, 9ECVET Credits

The course is aimed to provide students with knowledge to start a career in building dynamic websites using PHP and mySQL database.  This course will focus on industry standard practices complemented with practical examples.

This is a 30 hr guided learning course.  Students need to invest further hours in the course, which will include private study and home assignments.

Lessons are held as indicated on the prospectus and website..

This unit will introduce the object-oriented concept so that students can learn how to work with objects during the rest of the course.  The unit will also focus on how to design and create normalised databases using MySQL.  Finally, this study unit will demonstrate how to establish a connection between a web site and the implemented relational database.


Learning Outcome 1: Design a normalised database

Unit Content

  • About relational databases
  • Entities, Attributes, Tuples, and data values
  • Relationships between entities
  • Normalization process


Learning Outcome 2: Implement a normalised database using MySQL

Unit Content

  • MySQL Workbench
  • Creating  tables, attributes, and relationship in MySQL Workbench


Learning Outcome 3 Display data retrieved from a MySQL Database

Unit Content

  • Examining the data source controls
  • SQL – the language of databases
  • The SQL SELECT statement
  • Displaying data on page


Learning Outcome 4: Manipulate data in PHP & MySQL

Unit Content

  • Updating, deleting, and inserting data with the mysql
  • Looking at the data modification SQL statements
  • Editing and deleting data
  • Inserting data within Forms


Learning Outcome 5: Work with data-bound drop-down lists, radio buttons, and check boxes

Unit Content

  • An overview of the list web controls
  • Filtering results using the DropDownList
  • Collecting user input with the CheckBoxList and RadioButtonList


Learning Outcome 6: Work with objects

Unit Content

  • The role of classes and objects
  • Creating an object
  • Setting an object’s properties
  • Calling an object’s methods


The following are the suggested pre-requisites and/or entry requirements needed:


  • Completed compulsory education
  • Basic computer knowledge (ECDL-level, even though ECDL is not a requirement)
  • Basic knowledge of HTML and Javascript
  • Completed successfully Unit 1; PHP - Introduction

Entry Requirements:

  • Functional skills in the English Language
  • Functional skills in Basic Mathematics

Course participants may be awarded either an MCAST Certificate of Attendance or an MCAST Certificate of Achievement.

MCAST Certificate of Attendance

  • An MCAST Certificate of Attendance will be awarded to those candidates who attend at least 80% of the lessons.

MCAST Certificate of Achievement

  • An MCAST Certificate of Achievement will be awarded to those candidates who satisfy the 80% attendance criteria and also choose to sit and pass the course assessment/s.
  • Students who opt not to sit for the assessment or fail (the assessment/s) will however be awarded the MCAST Certificate of Attendance provided that they fulfill the minimum attendance criteria as stated above.

If the student intends to obtain a Certificate of Achievement, she/he is required to sit for an assessment/s.  Assessment/s may take various forms such as a home assignment, class assignment, practical test and time constrained test.  However, the assessment/s is not compulsory and an applicant may choose not to sit for it.

There are no additional costs or special materials/equipment to bring.

js files