Skip to content Search
Search our website:

Building Web Applications using MySQL and PHP

Short name: W1
SITS code: SSCS023H5
Credits: 15 credits
Level: 5

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.

Syllabus

  • 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

Timetable

All dates and timetables are listed in the programme handbooks of individual programmes.