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.
Course Curriculum
-
Introduction00:02:00
-
Setup On Windows00:15:00
-
Setup On Mac00:11:00
-
Setup On Linux00:12:00
-
Online Code Editor00:03:00
-
Basic File Syntax00:05:00
-
Printing (echo)00:06:00
-
Comments00:05:00
-
Variables00:06:00
-
Variable Data Types00:07:00
-
Variable Naming00:03:00
-
Constants00:02:00
-
Arrays00:05:00
-
Associative Arrays00:06:00
-
Multidimensional Arrays00:04:00
-
if Statement00:06:00
-
if…else Statement00:02:00
-
if…elseif…else Statement00:05:00
-
Switch Statement00:06:00
-
while Loop00:06:00
-
do…While Loop00:03:00
-
for Loop00:03:00
-
foreach Loop00:05:00
-
Break Statement00:02:00
-
Continue Statement00:02:00
-
Basic Function00:03:00
-
Passing Function Arguments00:03:00
-
Passing Function Arguments By Reference00:04:00
-
Default Argument Value00:02:00
-
Function Returning Values00:05:00
-
Dynamic Function Calls00:03:00
-
Variable Scope00:04:00
-
Simple HTML Form00:07:00
-
GET vs POST00:05:00
-
$_SERVER [“PHP_SELF”]00:07:00
-
Validating Form Data With PHP00:07:00
-
Required Fields00:05:00
-
Display Error Messages00:05:00
-
Validate Name00:03:00
-
Validate Email00:03:00
-
Validate URL00:07:00
-
Keep The Values In The Form00: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 Uploading00:02:00
-
Front End HTML Upload Form00:04:00
-
PHP Upload Script00:15:00
-
Check If File Exists00:03:00
-
Limit File Size00:05:00
-
Limit File Type00:04:00
-
MySQL vs MySQLi vs PDO00:05:00
-
Creating A Database & Table (phpMyAdmin)00:06:00
-
Connecting To A Database00:06:00
-
Get Data Using SELECT Query00:10:00
-
WHERE Property For Filtering00:03:00
-
LIKE Property For Pattern Search00:02:00
-
Sorting Results Using ORDER BY Property00:01:00
-
Using JOINS00:08:00
-
Insert Data Using INSERT Query00:04:00
-
Get ID Of The Last Inserted Row00:02:00
-
Insert Multiple Rows00:05:00
-
Update Data Using UPDATE Query00:03:00
-
Delete Data Using DELETE Query00:02:00
-
Delete All Rows In A Table Using TRUNCATE Query00:02:00
-
Delete Table Using DROP Query00:02:00
-
Limit Data Selections Using LIMIT, ROWNUM00:04:00
-
Create Table Using CREATE Query00:03:00
-
Clone/Duplicate Table00:03:00
-
Alter Table00:05:00
-
Create Database00:02:00
-
Drop Database00:02:00
-
SQL Injection & Prepared Statements00:09:00
-
What Is XML?00:02:00
-
What Is SimpleXML?00:02:00
-
Parse XML String00:08:00
-
Parse XML File00:02:00
-
Get Node Values00:02:00
-
Get Node Values of Specific Elements00:03:00
-
Get Node Values – Loop00:03:00
-
Get Attribute Values00:02:00
-
What Is The XML Expat Parser?00:02:00
-
Initializing The XML Expat Parser00:10:00
-
Load and Output XML Using DOM Parser00:02:00
-
Looping Through XML Using DOM Parser00:03:00
-
What Is AJAX?00:02:00
-
Load Simple Data Using AJAX Front End00:08:00
-
Load Simple Data Using AJAX Back End00:05:00
-
Load Data From A Database Using AJAX00:08:00
-
Send A Plain Text Email00:04:00
-
Send A HTML Email00:06:00
-
Email Attachments00:17:00
-
PHPMailer Setup00:03:00
-
Send Email Using PHPMailer00:04:00
-
Send HTML Email Using PHPMailer00:04:00
-
Email Attachments Using PHPMailer00:02:00
-
What Is Object Oriented Programming (OOP)?00:03:00
-
Basic Class With Variables00:04:00
-
Functions00:05:00
-
Constructor00:04:00
-
Destructor00:02:00
-
Inheritance00:06:00
-
Multi Class Inheritance00:03:00
-
Function Overriding00:03:00
-
Public vs Private vs Protected00:05:00
-
Interfaces00:04:00
-
Constants00:03:00
-
Abstract Class00:06:00
-
Static Keyword00:03:00
-
Final Keyword00:02:00
-
Initiating Parent Constructor00:02:00
-
die() Function00:02:00
-
Custom Error Handler00:04:00
-
Triggering An Exception00:03:00
-
Exception Handling00:05:00
-
Create Database & Table00:04:00
-
User Class & Database Connection00:15:00
-
Register User Form00:09:00
-
Inserting User Data Into Database00:10:00
-
Registration Form Field Validation00:12:00
-
Securing User Password00:03:00
-
Check If Username or Email Already Exists00:11:00
-
Retain Data After Failed Registration00:03:00
-
Validate an Integer Within a Range00:04:00
-
Validate IPv6 Address00:03:00
-
Validate URL – Must Contain QueryString00:03:00
-
Remove Characters With ASCII Value > 12700:04:00
-
Including & Requiring External PHP Files00:05:00
-
Resource
-
Assignment – Ultimate PHP & MySQL Web Development & OOP Coding
14-Day Money-Back Guarantee
-
Duration:10 hours, 6 minutes
-
Access:1 Year
-
Units:133
Want to get everything for £149
Take Lifetime Pack