• No products in the basket.



  • 3 Students

  • Certified


Master PHP & MySQL by learning all the web development features for creating websites.

The Ultimate PHP & MySQL Web Development Course & OOP Coding course covers the A-Z of PHP programming, equipping learners with in-demand industry skills needed to develop websites and applications. It will take you through the fundamentals of PHP and MySQL, starting from the very basics for those who are new to the field. 

This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced professional in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market.

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised CPD accredited certification. You can choose to make your achievement formal by obtaining your PDF Certificate at the cost of £9 and Hard Copy Certificate for £15.

Why study this course

It doesn’t matter if you are an aspiring professional or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an accredited certification attesting to your knowledge.

The Ultimate PHP & MySQL Web Development Course & OOP Coding is fully available to anyone, and no previous qualifications are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.

Course Curriculum

Section 01: Introduction & Setup
Introduction 00:02:00
Setup On Windows 00:15:00
Setup On Mac 00:11:00
Setup On Linux 00:12:00
Online Code Editor 00:03:00
Section 02: Basics
Basic File Syntax 00:05:00
Printing (echo) 00:06:00
Comments 00:05:00
Variables 00:06:00
Variable Data Types 00:07:00
Variable Naming 00:03:00
Constants 00:02:00
Arrays 00:05:00
Associative Arrays 00:06:00
Multidimensional Arrays 00:04:00
Section 03: Control Structures
if Statement 00:06:00
if…else Statement 00:02:00
if…elseif…else Statement 00:05:00
Switch Statement 00:06:00
while Loop 00:06:00
do…While Loop 00:03:00
for Loop 00:03:00
foreach Loop 00:05:00
Break Statement 00:02:00
Continue Statement 00:02:00
Section 04: Functions
Basic Function 00:03:00
Passing Function Arguments 00:03:00
Passing Function Arguments By Reference 00:04:00
Default Argument Value 00:02:00
Function Returning Values 00:05:00
Dynamic Function Calls 00:03:00
Variable Scope 00:04:00
Section 05: Forms
Simple HTML Form 00:07:00
GET vs POST 00:05:00
$_SERVER [“PHP_SELF”] 00:07:00
Validating Form Data With PHP 00:07:00
Required Fields 00:05:00
Display Error Messages 00:05:00
Validate Name 00:03:00
Validate Email 00:03:00
Validate URL 00:07:00
Keep The Values In The Form 00:04:00
Section 06: File Handling
Read File (readfile()) 00:02:00
Open, Read & Close A File (fopen(), fread(), fclose()) 00:04:00
Read Single Line (fgets()) 00:03:00
Check End-Of-File (feof()) 00:02:00
Read Single Character (fgetc()) 00:02:00
Write To File (fwrite()) 00:03:00
Configure php.ini File For File Uploading 00:02:00
Front End HTML Upload Form 00:04:00
PHP Upload Script 00:15:00
Check If File Exists 00:03:00
Limit File Size 00:05:00
Limit File Type 00:04:00
Section 07: MySQL
MySQL vs MySQLi vs PDO 00:05:00
Creating A Database & Table (phpMyAdmin) 00:06:00
Connecting To A Database 00:06:00
Get Data Using SELECT Query 00:10:00
WHERE Property For Filtering 00:03:00
LIKE Property For Pattern Search 00:02:00
Sorting Results Using ORDER BY Property 00:01:00
Using JOINS 00:08:00
Insert Data Using INSERT Query 00:04:00
Get ID Of The Last Inserted Row 00:02:00
Insert Multiple Rows 00:05:00
Update Data Using UPDATE Query 00:03:00
Delete Data Using DELETE Query 00:02:00
Delete All Rows In A Table Using TRUNCATE Query 00:02:00
Delete Table Using DROP Query 00:02:00
Limit Data Selections Using LIMIT, ROWNUM 00:04:00
Create Table Using CREATE Query 00:03:00
Clone/Duplicate Table 00:03:00
Alter Table 00:05:00
Create Database 00:02:00
Drop Database 00:02:00
SQL Injection & Prepared Statements 00:09:00
Section 08: XML
What Is XML? 00:02:00
What Is SimpleXML? 00:02:00
Parse XML String 00:08:00
Parse XML File 00:02:00
Get Node Values 00:02:00
Get Node Values of Specific Elements 00:03:00
Get Node Values – Loop 00:03:00
Get Attribute Values 00:02:00
What Is The XML Expat Parser? 00:02:00
Initializing The XML Expat Parser 00:10:00
Load and Output XML Using DOM Parser 00:02:00
Looping Through XML Using DOM Parser 00:03:00
Section 09: AJAX
What Is AJAX? 00:02:00
Load Simple Data Using AJAX Front End 00:08:00
Load Simple Data Using AJAX Back End 00:05:00
Load Data From A Database Using AJAX 00:08:00
Section 10: Emails
Send A Plain Text Email 00:04:00
Send A HTML Email 00:06:00
Email Attachments 00:17:00
PHPMailer Setup 00:03:00
Send Email Using PHPMailer 00:04:00
Send HTML Email Using PHPMailer 00:04:00
Email Attachments Using PHPMailer 00:02:00
Section 11: Object Oriented Programming
What Is Object Oriented Programming (OOP)? 00:03:00
Basic Class With Variables 00:04:00
Functions 00:05:00
Constructor 00:04:00
Destructor 00:02:00
Inheritance 00:06:00
Multi Class Inheritance 00:03:00
Function Overriding 00:03:00
Public vs Private vs Protected 00:05:00
Interfaces 00:04:00
Constants 00:03:00
Abstract Class 00:06:00
Static Keyword 00:03:00
Final Keyword 00:02:00
Initiating Parent Constructor 00:02:00
Section 12: Error Handling
die() Function 00:02:00
Custom Error Handler 00:04:00
Triggering An Exception 00:03:00
Exception Handling 00:05:00
Create Database & Table 00:04:00
User Class & Database Connection 00:15:00
Register User Form 00:09:00
Inserting User Data Into Database 00:10:00
Registration Form Field Validation 00:12:00
Securing User Password 00:03:00
Check If Username or Email Already Exists 00:11:00
Retain Data After Failed Registration 00:03:00
Section 13: Advanced
Validate an Integer Within a Range 00:04:00
Validate IPv6 Address 00:03:00
Validate URL – Must Contain QueryString 00:03:00
Remove Characters With ASCII Value > 127 00:04:00
Including & Requiring External PHP Files 00:05:00
Section 14 : Resource
Resource 00:00:00
Assignment – Ultimate PHP & MySQL Web Development Course & OOP Coding 00:00:00

Training 10 or more people?

Get your team access to 3,000+ top courses anytime, anywhere.

Try One Education Business


Get accredited certificates

New skills

Add skills to your CV


Test your skills

Dedicated Support

For any questions

Set your own speed

Self-paced learning

Save your money

Monthly subscription

COPYRIGHT © 2022 One Education

Your Cart