Ultimate PHP & MySQL Web Development Course & OOP Coding
Become an In-demand PHP & MySQL Ninja by learning all the web developments features for creating websites
Created by Frahaan Hussain, Last Updated 27-Jan-2020, Language:English
What Will I Get ?
- PHP Programming
- SQL Programming
- Database Coding
- Application programming
- Cross Platform Development
- Web Development
- Semantics of General Programming
- The Format of Coding Applications
- Web Design
- All The Features of PHP & MySQL
- Object Oriented Programming
Requirements
- Passion For Learning Web Development
- Basic Computer Knowledge and Skills
- Passion For Learning PHP Programming
- Basic Knowledge of Computer Science Is Optional
Description
Learn about everything there is to know about PHP & MySQL Web Development. A step by step process is used to explain every facet of these topics.
PHP is one the most popular languages in the world. It is requested by all companies such as Google, Facebook and Microsoft for development. It powers Facebook and many other popular websites. This course will ensure you are not left out as more and more companies request this awesome and powerful language. This course will teach you everything about programming PHP & MySQL applications.
You will receive all the knowledge to use and leverage the powerful technology behind these amazing and wonderful platforms.
Who this course is for:
- Anyone Looking To Learn About PHP Coding
- Developers Looking To Learn The Skills Needed To Utilise PHP Features
- PHP Developers
- Web Developers
- Application Programmers
- Web Designers
- People Looking To Learn About Programming
- Those Seeking To Understand How PHP Programming Works
- People Seeking Guidance On How To Create PHP & MySQL Websites/Application
- Beginners & Experts In This Field
- People With a Desire To Improve Their Programming Knowledge
Course Content
-
Introduction & Setup
1 Lectures
00:01:48
-
Introduction
Preview00:01:48
-
-
Basics
10 Lectures
00:49:55
-
Basic File Syntax
Preview00:04:46 -
Printing (echo)
Preview00:06:24 -
Comments
00:05:25 -
Variables
00:06:03 -
Variable Data Types
00:07:12 -
Variable Naming
00:02:59 -
Constants
00:02:25 -
Arrays
00:05:09 -
Associative Arrays
00:05:29 -
Multidimensional Arrays
00:04:03
-
-
Control Structures
9 Lectures
00:36:00
-
if Statement
00:06:02 -
if...else Statement
00:01:43 -
if...elseif...else Statement
00:04:48 -
Switch Statement
00:05:59 -
while Loop
00:05:37 -
do...While Loop
00:02:56 -
foreach Loop
00:04:52 -
Break Statement
00:02:10 -
Continue Statement
00:01:53
-
-
Functions
7 Lectures
00:23:15
-
Basic Function
00:02:38 -
Passing Function Arguments
00:03:06 -
Passing Function Arguments By Reference
00:03:54 -
Default Argument Value
00:01:36 -
Function Returning Values
00:05:02 -
Dynamic Function Calls
00:02:37 -
Variable Scope
00:04:22
-
-
Forms
10 Lectures
00:50:59
-
Simple HTML Form
00:07:03 -
GET vs POST
00:04:30 -
$_SERVER["PHP_SELF"]
00:06:37 -
Validating Form Data With PHP
00:06:36 -
Required Fields
00:04:52 -
Display Error Messages
00:05:16 -
Validate Name
00:02:37 -
Validate Email
00:03:15 -
Validate URL
00:06:35 -
Keep The Values In The Form
00:03:38
-
-
File Handling
12 Lectures
00:47:54
-
Read File (readfile())
00:02:22 -
Open, Read & Close A File (fopen(), fread(), fclose())
00:03:55 -
Read Single Line (fgets())
00:02:35 -
Check End-Of-File (feof())
00:01:58 -
Read Single Character (fgetc())
00:01:51 -
Write To File (fwrite())
00:03:16 -
Configure php.ini File For File Uploading
00:02:20 -
Front End HTML Upload Form
00:03:38 -
PHP Upload Script
00:14:48 -
Check If File Exists
00:02:56 -
Limit File Size
00:04:36 -
Limit File Type
00:03:39
-
-
MySQL
21 Lectures
01:22:41
-
MySQL vs MySQLi vs PDO
00:05:18 -
Creating A Database & Table (phpMyAdmin)
00:05:39 -
Connecting To A Database
00:06:14 -
Get Data Using SELECT Query
00:09:58 -
WHERE Property For Filtering
00:02:45 -
LIKE Property For Pattern Search
00:02:27 -
Sorting Results Using ORDER BY Property
00:01:08 -
Insert Data Using INSERT Query
00:04:00 -
Get ID Of The Last Inserted Row
00:02:26 -
Insert Multiple Rows
00:05:03 -
Update Data Using UPDATE Query
00:03:18 -
Delete Data Using DELETE Query
00:02:21 -
Delete All Rows In A Table Using TRUNCATE Query
00:01:52 -
Delete Table Using DROP Query
00:02:08 -
Limit Data Selections Using LIMIT, ROWNUM
00:04:03 -
Create Table Using CREATE Query
00:03:25 -
Clone/Duplicate Table
00:03:02 -
Alter Table
00:04:36 -
Create Database
00:02:00 -
Drop Database
00:01:50 -
SQL Injection & Prepared Statements
00:09:08
-
-
XML
5 Lectures
00:11:01
-
What Is XML?
00:02:15 -
Get Node Values
00:02:13 -
What Is The XML Expat Parser?
00:01:46 -
Load and Output XML Using The Dom Parser
00:01:34 -
Looping through XML Using The Dom Parser
00:03:13
-
-
AJAX
2 Lectures
00:10:08
-
What Is AJAX?
00:01:42 -
Load Simple Data Using AJAX Front End
00:08:26
-
-
Emails
2 Lectures
00:06:32
-
Send Email Using PHPMailer
00:04:13 -
Email Attachments Using PHPMailer
00:02:19
-
-
Object Oriented Programming
2 Lectures
00:06:47
-
Functions
00:04:35 -
Initiating Parent Constructor
00:02:12
-
-
Error Handling
1 Lectures
00:04:39
-
Exception Handling
00:04:39
-
-
Advanced
2 Lectures
00:08:11
-
Validate an Integer Within a Range
00:04:27 -
Remove Characters With ASCII Value > 127
00:03:44
-
Frahaan Hussain
CEO and Lead Developer at Sonar Systems
I am CEO of Sonar Systems which is the world leader in educational material for the game engine Cocos2d-x, one of the best and most popular game engines in the world. With years of experience programming and running an online education platform (Sonar Learning) I can help and support new programming like you. I am also a University Lecturer teaching a variety of topics in Games Programming from Games Design to OpenGL Shader Programming. I am also a published author of games design and soon to be released Responsive Web Design. I have all the facets required to educate and inspire.
