Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Getting Started with PHP and MySQL Development
Introduction to PHP
Introduction to PHP, Requirements (7:13)
Getting XAMPP and Brackets, Starting Server (2:36)
First PHP Script (5:55)
Variable in PHP (5:02)
If, if else, if else if..., Switch (10:04)
While, Do While, For, Foreach (9:15)
Object Oriented Features
Functions in PHP (5:44)
Require, Include and some String Functions (9:15)
Classes Overview (7:11)
Scoping Rules and the Global Keyword (3:36)
Static Properties (9:28)
Arrays and Variables
Arrays in PHP (10:37)
$_SERVER Variables in PHP (5:57)
$_GET in PHP (4:10)
$_POST in PHP (2:50)
$_REQUEST in PHP (3:57)
MySQL Database Insight
Using PHPMyAdmin (5:03)
Sample Database (1:59)
Connecting to MySQL (5:13)
Inserting to MySQL, and Wrapup (6:49)
Introduction and Installation of MySQL
Installing MySQL (5:35)
Database Creation (2:47)
Table Creation with SELECT and INSERT (6:28)
MySQL Data Types (12:49)
Creating an Auto Incrementing Primary Key (8:08)
MySQL Basic Statments
Describe Table (3:59)
Loading sql Files into MySQL (6:57)
Introduction to SELECT Query (6:36)
SELECT Query Demo (5:18)
MySQL Advanced Statements
MySQL Update Query (3:16)
Mathematical Operations (6:08)
DISTINCT, COUNT and GROUP by Clauses (4:04)
Table Relationships (7:49)
Introduction to Joins (5:57)
MySQL Advanced Statements Part 2
The Delete Query (4:38)
Types of Joins (6:06)
Joins Demo (4:38)
Creating and Using Views (2:44)
Setting Up a Many to Many Relationship (4:38)
Demo of Many to Many Relationship (6:34)
If, if else, if else if..., Switch
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock