Understanding Advance PHP Techniques with OOP | AJAX | MySQL

Course Curriculum

Chapter 1: Planning & Setting up Environment

Lecture 1: Introduction

Lecture 2: Overview of Freelance PHP Development

Lecture 3: Planning our Project with Project Management Methodology

Lecture 4: Building a Gantt Chart for Task Tracking

Lecture 5: Setting up and Testing Environment

Chapter 2: Excel to Database and Creating Additional Databases

Lecture 1: Exporting Excel File for MySQL Database

Lecture 2: Creating our Databases

Chapter 3: Creating our Functions and Classes

Lecture 1: Creating our Helper Functions

Lecture 2: Database class using PDO Part 1

Lecture 3: PDO Class Part 2

Lecture 4: PDO Class Part 3

Lecture 5: Creating our PHPMailer Class

Lecture 6: Setting up the project and Files

Chapter 4: Implementing our Login / Registration

Lecture 1: Creating Functions to Process Form Data

Lecture 2: Processing Form Data to Database

Lecture 3: Testing Registration and Debugging

Lecture 4: Function to Login User

Lecture 5: Processing User Sessions

Lecture 6: Page Security and Logout

Chapter 5: Updating User and User Page Customization

Lecture 1: Processing User Update Form

Lecture 2: Passing Data Values to Database

Lecture 3: Update Progress Bar and Customizing Dynamic Page

Chapter 6: Implementing Messaging Functionality

Lecture 1: Processing Messaging

Lecture 2: Processing Emailing Admin with File Attachement

Lecture 3: Passing Sent Messages to Database

Lecture 4: Creating Inbox and Reply Page

Lecture 5: Fetching Data from Database to Inbox

Lecture 6: Working on Replying Message

Lecture 7: Posting Reply Messages

Lecture 8: Deleting Messages and Reply Messages

Chapter 7: Membership Validation and Package Purchase

Lecture 1: Building functions to check membership status

Lecture 2: Processing Package Purchase | Package Selection Form 1 | Sample Page

Lecture 3: Processing Package Purchase | Package Details Form 2 | Sample Page

Lecture 4: Processing Package Purchase | Order Summary / Saving Order Form 3 | Sample Page

Lecture 5: Processing Save Order for Future Purchase

Lecture 6: Getting and Displaying Saved Orders on From 4 | Same Page

Lecture 7: PayPal Checkout Form Integration with Dynamic Values

Chapter 8: Implementing Admin Panel Management System

Lecture 1: Admin Employers and Admin Users

Lecture 2: Processing Employer and Admin Login

Lecture 3: Adding Product to Database From Dashboard

Lecture 4: Displaying Totals and Summary in Dashboard

Lecture 5: Reading Database Tables Data in Dashboard

Chapter 9: Managing Clients from Admin Panel

Lecture 1: User Account Dynamic Page Deletion

Lecture 2: Messaging Client

Lecture 3: Replying Client

Lecture 4: Debugging Client Messaging & Replying Issues

Chapter 10: AJAX Dynamic Search

Lecture 1: Creating the Dynamic Search Criteria

Lecture 2: Creating AJAX Functions using the POST Method

Lecture 3: Fetching Data Dynamically as User Types in Search Box with AJAX

Chapter 11: User Account and Preference Settings

Lecture 1: Processing Data from User Settings

Lecture 2: Executing User settings Update

Lecture 3: Deleting users completely from Database

Lecture 4: Implementing User Settings

Chapter 12: PayPal API Payment Data Transfer Integration & Verification

Lecture 1: Getting Sandbox Account and PDT Token

Lecture 2: Getting Data from PayPal

Lecture 3: Building our verification POST Request Using cURL PHP

Lecture 4: Building and Processing Our Request

Lecture 5: Building and Processing Our Request Part 2

Lecture 6: Creating Functions to Process Orders on Successful Verification

Lecture 7: Creating Functions to Process Orders on Successful Verification Part 2

Chapter 13: Bonus Lecture On Pagination

Lecture 1: Creating Pages

Lecture 2: Building Functions with PDO Database Class

Lecture 3: Getting, Offset, Current and Ending Pages

Lecture 4: Creating Pagination Control Buttons

Lecture 5: Implementing Pagination Function

Chapter 14: Bonus Lecture on How to Migrate your Project from Local to Live Host

Lecture 1: Hosting Overview & the CPanel

Lecture 2: Using FileZilla to upload files

Lecture 3: Importing and Exporting your Database Tables to Online Database

Chapter 15: Testing Our Live App And Debugging Errors

Lecture 1: Uploading Your File Summary

Lecture 2: Testing Users Section of our App

Lecture 3: PayPal API Processing & Payment Verification Testing

Lecture 4: Testing Admin Section of our App