Learn PHP and MYSQL- Build a Customer Loyalty Reward System.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Set up the dashboard template

Lecture 3: Getting familiar with our dashboard template files

Lecture 4: Understanding the flow of how we are going to create the system

Chapter 2: Adding cashiers

Lecture 1: Importing database table and creating cashier table.

Lecture 2: Connecting to our database

Lecture 3: Add name attribute to our form input tags.

Lecture 4: Learn more on post method, server, php_self and isset function

Lecture 5: Collect form input values and insert them into the database.

Lecture 6: Clean form input values-sanitize.

Lecture 7: Backend validation using PHP.

Lecture 8: Display backend validation errors messages

Lecture 9: Test backend validation.

Lecture 10: Clientside validation-add span with IDS-Part 1

Lecture 11: Clientside validation-collect form input values-Part 2

Lecture 12: Clientside validation-write validation rules-Part 3

Lecture 13: Clientside validation-test validation-Part 4

Chapter 3: Login and redirect to specific dashboard.

Lecture 1: Add name and id attribute to form inputs

Lecture 2: Collect login form input values.

Lecture 3: Login form-backend validation using PHP

Lecture 4: Clientside validation – add spans and their IDS

Lecture 5: Clientside validation – collect form input values

Lecture 6: Clientside validation – validate form input values

Lecture 7: Login and redirect to specific dashboards

Lecture 8: Logout cashiers and managers

Lecture 9: Redirect to the specific dashboard and secure routes.

Lecture 10: Secure login page if already logged-in

Chapter 4: View cashier profile details

Lecture 1: Create a single file for the shared details

Lecture 2: Fetch cashier details and display them

Lecture 3: Get cashier ID and separate update password forms

Lecture 4: Add name and ID attribute password form input

Lecture 5: Password form input backend validation

Lecture 6: Clientside validation part 1

Lecture 7: Clientside validation part 2

Lecture 8: Update cashier password from cashier profile page

Chapter 5: View all cashiers and customers

Lecture 1: View all customers

Lecture 2: View all cashiers

Lecture 3: Add JQuery-datatable plugin on customers table

Lecture 4: Add JQuery-datatable plugin on cashiers table

Lecture 5: Add name, ID attribute, form action and get cashier ID -UPDATE PASSWORD

Lecture 6: Get cashier ID and form input values -UPDATE PASSWORD

Lecture 7: Backend and clientside validation – UPDATE PASSWORD

Lecture 8: Update the old password with the new password

Lecture 9: Get cashier ID and retrieve the data from the database

Lecture 10: Display the fetched cashier details on the form input(populate update form)

Lecture 11: Check the ID, name and span attribute for the update form

Lecture 12: Collect the form input values

Lecture 13: Backend validation-part 1

Lecture 14: Backend validation-part 2

Lecture 15: Client side validation-collect form input values – part 1

Lecture 16: Clientside validation-write validation rules- part 2

Lecture 17: Insert the new cashier details on the database

Lecture 18: Test the update cashier details functionality

Chapter 6: Reward customers with points

Lecture 1: Create the reward limit database table and populate it

Lecture 2: Fetch reward limit from the database and display it

Lecture 3: Fetch the reward limit from the database and populate the update form

Lecture 4: Add name, ID attribute on the update limit form input

Lecture 5: Collect form input values using PHP

Lecture 6: Backend validation using PHP

Lecture 7: Collect form input values-clientside validation part 1

Lecture 8: Create clientside validation rules- clientside validation part 2

Lecture 9: Insert the new reward limit to the database

Lecture 10: Create customer reward points form

Lecture 11: Output the reward limit on the reward points page

Lecture 12: Add reward points form action, ID, name attribute

Lecture 13: Collect form Input values using PHP.

Lecture 14: Refactor code for easier validation.

Lecture 15: Backend validation in PHP.

Lecture 16: Reward customers with points

Lecture 17: Collect form input values – clientside validation part 1

Lecture 18: Write clientside validation rules and test them – clientside validation part 2

Lecture 19: View all rewarded points

Lecture 20: View all transferred points

Lecture 21: View all Redeemed points

Lecture 22: Get the sum of all rewarded and redeemed points

Lecture 23: Count the number of all registered customers

Lecture 24: Get the ten recent rewarded points