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
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
- PHP Developer
- Web Developer
- Full-Stack Developer
- Software Engineer
- Database Administrator
Requirements
- Basic understanding of programming concepts.
- Access to a computer with PHP and MySQL installed.
- Eagerness to dive into the world of web development.
Curriculum
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
Resource
-
Assignment – Ultimate PHP & MySQL Web Development & OOP Coding
-
Get Your CPD Certificate
00:01:00
Offer Ends in
-
Duration:10 hours, 7 minutes
-
Access:1 Year
-
Units:134

45 Reviews
All
Courses for £49