No products in the basket.

Log In Sign Up

Home
Course
IT & Software
Ultimate PHP & MySQL Web Development Course & OOP Coding

Ultimate PHP & MySQL Web Development Course & OOP Coding

Get 92% Discount | CPD Accredited | Affordable Pricing | No Hidden Charges | 24/7 Tutor Support | Instant Access

4.6

★ ★ ★ ★ ★

★ ★ ★ ★ ★

45 Reviews

stds 87 Students

GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49. FIND OUT MORE

Course Highlights

Step into the digital age with power and precision as you unravel the intricacies of the Ultimate PHP & MySQL Web Development Course & OOP Coding. This journey doesn’t just introduce you to coding; it invites you to command the world of web development with expertise. From the foundational stone of setup and introduction to the towering complexities of advanced techniques, every step you take will amplify your understanding and dexterity.

Navigating through this course, you’ll find yourself adeptly maneuvering through PHP’s control structures, crafting functions with finesse, and designing forms that seamlessly integrate into diverse platforms. Grasping file handling will be a breeze, while MySQL will transform you into a maestro of database operations. But that’s not all! Learn to seamlessly integrate XML, utilize the efficiency of AJAX, and manage emails effectively, all while developing a profound understanding of the tenets of Object Oriented Programming.

As the course reaches its zenith, it’s not just about coding but mastering error handling, ensuring your codes run smoothly, and tapping into a reservoir of resources that will be your compass in the vast sea of web development. By the end, you won’t just be a coder; you’ll be a craftsman of the web, ready to sculpt digital masterpieces.

Learning outcome

Learn the basics of PHP programming, including variables, data types, operators, and control structures.
Learn how to connect to a MySQL database and perform basic database operations.
Create dynamic and interactive websites and web applications using PHP and MySQL.
Learn about OOP concepts in PHP, such as classes, objects, inheritance, and polymorphism.
Learn about more advanced PHP topics, such as file handling, XML, AJAX, and emails.

Course media

Marketplace Review

Why should I take this course?

Learn the most in-demand web development skills.
Create dynamic and interactive websites and web applications.
Boost your career prospects and earn a higher salary.
Join a community of thousands of successful PHP developers.
Learn from experienced and passionate instructors.

Career Path

Requirements

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

Assignment

Assignment – Ultimate PHP & MySQL Web Development & OOP Coding

Certification

Get Your CPD Certificate

00:01:00

Ultimate PHP & MySQL Web Development Course & OOP Coding

£25.00

Save 92% - Grab Now!

Offer Ends in

countdownmail.com

TAKE THIS COURSE

Or

All Courses for £49

14-Day Money-Back Guarantee

This course includes:

Duration:

10 hours, 7 minutes
Access:

1 Year
Units:

134

Chat with usLiveChat