Ultimate Hypertext Preprocessor And MyStructured Query Language Web Development Course

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.

No ratings yet
Course Skill Level
Beginner
Time Estimate
10h 5m

I am CEO of Sonar Systems which is the world leader in educational material.

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

Are you interested in higher education?