Building Database Web App PHP | OOP | PDO | AJAX | MySQL

Course Curriculum

Chapter 1: Section 1 – Setting up Server Environment

Lecture 1: Course Introduction and File Download

Lecture 2: Fixing Admin Dashboard Error – Solution

Lecture 3: Downloading and Installing Local Server

Lecture 4: Downloading and Installing Code Editor & plugins

Lecture 5: Setting up the Environment Final Step

Chapter 2: Section 2 – PHP Fundamentals

Lecture 1: PHP Introductions

Lecture 2: Syntax – open, echo, string

Lecture 3: PHP Variables, Logical & Comparison Operators

Lecture 4: Statement – if, else, elseif

Lecture 5: Array – Indexed, Associative

Lecture 6: Exercise 1 with Solution And Explanation

Chapter 3: Section 2 – PHP Advance

Lecture 1: Loops – foreach

Lecture 2: Functions and Arguments

Lecture 3: Include & Super Global

Lecture 4: Super Globals $_SERVER, $_POST $GET

Lecture 5: Filters – Validate and Sanitize

Lecture 6: Echo & Concatenation

Lecture 7: Exercise 2 with Solution And Explanation

Chapter 4: Section 3 – Object Oriented Programming OOP Basics

Lecture 1: OOP Overview

Lecture 2: Object

Lecture 3: Classes

Lecture 4: Properties

Lecture 5: Property Declaration {Access Modifier}

Chapter 5: Section 3 – Object Oriented Programming OOP Advance

Lecture 1: Static Methods and Properties {:: scope resolution operator}

Lecture 2: Class Inheritance

Lecture 3: Construct & Destruct methods

Lecture 4: Exception Handling {Error Messages}

Lecture 5: Exercise 3 with Solution and Explanation

Chapter 6: Section 4 – MySQL Database

Lecture 1: Overview of MySQL

Lecture 2: Creating Database and Tables

Lecture 3: Connecting to Database and SQL Syntax & Functions

Lecture 4: Inserting / Updating Data

Lecture 5: Selecting / Deleting Data

Lecture 6: Looping through your results and Displaying it

Chapter 7: Section 5 – PHP Data Objects {PDO}

Lecture 1: Overview of PDO Database abstraction layer

Lecture 2: Understanding PDO class and its Methods

Lecture 3: Understanding PDO Statement Class and its Methods

Lecture 4: Understanding PDO Statement Class Cont.. & Exception Class

Lecture 5: Exercise: Creating our Database Class and Testing Connection

Lecture 6: Creating our Database Helper functions and Instantiating our Class

Lecture 7: Performing CRUD Functionalities Using PDO

Chapter 8: Section 6 – PHP Forms

Lecture 1: Form Overview , Getting and Filtering (Cleaning) Data

Lecture 2: Passing Data to Database using Our PDO functions

Lecture 3: Getting Data from Database and Displaying in our form

Lecture 4: Updating Data into our Database using our form

Chapter 9: Section 7 – Asynchronous JavaScript and EXtensible Markup Language – AJAX

Lecture 1: AJAX Overview

Lecture 2: Understand JQuery AJAX .ajax() & .post() Methods

Lecture 3: Creating Functions withs JQuery AJAX .ajax() Method

Lecture 4: Creating Functions withs JQuery AJAX .post() Method

Chapter 10: Section 8 – Database Wep App Project – Front-End

Lecture 1: Project Overview and Dummy File Download

Lecture 2: Creating our Database with phpAdmin

Lecture 3: Creating our Helper Functions

Chapter 11: Section 9 – Database Wep App Project – Admin Section

Lecture 1: Admin Registrations Collecting and Cleaning Form Data

Lecture 2: Admin Registration, Processing Form Data

Lecture 3: Collecting Data and Processing Login

Lecture 4: Creating Sessions data for Logged in Users

Lecture 5: Using our sessions to control pages and display profile images

Lecture 6: Working on my_admin account after login

Lecture 7: Processing Admin Account Deletion

Lecture 8: Processing Admin Updating / Editing

Lecture 9: Wrapping up Admin Section

Chapter 12: Section 10 – Database Wep App Project – Customers Section

Lecture 1: Fixing Links and Securing Pages

Lecture 2: Registering New Customer

Lecture 3: Avoiding Duplicates and Displaying all Customers

Lecture 4: Editing Customers

Lecture 5: Deleting Customers

Lecture 6: Reports: Fetching results using AJAX .ajax() Method

Lecture 7: Reports: Displaying Customer Information using AJAX .get() Method

Lecture 8: Reports: Posting Form Data using AJAX .post() Method

Lecture 9: Emailing our customers

Lecture 10: Wrapping up and Testing Our App in Local Environment

Chapter 13: Section 10 – Upload File to Servers

Lecture 1: Overview of Hosting

Lecture 2: Using File Zilla to Transfers files to online hosting account

Lecture 3: Exporting and Importing Database to online Database

Lecture 4: Testing our Application & Fixing all Issues

Lecture 5: Fixing File Upload Security Issue