Course Introduction Banner

PHP & MySQL Server-Side Web Programming - Level 3 Course

Course Format:Online Course
Self-Study Time:Approximately 120 Hours (Self-Study)
Delivery Time:1-2 Working Days (Email)
Based on 227 reviews from
Course Fees & Payment Options
Pay in full today:
Payment in full on checkout by Card or Paypal
3 monthly payments:
Pay over 3 payments on checkout with Klarna
6 monthly payments:
1 payment of £90.00 taken now 5 further payments of £27.00 - taken monthly with GoCardless
6 Month Payment Option Details:
1 initial payment of £90.00 followed by 5 monthly payments of £27.00 by Direct Debit
Learn PHP & MySQL Programming

The PHP & MySQL Server-Side Web Programming Course is designed for learners with a working knowledge of HTML & CSS and this highly-practical programming course will revolutionise the complexity of web pages that you can develop by adding back-end database functionality to your designs. The course uses “Learn-by-Example” methodology, with more than 300 coding examples provided, along with detailed explanations of the code.

The range of interesting PHP topics includes the specification of local and global variables, expressions, if…then…else statements, while, for, and do loops, functions, classes, objects, and arrays, built-in functions, including date and time functions, and file handling operations.

We investigate how to validate form data input by a user, how to elegantly handle errors, and a range of debugging tips, before we move on to examine database-driven websites and look at the basics of the Structured Query Language. We finish with an in-depth look at MySQL and gain plenty of hands-on experience, with a wide range of exercises and assignments.

We start the course by investigating the basics of the PHP language and move on to the more advanced aspects of the PHP language, together with a whole host of tips and tricks that are sure to improve your programming abilities. After exploring PHP, we investigate how PHP can interact with an SQL database, before moving on to reviewing the major features of the MySQL Relational Database Management System.

On successful completion of the course, students will receive the Distance Learning Centre Webmaster Diploma with feedback and analysis of your completed work, as well as an Open Awards Quality Endorsed Unit Course Certificate.

Course Format

Based on the proven "learn by example” principle which, as the name implies, provides real-world examples to illustrate a particular topic or technique, the courses are delivered through our on-line training portal via a standard web browser, such as Chrome, Firefox, Edge, Opera, or Safari.

The lesson notes are delivered through slides giving you the required information to work through each lesson and there are student files you will download to work on so you are putting into practice what you are learning. You will also be supported by a personal tutor who is available to provide feedback on your work at any time throughout the period of study.

The PHP & MySQL Server-Side Web Programming Course Includes the Following Units:

The following topics are covered:

  • Introduction
  • PHP Fundamentals (1)
  • PHP Fundamentals (2)
  • Expressions & Control Flow in PHP
  • PHP Functions
  • PHP Classes & Objects
  • PHP Arrays
  • Lesson Review & Quiz
  • Assignment 1 – Blackjack Card Game

The following topics are covered:

  • Introduction
  • Print and Date & Time Functions
  • File Handling
  • Built-In Functions
  • Getting Data from Browsers
  • Validating Form Data
  • Lesson Review & Quiz
  • Assignment 2 – Form Validation Program

The following topics are covered:

  • Introduction
  • Working with Images
  • Cookies & Sessions
  • Error Handling
  • Exception Handling
  • Regular Expressions Revisited
  • Debugging PHP
  • Lesson Review & Quiz
  • Assignment 3 – Error Handling Project

The following topics are covered:

  • Introduction
  • Database-driven Websites
  • Structured Query Language (1)
  • Structured Query Language (2)
  • Getting Data From a Database
  • Displaying Data From a Database
  • Updating Data in a Database
  • Lesson Review & Quiz
  • Assignment 4 – Getting & Updating Data in Your Database

The following topics are covered:

  • Introduction
  • Introduction to MySQL
  • Updating a MySQL Database (1)
  • Updating a MySQL Database (2)
  • Database Design considerations
  • Transactions & Backups
  • Accessing MySQL Using PHP
  • Practical MySQL
  • Lesson Review & Quiz
  • Assignment 5 – Library Database Project

The following topics are covered:

  • Introduction
  • MySQL Built-In Functions (1)
  • MySQL Built-In Functions (2)
  • Creating Views, Functions, & Procedures
  • Creating Triggers & Events
  • Advanced Data Techniques for Large Queries
  • MySQL Server Settings
  • Advanced MySQL Performance Techniques
  • Lesson Review & Quiz
  • Assignment 6 – Time Recording System

Learners will need to have previous experience of HTML & CSS Programming. Students must also have: a working knowledge of using text editors or word processors; An understanding of your computer's operating system; A working knowledge of your email software and the ability to attach files to an email; A basic knowledge of file zipping software such as WinZip or 7-Zip; and Some experience of downloading and installing software packages from the web.

The course will give instructions for installing a local web server. The course is suitable for Windows or Mac operating systems and learners will require a minimum of 2GB disk space.

Course Duration & Online Support

You can start this course at any time, and you would be registered for a one-year period. You also have access to a personal tutor who can be contacted by email. Your tutor is available to assist with any queries and to mark your assignments for the Awarding Body.

As the course is self-study, you can complete it as quickly as you like. Support extensions are available if students do not complete the course within the one-year period.


You will be assessed on the completed assignments contained in the course. The coursework will consist of programming assignments. Assignments are emailed back to the course tutor on completion of your training.

Open Awards Certification

Open Awards

On successful completion of this course students will receive our PHP & MySQL Server-Side Web Programming Course Diploma with feedback on your work and providing the assignments have been completed to the required standards students will also receive a Level 3 Open Awards Quality Endorsed Unit Course Certificate with 8 Open Awards Credits.

The completion of this course alone does not lead to an Ofqual regulated qualification but may be used as evidence of knowledge and skills towards regulated qualifications in the future. To this end the learning outcomes of the course have been benchmarked at Level 3 against level descriptors published by Ofqual, to indicate the depth of study and level of difficulty involved in successful completion by the learner.

You can find further information on qualifications/certificates and their levels on the Ofqual's level descriptors page.

The certification is issued through Open Awards. Open Awards are an Awarding Body Organisation approved by Ofqual. Set up in 1981, Open Awards (Previously the North West Region of the National Open College Network - OCNNW) have been in business for over 30 years and are a not for profit organisation and a registered charity.

Quick Question

Let us know if you have a question about this course and we will get back to you ASAP.

Student Testimonials
Get the TOTUM Pro Student Card!
Get the TOTUM Pro Student Card!

This course is eligible for the TOTUM Pro Student Card. 

TOTUM PRO is made especially for professional learners, and opens up a whole world of fantastic savings and discounts on everything from dining out and keeping fit to travel abroad... Find Out More

Save money on hundreds of offers for:

  • Fashion
  • Eating Out
  • Music & Technology
  • Supermarkets
  • Health & Fitness
  • Home & Garden
  • Travel
Why Study With Us?
Huge Choice of Courses
We currently offer over 250+ diffeent distance learning courses leading to full Ofqual Regulated Qualifications or Accredited Certificates from National Awarding Bodies.
Customer Reviews
We're a top rated home learning provider on the Find Courses / Independent reviews site, Trustpilot - currently rated 9.6/10 for customer service.
Payment Plans
Choose to pay for your course in full, or spread the cost with monthly instalments. Payment plans are interest-free, with no credit checks.
Quick Delivery
We process all applications quickly and most course materials are available to start within 1 to 3 working days!
Tutor Support
All courses are fully supported and tutors are available to answer any questions, mark your assignments and offer feedback and guidance throughout your course.
Study At Your Pace
Work at your own pace. Our team will support you, but won't chase you for work or apply deadlines for submissions.
Recently Viewed (1)
PHP & MySQL Server-Side Web Programming - Level 3 Course
PHP & MySQL Server-Side Web Programming - Level 3 Course
From as little as £27.00 per month