Name: Learn PHP and MYSQL- Build a Customer Loyalty Reward System.
Rating: 4.3 (17 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byAlex Mureithi Njagi

Last updated 7/2021

English

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)

Course content

6 sections • 77 lectures • 13h 20m total length

Introduction15:42
Set up the dashboard template8:02
Getting familiar with our dashboard template files8:55
Understanding the flow of how we are going to create the system11:25

Importing database table and creating cashier table.12:13
Connecting to our database8:35
Add name attribute to our form input tags.6:23
Learn more on post method, server, php_self and isset function15:08
Collect form input values and insert them into the database.30:06
Clean form input values-sanitize.11:20
Backend validation using PHP.37:47
Display backend validation errors messages11:26
Test backend validation.5:48
Clientside validation-add span with IDS-Part 18:34
Clientside validation-collect form input values-Part 212:49
Clientside validation-write validation rules-Part 331:48
Clientside validation-test validation-Part 47:16

Add name and id attribute to form inputs4:40
Collect login form input values.5:29
Login form-backend validation using PHP13:47
Clientside validation - add spans and their IDS2:39
Clientside validation - collect form input values7:13
Clientside validation - validate form input values6:57
Login and redirect to specific dashboards22:16
Logout cashiers and managers12:13
Redirect to the specific dashboard and secure routes.9:17
Secure login page if already logged-in7:56

View all customers12:09
View all cashiers11:25
Add JQuery-datatable plugin on customers table8:23
Add JQuery-datatable plugin on cashiers table10:43
Add name, ID attribute, form action and get cashier ID -UPDATE PASSWORD10:15
Get cashier ID and form input values -UPDATE PASSWORD4:35
Backend and clientside validation - UPDATE PASSWORD12:05
Update the old password with the new password13:38
Get cashier ID and retrieve the data from the database13:03
Display the fetched cashier details on the form input(populate update form)13:15
Check the ID, name and span attribute for the update form3:19
Collect the form input values7:19
Backend validation-part 116:22
Backend validation-part 28:22
Client side validation-collect form input values - part 110:50
Clientside validation-write validation rules- part 217:39
Insert the new cashier details on the database9:25
Test the update cashier details functionality3:07

Create the reward limit database table and populate it3:53
Fetch reward limit from the database and display it9:26
Fetch the reward limit from the database and populate the update form8:39
Add name, ID attribute on the update limit form input6:18
Collect form input values using PHP3:57
Backend validation using PHP7:06
Collect form input values-clientside validation part 15:35
Create clientside validation rules- clientside validation part 24:51
Insert the new reward limit to the database8:45
Create customer reward points form6:51
Output the reward limit on the reward points page5:42
Add reward points form action, ID, name attribute5:12
Collect form Input values using PHP.5:25
Refactor code for easier validation.8:47
Backend validation in PHP.20:48
Reward customers with points10:23
Collect form input values - clientside validation part 16:19
Write clientside validation rules and test them - clientside validation part 212:23
View all rewarded points17:42
View all transferred points14:28
View all Redeemed points11:45
Get the sum of all rewarded and redeemed points13:51
Count the number of all registered customers6:03
Get the ten recent rewarded points9:07

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

What you'll learn

Explore related topics

Course content

Introduction4 lectures • 44min

Adding cashiers13 lectures • 3hr 19min

Login and redirect to specific dashboard.10 lectures • 1hr 32min

View cashier profile details8 lectures • 1hr 6min

View all cashiers and customers18 lectures • 3hr 6min

Reward customers with points24 lectures • 3hr 33min

Requirements

Description

Who this course is for: