Learn USSD application development using PHP and MySQL

Name: Learn USSD application development using PHP and MySQL
Rating: 4.3 (68 reviews)

Gain more knowledge in USSD application development from scratch in PHP and MySQL! The complete guide!

Created byAlex Mureithi Njagi

Last updated 1/2024

English

What you'll learn

Creating a USSD application in PHP and MySQL
Creating interactive USSD menu
Testing USSD application on the web browser
Collecting and inserting user input on the USSD and saving the data into the database
Creating a customer loyalty USSD application
Deploying USSD application on a live server
Testing USSD application on a live simulator
Learn Uses of USSD application
Learn how USSD application works on the backend
Creating a fully working customer loyalty points wallet USSD application
Authenticatication in USSD application

Course content

2 sections • 18 lectures • 4h 19m total length

Introduction9:02
Explore how to build USSD applications with PHP and MySQL using interactive menus to collect data from database and check balances, then test locally and deploy to a live domain.

1: Demo of the application we are going to build.5:05
In this section, we are going to learn what we are going to build throughout the course
2: What we will build.4:08
3: Setting up our USSD main application script.7:48
4: Create our first USSD menu.10:16
5: Interacting with our USSD menu.11:29
Master interacting with a USSD menu, handling input, and performing registration, purchases, and balance checks via PHP and MySQL.
6: Collect customer input(data) during registration.15:01
Learn how to design USSD user input flows for customer registration, collecting first name, last name, email, and phone number, then storing the data in a PHP and MySQL backend.
7: Create the database and customer registration table.9:49
8: Inserting USSD input into the database table.10:52
Insert USSD input into the database using PHP and MySQL by mapping phone numbers, names, email, and password to a structured table, with duplicate registration checks.
9: Check if a customer already exist on the customer table.10:15
Learn how to verify a phone number's uniqueness by checking the customer table in a PHP and MySQL app, counting existing records, and conditionally registering the number.
10: Check a single customer password.19:26
11: Create other required database tables.11:01
12: Check a single customer points balance.26:38
13: Functions to check if customer exist and generate unique alphanumeric.10:44
Learn how to create PHP and MySQL functions for USSD apps that generate unique alphanumeric reference numbers and verify customer existence during point transfers.
14: Transfer of points from one customer to the other.32:38
15: Customer purchase items with points.18:48
16: Customer update his or her password.12:39
Learn to implement a USSD password update in a PHP and MySQL app, validating a registered account by phone number and updating the password in the database.
17: Push our USSD application to a live server and testing on a simulator.34:13

Requirements

Should have knowledge in PHP and MYSQL
Should have installed XAMPP or WAMP servers on their laptops
Willing to learn

Description

Would you like to create a USSD application using PHP and MySQL? In this course, I will teach you how to create a complete USSD application in PHP and MySQL. I will help you make good use of your PHP and MySQL skills. We will use PHP as our scripting language and MySQL as our database management system. We will create a complete customer loyalty points wallet, whereby a customer will be able to register, check points balance, transfer points to other registered customers, log in to the USSD application, purchase items with points, and reset the password. I will also teach you how we will test the application on a web browser and then later on a live simulator on the internet

Configure USSD application on our localhost
Create an interactive USSD menu
Collect user input and insert it into the database
Fetch user input and display the request details
Authenticatication in USSD application
At the end of the course, we will have created a fully working customer loyalty points wallet USSD application.

Tools required for this course

Web browser
Xampp comes with PHP and Mysql
Self-discipline
Africanstalking account(optional)

Who is this course meant for

This course is for all students who want to create offline(no internet connection) applications that can be accessed by any type of phone.
This course is for beginner and intermediate learners in PHP and MySQL who want to make an exercise their backend development skills.

Who this course is for:

Beginner PHP and MySQL students
Tech savy individual

Learn USSD application development using PHP and MySQL

What you'll learn

Explore related topics

Course content

Introduction to USSD application(THEORY)1 lecture • 9min

Creating our USSD application17 lectures • 4hr 11min

Requirements

Description

Who this course is for: