Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Getting Started with PHP and MySQL Development
Introduction to PHP
Introduction to PHP, Requirements
Getting XAMPP and Brackets, Starting Server
First PHP Script
Variable in PHP
If, if else, if else if..., Switch
While, Do While, For, Foreach
Object Oriented Features
Functions in PHP
Require, Include and some String Functions
Classes Overview
Scoping Rules and the Global Keyword
Static Properties
Arrays and Variables
Arrays in PHP
$_SERVER Variables in PHP
$_GET in PHP
$_POST in PHP
$_REQUEST in PHP
MySQL Database Insight
Using PHPMyAdmin
Sample Database
Connecting to MySQL
Inserting to MySQL, and Wrapup
Introduction and Installation of MySQL
Installing MySQL
Database Creation
Table Creation with SELECT and INSERT
MySQL Data Types
Creating an Auto Incrementing Primary Key
MySQL Basic Statments
Describe Table
Loading sql Files into MySQL
Introduction to SELECT Query
SELECT Query Demo
MySQL Advanced Statements
MySQL Update Query
Mathematical Operations
DISTINCT, COUNT and GROUP by Clauses
Table Relationships
Introduction to Joins
MySQL Advanced Statements Part 2
The Delete Query
Types of Joins
Joins Demo
Creating and Using Views
Setting Up a Many to Many Relationship
Demo of Many to Many Relationship
Static Properties
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock