Ultimate PHP & MySQL Web Development & OOP Coding

Ultimate PHP & MySQL Web Development Course & OOP Coding

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

Overview

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

The Ultimate PHP & MySQL Web Development & 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 expert 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

Certificate of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £129.00. Please note that overseas students may be charged an additional £10 for postage.

CPD Certificate of Achievement from One Education

Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.

Endorsement

This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an endorsed lesson. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.

Method of Assessment

To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support.

Why Study This Course

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

TheUltimate PHP & MySQL Web Development & OOP Coding is fully available to anyone, and no previous lessons 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
Assignment – Ultimate PHP & MySQL Web Development & OOP Coding 3 weeks, 3 days
Order Your Certificate
Order Your Certificate QLS 00:00:00
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
2
  • Item added to cart
  • Item added to cart
2
Your Cart
Windows 10 Pro Complete Training

Windows 10 Pro Complete Training
- +
£29
Get A PDF Certificate & Transcript After You Complete Your Course

Scholarship: Score 80% or more in your final exam to get this Fee refunded.

New Certificate On A Table
- +
£9.99

Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

Claim Offer & Upgrade

Membership renews after 12 months. You can cancel anytime from your account.

Other Students Also Buy
    Apply Coupon