skip to navigation skip to content access keys

Building Web Applications using MySQL and PHP

Aims

  • to build on the basic database design knowledge and MySQL and PHP skills developed in Database Design using MySQL and Web Programming using PHP to develop expertise in data management for web enabled databases.
  • to introduce a range of techniques that assist in the design and development of robust, dynamic and secure web enabled database applications.
  • to develop programming skills to manage data in web-enabled databases with dynamic web page creation.

Content

  • PHP and MySQL: Accessing and interacting with MySQL databases using PHP. Identifying and dealing with concurrency issues in web applications.
  • Error Handling: Debugging code and handling errors gracefully.
  • File Handling : Processing uploaded files. Using PHP to create and manage external files.
  • Graphics: Manipulating graphics with the gd2 library.
  • PHP Libraries: Making use of external libraries, e.g. gd2 for manipulation of graphics.
  • Classes and OOP: Introducing classes and Object Oriented Programming.

Prerequisites

  • Database Design using MySQL or equivalent, Web Programming using PHP or equivalent
  • Basic principles of programming

Credits

  • 15 CATS points at Level 5 NQF