Learn PHP and MYSQL- Build a Customer Loyalty Reward System

Lets learn how to build a customer loyalty reward system in HTML5, CSS3, JavaScript, jQuery, PHP and MYSQL.

What you’ll learn:
How to create a customer loyalty reward system
How to create a database
Importing database tables
Backend development in PHP and MYSQL
How to authorize and authenticate a user using sessions
Creating and testing backend validation rules using PHP
Creating and testing clientside validation using javascript
Using Jquery datatable plugin for(search, pagination and filtering)

Requirements
Be able to read and write code
Should have installed XAMPP or WAMP on your laptop
Knowledge of web development i.e. html5, css3, javascript, bootstrap, PHP and MYSQL
Installed a code editor like visual studio code, sublime text or notepad++

Description
In this course, we are going to learn how to create a dashboard for rewarding customers with points after making a purchase. We will build a system in HTML5, CSS3, JavaScript, jQuery, PHP, and MYSQL to reward our customers with points for the total purchase of goods they purchase. The system will also have a cashier role management whereby our system will redirect cashiers to a different dashboard for example if a cashier has the role of a cashier he/she will be redirected to the cashier dashboard and if a cashier has a role of a manager he/she will be directed to the manager dashboard. We will also secure different routes to prevent users from not accessing pages that they are not supposed to. Our system will also give different cashiers different functionality like the cashier will have a functionality to give points only then the manager will have a functionality to reward points to customers view all rewarded, transferred and redeemed points, also the manager will have the functionality to add, view, and edit cashiers details and edit reward rate.

Join me in this course and we will learn the following.

Adding cashier users with different roles

Backend and clientside form validation

Editing cashier details

Adding and updating points rate/limit

Rewarding customers with points

How to manage different cashier roles using sessions

Updating cashier password

Protecting different sections of the system according to cashier roles

Who this course is for
Beginner PHP and MYSQL students
Anybody interested in web development using PHP and MYSQL
Eager and willing to learn