520 Course Overview
Learn about everything there is to know about PHP & MySQL Web Development and receive all the knowledge to use and leverage the powerful technology behind these amazing platforms with our Ultimate PHP & MySQL Web Development Course & OOP Coding course.
There is no limit to what you can do with this knowledge. PHP is one of the most popular languages in the world. It will give you SUPER POWERS in the web development world and job marketplace and provide you the opportunity to make really good money online and offline, developing dynamic applications.
So, enroll now and spike up your career curve!
- 131 Video Lessons
- 365 Days Access
Learning Outcomes
- Learn to Set Up on Windows, Mac, and Linux
- Familiarize Yourself With Online Code Editors
- Know About Basic File Syntax
- Understand Variable Naming and Data Types
- Acquire Knowledge About Basic Functions
- Develop an Understanding of Control Structures
- Gain a Solid Understanding of Error Handling
- Learn About Object-oriented Programming
Who is this course for?
Through This Course, You Can Build Your Career in These High Profile Fields:
- Web Developer
- Software Developer
- Front End Software Engineer
- Software Tester
- Modern App Developer
“Storytelling is the most powerful way to put ideas into the world today.”
— Robert McKee
Curriculum
| Section 01: Introduction & Setup | |||
 |
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 | ||
| Section 02: Basics | |||
|
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 | ||
| Section 03: Control Structures | |||
|
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 | ||
| Section 04: Functions | |||
|
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 | ||
| Section 05: Forms | |||
|
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 | ||
| Section 06: File Handling | |||
|
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 | ||
| Section 07: MySQL | |||
|
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 | ||
|
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 | ||
|
Insert Multiple Rows 00:05: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 | ||
| Section 08: XML | |||
|
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 | ||
| Section 09: AJAX | |||
|
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 | ||
| Section 09: AJAX | |||
|
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 | ||
| Section 11: Object Oriented Programming | |||
|
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 | ||
| Section 12: Error Handling | |||
|
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 | ||
| Section 13: Advanced | |||
|
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 | ||
CERTIFICATION
The PDF copy of Certificate of Completion can be claimed at the free of cost. If you need a hardcopy of this certificate, you have to pay an additional payment. The time for PDF certificate turnaround is 24 hours, and for the hardcopy, it is 3-7 working days.
community
Your learning doesn’t end after the course ends. Work on your plans, discuss with your classmates and get real-time feedback from qualified trainers.
What Is In For You:
- Enroll in an exclusive WhatsApp group with a dedicated trainer
- Exclusive Facebook group where there are regular contests and activities
- Members-only special discounts and access to private events
What our STUDENT says
Based on 812 Reviews
No Reviews found for this course.
Quality assured
100% Money Back Guarantee
In case you’re hesitating, consider our 100% guarantee for this John Academy class. If you find that it hasn't met your expectations, simply drop us a note after you've participated through all the lessons in the class and we’ll refund your entire class fees.
FAQ’s
Your learning doesn’t end after the course ends. Work on your plans, discuss with your classmates and get real-time feedback from qualified trainers.
At John Academy we have prepared a range of frequently asked questions that our students ask prior to joining our courses. We hope you find these questions useful. However, if you have a specific question that is not covered, please contact us.
To enrol onto one of our online courses is very easy. On the course page of the course you are interested in just click on the ‘Add to Cart’ button which will add the course to your shopping cart. This will then be followed by the checkout screen at which you can enter your payment details. Once your payment has successfully gone through, you will receive instant access to your online course. We will email you your course details and invoice straightaway to the email address you used to sign up.
Yes. With John Academy you will receive instant access to your course, meaning that you can study from anywhere in the world, as long as you have an internet connection. We have students taking our courses in over 80 countries worldwide.
Yes. You can purchase the course for someone else, whether it is a family member or friend. Just be sure to inform us after checkout so we can update the course details accordingly.
John Academy is not like a traditional college or institution where set dates for enrolment exist, we provide online training courses that are completely flexible. With our online training courses you can enrol and start your course at any time. You have complete control over your own learning.
All courses available at John Academy are studied online so you do not need to attend any training venue or classes.
You will receive instant access to your course once you have successfully completed the checkout. We send your login details for the course, along with a receipt for your payment straight away, to the email address used at checkout. Please make sure you therefore use the correct email address at checkout.
If you need help on the course just email our support team who will be able to guide and help you with whatever problem you are facing.
The PDF certificate’s turnaround time is 24 hours and for the hard copy certificate it is 3-9 working days, but it can be longer during busy periods.
At John Academy our courses are online and can be studied your own pace without any strict deadlines for completion throughout the duration of your course subscription.
Most of the courses available here at John Academy require little or no previous knowledge prior to enrolling. Our courses are ideal for beginners and those interested in the subject.
There is no age requirement to join the online training courses here at John Academy. Assuming that you can keep up with the learning material and study at your own pace, you shouldn’t have any problem learning.
Generally, you will receive access to the course for 12 months from the date of joining. Please check the individual course page for more details.
In the unlikely event that you should fail an exam, you will be given an opportunity to retake it.
The majority of our courses conform to the internationally accepted Centre for International Qualifications (CiQ) and Continuing Professional Development (CPD). CiQ and CPD are recognized nationally across the United States and internationally around the world, thus the CiQ & CPD Award should be recognized by academic institutions, public organizations and private companies. Your certificate will contain the John Academy CiQ & CPD Award.
Please use the Contact us page to contact us should you have a specific question which is not answered here.
Original Price $39
2 days left at this price!
$ 39.00Add to cart
100% Money Back Guarantee
- $ 39.00
- 1 year
- Advanced
- Course Certificate
- Number of Units131
- Number of Quizzes0
- 10 hours, 6 minutes Gift this course
Discover Our Similar Courses
English Spelling, Punctuation, and Grammar Online Course
Course Overview People will stare, make your lashes worth their while! The Lash & Brow Basics course can lead you to work with internet-based influencers, models, actors, even general people who want to enhance their beauty. These treatments tend to …
The Complete Communication Skills MasterClass
Course Overview People will stare, make your lashes worth their while! The Lash & Brow Basics course can lead you to work with internet-based influencers, models, actors, even general people who want to enhance their beauty. These treatments tend to …
Lash & Brow Basics
Course Overview People will stare, make your lashes worth their while! The Lash & Brow Basics course can lead you to work with internet-based influencers, models, actors, even general people who want to enhance their beauty. These treatments tend to …
Introduction to Landscape Paintings
Course Overview Do you want to make a lot of money and have control over your future? If you learn Python, you’ll be able to do so. And the Python Programming from Scratch course is bringing you exactly what you …