Learn PHP and MYSQL- Build a Customer Loyalty Reward System.
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
Instructor
![Alex Mureithi Njagi](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.6 Instructor Rating
- 58 Reviews
- 156 Students
- 2 Courses
I’m a freelance System Administrator with over 10 years of experience in IT. I’ve been working with Linux and Windows Environments for more than 5 years, an Open Source enthusiast and highly motivated on Linux Servers' installation, support, and troubleshooting. Mostly working with Debian and RedHat Linux, Apache/MySQL administration, and Web Development on WordPress, PHP, MySQL, HTML5, CSS3, javascript & Django (Python) framework.
I also enjoy teaching and tinkering with new and unique technologies to solve day-to-day problems.