Restful API Web Services with PHP and MySQL: Bootcamp

Name: Restful API Web Services with PHP and MySQL: Bootcamp
Rating: 4.3 (177 reviews)

PHP, MySQL, Rest Controller, Exception Handler, Postman, Validation, JWT Token Authentication, GET, POST, PUT, DELETE

Created byMetla Sudha Sekhar

Last updated 11/2025

English

What you'll learn

How to build a RESTful web services (API) with plain PHP (no frameworks required)
Fundamental Principles of RESTful API
How to work with MySQL database with CRUD files using a REST API
What JWT - Token Based Authentication is and why it is better than Basic Authentication
API Testing using Postman App step by step
Applying Restful API HTTP methods GET, POST, PUT and DELETE
You will learn 2 real world projects while learning and writing the Restful API services
Create Restful API Web services for your Mobile apps
learn What is Generative AI for prompt engineering
participate in a Coding Exercise to test your learning skills
Learn how to boost productivity and save time using AI-driven platforms

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

8 sections • 59 lectures • 4h 57m total length

Introduction to Getting Started1:55
you will learn introduction from this lecture
Course Curriculum3:05
you will learn course curriculum from this video lecture
How to Get Pre-Requisites1:52
you will learn how to get pre-requisites to setting up your local development environment
Getting Started on Windows, Linux or Mac1:03
choosing and start which operating system you will know here
How to ask a Great Questions1:18
you will be guided how to ask a great questions
FAQ’s1:19
faq's about course you will know here
What is Source code8:47
you will learn file extension and source code notes
Learn What is Generative AI / Gen AI14:06
Generative artificial intelligence is artificial intelligence capable of generating text, images, videos, or other data using generative models, often in response to prompts. best ai tools are chatgpt, tabnine for developers, and more
Best Practices for Learning Online Course5:14
You will learn how to learn online courses in a more productive way.

Section Introduction2:05
you will learn section introduction here
XAMPP Installation for PHP, MySQL and Apache12:05
you will know step by step process to install xampp environment for PHP software application development environment
Choosing code editor3:13
you will learn choosing code editor, if you already familiar any of code editor which can be used to write PHP code also perfectly use than you may skip this lecture
Installing code editor (Sublime text)3:48
you will know how to get and install sublime text editor
Installing code editor (VS code)6:33
you will learn how to get and install visual studio code editor
Postman API platform installation5:36
you will learn how to get and install POSTMAN API software package
Composer installation4:06
you will learn how to get and install composer to get resources to get and use for API service
Creating a project on xampp3:27
you will learn how create a php basic project and run to test local development environment functional for project creation and running
PHP hello world program5:45
you will learn how to write a first hello world program
Summary1:46
summary for this section you will know what you learn from this section
Welcome program exercise

Section Introduction1:37
this is section introduction what you will learn from this section explained here
What is PHP8:00
you will know about PHP and its features
What is Restful API5:23
you will learn what is Restful API and its methods explained here
HTTP request GET, POST, PUT or DELETE8:02
you will know HTTP methods and its code message to easily understand the status of API service on live
REST API project structure6:13
Restful API project structure explained here
Summary1:29
you will learn summary for this section

Section Introduction1:26
you will learn section introduction
Create Database and table6:01
you will learn create database and tables for this project real-world exercise using PHPMyAdmin
Creating Project forms and folders5:04
you will learn creating project structure folders and php forms
Database Connection12:57
you will learn database connection for this project
JSON Web Token Handler(JWT)13:57
you will learn JWT token source - code writing here
Auth Middleware Token Validation22:42
you will learn auth middleware validation to authorization a login user
Register form20:16
you will be learn creating a registration form using Restful API
Login form14:11
you will learn login form functionality on Restful API
User Token Authorization check form12:11
you will learn login user authorization check and confirming is correct user or not to making more secure API services
Summary1:27
you will learn summary for this section

Section Introduction1:20
you will learn section introduction here
Create Database and table6:10
you will learn project2 database and table
Adding Data to table - insert query3:10
you will learn how to insert multiple data records into a created table
MySQL Select query5:35
you will learn how to write a basic select query statement to read data from MySQL database table
MySQL Update query3:52
you will learn update query statement to modifying already inserted data on MySQL table
MySQL Delete query1:55
you will learn delete query statement
Get Project2 Source Code2:25
you will know how to get project source code for this project
Create Database Connection1:53
you will learn how to write database connection using MySQLI_connect method for project2
Summary1:03
you will learn summary for this section

Section Introduction1:15
you will learn section introduction here
Create Items Class PHP File4:26
Create Method form4:18
you will learn create method inside the class file
Creating Record Using Restful API4:24
you will learn creating record API test using POSTMAN API app to send JSON data parameters
Reading Method form2:10
you will learn read data from database using Restful API form
Reading Record Using Restful API2:46
you will learn API test using POSTMAN API app
Update Method form2:44
you will learn update method for coding
Update Record Using Restful API5:04
you will learn API test using POSTMAN API app
Delete Method form1:37
you will learn delete method form functionality
Delete Method Using Restful API1:52
you will learn POSTMAN API to test delete method test by sending JSON data parameters
Coding Exercise0:50
you will be assigned a simple coding exercise
Solution for Coding Exercise1:32
a solution for coding exercise
Summary1:17
you will know summary for this section

Requirements

Fundamentals of PHP (including basic Object Oriented Programming concepts)
You will learn everything you need to know Restful API
Fundamentals of MySQL Database (optional)
Fundamentals of Basic SQL Queries (optional)
Fundamentals of JSON (basic structure) optional

Description

Master the art of building robust web services with "RESTful API Web Services with PHP and MySQL: Bootcamp." This comprehensive course is designed to teach you how to create powerful, scalable, and secure RESTful APIs using PHP and MySQL. Whether you’re a beginner or looking to enhance your API development skills, this bootcamp will provide you with the knowledge and hands-on experience needed to develop APIs that interact seamlessly with databases and serve dynamic data to your web and mobile applications.

You’ll begin by learning the fundamentals of REST architecture and HTTP methods (GET, POST, PUT, DELETE), understanding how to design a RESTful API that is easy to use and follow. From there, you’ll dive into PHP for backend development, exploring how to handle requests, process data, and create responses in JSON format. Additionally, you’ll learn to connect your API with MySQL databases to retrieve, update, and store data.

update: Learn the top AI tools every professional needs to boost productivity

The course includes practical, real-world projects, such as building a user authentication system, handling CRUD (Create, Read, Update, Delete) operations, and ensuring security with JWT (JSON Web Tokens). By the end of the bootcamp, you'll be able to create fully functional, secure, and efficient RESTful APIs that can power web and mobile applications.

Whether you're developing APIs for e-commerce sites, mobile apps, or enterprise-level systems, this course will give you the skills to succeed in API development.

Enroll today and start building your RESTful APIs with PHP and MySQL!

Who this course is for:

Beginner PHP developer like to build curious about Restful API web services
PHP developers who would like to build Web Service APIs using only core PHP (no frameworks)
PHP developers making secure Apps with Token Based Authentication to their APIs
PHP developers interested in how you write CRUD files to work with MySQL Data using APIs
Anyone who wants to become a freelancer on Restful API Web services

Restful API Web Services with PHP and MySQL: Bootcamp

What you'll learn

Explore related topics

Coding Exercises

Course content

Introduction9 lectures • 39min

Future Essential AI Tools for Every Professional1 lecture • 5min

Setting up Local Development Environment10 lectures • 48min

Restful API Basic6 lectures • 31min

Project1: Restful API Login and Registration10 lectures • 1hr 50min

Project2: Restful API – MySQL Database9 lectures • 27min

Restful API – Web Services13 lectures • 34min

Apache .htaccess file1 lecture • 2min

Requirements

Description

Who this course is for: