This course is designed for those interested to learn the basics of Hypertext Preprocessor And MyStructured Query Language, their features and capabilities, and how to use them for cross platform development. Read more.
I am CEO of Sonar Systems which is the world leader in educational material.
Buy this course for $199 $10
and keep lifetime access.
Access all courses in our library for only $9/month with All Access Pass
About This Course
Who this course is for:
- Anyone looking to learn about PHP coding
- Developers looking to learn the skills needed to utilize 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 and MySQL websites and applications
- Beginners and experts in this field
- People with a desire to improve their programming knowledge
What you’ll learn:Â
- What PHP and MySQL are
- How to develop websites and applications using PHP and MySQL
- Features of PHP and MySQL
- Coding semantics
- Application programming
- Network programming
PHP is one of the most popular programming languages in the world. Not only is it used by giant companies such as Google, Facebook, and Microsoft for development, it also powers many of today’s popular websites.Â
This course will provide you:
- Lifetime access to HD quality videos. No monthly subscription. Learn at your own pace, whenever you want.
- Free helpful support when you have questions or get stuck.
- Multiple coding challenges to practice your new skills, solutions included.
Our Promise to You
By the end of this course, you will have learned how to program using PHP And MySQL.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about the basics of Hypertext Preprocessor And MyStructured Query Language.
Course Curriculum
Section 1 - Introduction And Setup | |||
Introduction | 00:00:00 | ||
Setup On Windows | 00:00:00 | ||
Setup On Mac | 00:00:00 | ||
Setup On Linux | 00:00:00 | ||
Online Code Editor | 00:00:00 | ||
Section 2 - Basics | |||
Basic File Syntax | 00:00:00 | ||
Printing (Echo) | 00:00:00 | ||
Comments | 00:00:00 | ||
Variables | 00:00:00 | ||
Variable Data Types | 00:00:00 | ||
Variable Naming | 00:00:00 | ||
Constants | 00:00:00 | ||
Arrays | 00:00:00 | ||
Associative Arrays | 00:00:00 | ||
Multidimensional Arrays | 00:00:00 | ||
Section 3 - Control Structures | |||
if Statment | 00:00:00 | ||
if...else Statement | 00:00:00 | ||
if...elseif...else Statement | 00:00:00 | ||
Switch Statement | 00:00:00 | ||
while Loop | 00:00:00 | ||
do...while Loop | 00:00:00 | ||
for Loop | 00:00:00 | ||
foreach Loop | 00:00:00 | ||
Break Statement | 00:00:00 | ||
Continue Statement | 00:00:00 | ||
Section 4 - Functions | |||
Basic Function | 00:00:00 | ||
Passing Function Arguments | 00:00:00 | ||
Passing Function Arguments By Reference | 00:00:00 | ||
Default Argument Value | 00:00:00 | ||
Function Returning Values | 00:00:00 | ||
Dynamic Function Calls | 00:00:00 | ||
Variable Scope | 00:00:00 | ||
Section 5 - Forms | |||
Simple HTML Form | 00:00:00 | ||
GET vs POST | 00:00:00 | ||
$_SERVER["PHP_SELF"] | 00:00:00 | ||
Validating Form Data With PHP | 00:00:00 | ||
Required Fields | 00:00:00 | ||
Display Error Messages | 00:00:00 | ||
Validate Name | 00:00:00 | ||
Validate Email | 00:00:00 | ||
Validate URL | 00:00:00 | ||
Keep The Values In The Form | 00:00:00 | ||
Section 6 - File Handling | |||
Read File (readfile()) | 00:00:00 | ||
Open, Read & Close a File (fopen(), fread(), fclose()) | 00:00:00 | ||
Read Single Line (fgets()) | 00:00:00 | ||
Check End-Of-File (feof()) | 00:00:00 | ||
Read Single Character fgetc()) | 00:00:00 | ||
Write To File (fwrite()) | 00:00:00 | ||
Configure php.ini File For File Uploading | 00:00:00 | ||
Front End HTML Upload Form | 00:00:00 | ||
PHP Upload Script | 00:00:00 | ||
Check If File Exists | 00:00:00 | ||
Limit File Size | 00:00:00 | ||
Limit File Type | 00:00:00 | ||
Section 7 - MySQL | |||
MySQL vs MySQLi vs PDO | 00:00:00 | ||
Creating A Database & Table (phpMyAdmin) | 00:00:00 | ||
Connecting To A Database | 00:00:00 | ||
Get Data Using SELECT query | 00:00:00 | ||
WHERE Property For Filtering | 00:00:00 | ||
LIKE Property For Pattern Search | 00:00:00 | ||
Sorting Results Using ORDER BY Property | 00:00:00 | ||
Using JOINS | 00:00:00 | ||
Insert Data Using INSERT Query | 00:00:00 | ||
Get ID Of The Last Inserted Row | 00:00:00 | ||
Insert Multiple Rows | 00:00:00 | ||
Update Data Using UPDATE Query | 00:00:00 | ||
Delete Data Using DELETE Query | 00:00:00 | ||
Delete All Rows In A Table Using TRUNCATE Query | 00:00:00 | ||
Delete Table Using DROP Query | 00:00:00 | ||
Limit Data Selections Using LIMIT, ROWNUM | 00:00:00 | ||
Create Table Using CREATE Query | 00:00:00 | ||
Clone/Duplicate Table | 00:00:00 | ||
Alter Table | 00:00:00 | ||
Create Database | 00:00:00 | ||
Drop Database | 00:00:00 | ||
SQL Injection & Prepared Statements | 00:00:00 | ||
Section 8 - XML | |||
What Is XML? | 00:00:00 | ||
What Is SimpleXML | 00:00:00 | ||
Parse XML String | 00:00:00 | ||
Parse XML File | 00:00:00 | ||
Get Node Values | 00:00:00 | ||
Get Node Values of Specific Elements | 00:00:00 | ||
Get Node Values - Loop | 00:00:00 | ||
Get Attribute Values | 00:00:00 | ||
What Is The XML Expat Parser? | 00:00:00 | ||
Initializing The XML Expat Parser | 00:00:00 | ||
Load And Output XML Using the Dom Parser | 00:00:00 | ||
Looping Through XML Using The Dom Parser | 00:00:00 | ||
Section 9 - AJAX | |||
What Is AJAX? | 00:00:00 | ||
Load Simple Data Using AJAX Front End | 00:00:00 | ||
Load Simple Data Using AJAX Back End | 00:00:00 | ||
Load Data From Database Using AJAX | 00:00:00 | ||
Section 10 - Emails | |||
Send A Plain Text Email | 00:00:00 | ||
Send A HTML Email | 00:00:00 | ||
Email Attachments | 00:00:00 | ||
PHPMailer Setup | 00:00:00 | ||
Send Email Using PHPMailer | 00:00:00 | ||
Send HTML Email Using PHPMailer | 00:00:00 | ||
Email Attachments Using PHPMailer | 00:00:00 | ||
Section 11 - Object Oriented Programming | |||
What Is Object Oriented Programming (OOP)? | 00:00:00 | ||
Basic Class With Variables | 00:00:00 | ||
Functions | 00:00:00 | ||
Constructor | 00:00:00 | ||
Destructor | 00:00:00 | ||
Inheritance | 00:00:00 | ||
Multi Class Inheritance | 00:00:00 | ||
Function Overriding | 00:00:00 | ||
Public vs Private vs Protected | 00:00:00 | ||
Interfaces | 00:00:00 | ||
Constants | 00:00:00 | ||
Abstract Class | 00:00:00 | ||
Static Keyword | 00:00:00 | ||
Final Keyword | 00:00:00 | ||
Initiating Parent Constructor | 00:00:00 | ||
Section 12 - Error Handling | |||
die() Function | 00:00:00 | ||
Custom Error Handler | 00:00:00 | ||
Triggering An Exception | 00:00:00 | ||
Exception Handling | 00:00:00 | ||
Create Database And Table | 00:00:00 | ||
User Class And Database Connection | 00:00:00 | ||
Register User Form | 00:00:00 | ||
Inserting User Data Into Database | 00:00:00 | ||
Registration Form Field Validation | 00:00:00 | ||
Securing User Password | 00:00:00 | ||
Check If Username Already Exists | 00:00:00 | ||
Retain Data After Failed Registration | 00:00:00 | ||
Section 13 - Advanced | |||
Validate An Integer Within A Range | 00:00:00 | ||
Validate IPv6 ADdress | 00:00:00 | ||
Validate URL - Must Contain QueryString | 00:00:00 | ||
Remove Characters With ASCII Value - 127 | 00:00:00 | ||
Including And Requiring External PHP Files | 00:00:00 | ||
Oracle Certification Readiness - Useful Links | 00:00:00 |
About This Course
Who this course is for:
- Anyone looking to learn about PHP coding
- Developers looking to learn the skills needed to utilize 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 and MySQL websites and applications
- Beginners and experts in this field
- People with a desire to improve their programming knowledge
What you’ll learn:Â
- What PHP and MySQL are
- How to develop websites and applications using PHP and MySQL
- Features of PHP and MySQL
- Coding semantics
- Application programming
- Network programming
PHP is one of the most popular programming languages in the world. Not only is it used by giant companies such as Google, Facebook, and Microsoft for development, it also powers many of today’s popular websites.Â
This course will provide you:
- Lifetime access to HD quality videos. No monthly subscription. Learn at your own pace, whenever you want.
- Free helpful support when you have questions or get stuck.
- Multiple coding challenges to practice your new skills, solutions included.
Our Promise to You
By the end of this course, you will have learned how to program using PHP And MySQL.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about the basics of Hypertext Preprocessor And MyStructured Query Language.
Course Curriculum
Section 1 - Introduction And Setup | |||
Introduction | 00:00:00 | ||
Setup On Windows | 00:00:00 | ||
Setup On Mac | 00:00:00 | ||
Setup On Linux | 00:00:00 | ||
Online Code Editor | 00:00:00 | ||
Section 2 - Basics | |||
Basic File Syntax | 00:00:00 | ||
Printing (Echo) | 00:00:00 | ||
Comments | 00:00:00 | ||
Variables | 00:00:00 | ||
Variable Data Types | 00:00:00 | ||
Variable Naming | 00:00:00 | ||
Constants | 00:00:00 | ||
Arrays | 00:00:00 | ||
Associative Arrays | 00:00:00 | ||
Multidimensional Arrays | 00:00:00 | ||
Section 3 - Control Structures | |||
if Statment | 00:00:00 | ||
if...else Statement | 00:00:00 | ||
if...elseif...else Statement | 00:00:00 | ||
Switch Statement | 00:00:00 | ||
while Loop | 00:00:00 | ||
do...while Loop | 00:00:00 | ||
for Loop | 00:00:00 | ||
foreach Loop | 00:00:00 | ||
Break Statement | 00:00:00 | ||
Continue Statement | 00:00:00 | ||
Section 4 - Functions | |||
Basic Function | 00:00:00 | ||
Passing Function Arguments | 00:00:00 | ||
Passing Function Arguments By Reference | 00:00:00 | ||
Default Argument Value | 00:00:00 | ||
Function Returning Values | 00:00:00 | ||
Dynamic Function Calls | 00:00:00 | ||
Variable Scope | 00:00:00 | ||
Section 5 - Forms | |||
Simple HTML Form | 00:00:00 | ||
GET vs POST | 00:00:00 | ||
$_SERVER["PHP_SELF"] | 00:00:00 | ||
Validating Form Data With PHP | 00:00:00 | ||
Required Fields | 00:00:00 | ||
Display Error Messages | 00:00:00 | ||
Validate Name | 00:00:00 | ||
Validate Email | 00:00:00 | ||
Validate URL | 00:00:00 | ||
Keep The Values In The Form | 00:00:00 | ||
Section 6 - File Handling | |||
Read File (readfile()) | 00:00:00 | ||
Open, Read & Close a File (fopen(), fread(), fclose()) | 00:00:00 | ||
Read Single Line (fgets()) | 00:00:00 | ||
Check End-Of-File (feof()) | 00:00:00 | ||
Read Single Character fgetc()) | 00:00:00 | ||
Write To File (fwrite()) | 00:00:00 | ||
Configure php.ini File For File Uploading | 00:00:00 | ||
Front End HTML Upload Form | 00:00:00 | ||
PHP Upload Script | 00:00:00 | ||
Check If File Exists | 00:00:00 | ||
Limit File Size | 00:00:00 | ||
Limit File Type | 00:00:00 | ||
Section 7 - MySQL | |||
MySQL vs MySQLi vs PDO | 00:00:00 | ||
Creating A Database & Table (phpMyAdmin) | 00:00:00 | ||
Connecting To A Database | 00:00:00 | ||
Get Data Using SELECT query | 00:00:00 | ||
WHERE Property For Filtering | 00:00:00 | ||
LIKE Property For Pattern Search | 00:00:00 | ||
Sorting Results Using ORDER BY Property | 00:00:00 | ||
Using JOINS | 00:00:00 | ||
Insert Data Using INSERT Query | 00:00:00 | ||
Get ID Of The Last Inserted Row | 00:00:00 | ||
Insert Multiple Rows | 00:00:00 | ||
Update Data Using UPDATE Query | 00:00:00 | ||
Delete Data Using DELETE Query | 00:00:00 | ||
Delete All Rows In A Table Using TRUNCATE Query | 00:00:00 | ||
Delete Table Using DROP Query | 00:00:00 | ||
Limit Data Selections Using LIMIT, ROWNUM | 00:00:00 | ||
Create Table Using CREATE Query | 00:00:00 | ||
Clone/Duplicate Table | 00:00:00 | ||
Alter Table | 00:00:00 | ||
Create Database | 00:00:00 | ||
Drop Database | 00:00:00 | ||
SQL Injection & Prepared Statements | 00:00:00 | ||
Section 8 - XML | |||
What Is XML? | 00:00:00 | ||
What Is SimpleXML | 00:00:00 | ||
Parse XML String | 00:00:00 | ||
Parse XML File | 00:00:00 | ||
Get Node Values | 00:00:00 | ||
Get Node Values of Specific Elements | 00:00:00 | ||
Get Node Values - Loop | 00:00:00 | ||
Get Attribute Values | 00:00:00 | ||
What Is The XML Expat Parser? | 00:00:00 | ||
Initializing The XML Expat Parser | 00:00:00 | ||
Load And Output XML Using the Dom Parser | 00:00:00 | ||
Looping Through XML Using The Dom Parser | 00:00:00 | ||
Section 9 - AJAX | |||
What Is AJAX? | 00:00:00 | ||
Load Simple Data Using AJAX Front End | 00:00:00 | ||
Load Simple Data Using AJAX Back End | 00:00:00 | ||
Load Data From Database Using AJAX | 00:00:00 | ||
Section 10 - Emails | |||
Send A Plain Text Email | 00:00:00 | ||
Send A HTML Email | 00:00:00 | ||
Email Attachments | 00:00:00 | ||
PHPMailer Setup | 00:00:00 | ||
Send Email Using PHPMailer | 00:00:00 | ||
Send HTML Email Using PHPMailer | 00:00:00 | ||
Email Attachments Using PHPMailer | 00:00:00 | ||
Section 11 - Object Oriented Programming | |||
What Is Object Oriented Programming (OOP)? | 00:00:00 | ||
Basic Class With Variables | 00:00:00 | ||
Functions | 00:00:00 | ||
Constructor | 00:00:00 | ||
Destructor | 00:00:00 | ||
Inheritance | 00:00:00 | ||
Multi Class Inheritance | 00:00:00 | ||
Function Overriding | 00:00:00 | ||
Public vs Private vs Protected | 00:00:00 | ||
Interfaces | 00:00:00 | ||
Constants | 00:00:00 | ||
Abstract Class | 00:00:00 | ||
Static Keyword | 00:00:00 | ||
Final Keyword | 00:00:00 | ||
Initiating Parent Constructor | 00:00:00 | ||
Section 12 - Error Handling | |||
die() Function | 00:00:00 | ||
Custom Error Handler | 00:00:00 | ||
Triggering An Exception | 00:00:00 | ||
Exception Handling | 00:00:00 | ||
Create Database And Table | 00:00:00 | ||
User Class And Database Connection | 00:00:00 | ||
Register User Form | 00:00:00 | ||
Inserting User Data Into Database | 00:00:00 | ||
Registration Form Field Validation | 00:00:00 | ||
Securing User Password | 00:00:00 | ||
Check If Username Already Exists | 00:00:00 | ||
Retain Data After Failed Registration | 00:00:00 | ||
Section 13 - Advanced | |||
Validate An Integer Within A Range | 00:00:00 | ||
Validate IPv6 ADdress | 00:00:00 | ||
Validate URL - Must Contain QueryString | 00:00:00 | ||
Remove Characters With ASCII Value - 127 | 00:00:00 | ||
Including And Requiring External PHP Files | 00:00:00 | ||
Oracle Certification Readiness - Useful Links | 00:00:00 |