Skip to main content

Create JSON Using PHP and MySQL, A Simple API - #74

Like what you see, support the channel.

Published: September 24, 2021

Estimated Reading Time
2 minutes
Video Duration
55:35 minutes

Convert data from MySQL to JSON format using PHP, OOP, and PDO. This is a simple way to create information that can be read by an external application. In this tutorial, we create an application that makes data accessible on different platforms regardless of code. We create a REST or RESTful API that takes data from a server opens it to your applications. Converting the data to JSON is the first step to building your own API.

Last week, we create a authentication script using Vanilla JavaScript, this week, we take the idea from there and create the API that script will use to login in with.

Become a Patreon to show support and get exclusive access to content:

Applications Used

Visual Studio Code v1.43:

WAMP v3.2.0:

Computer Hardware:

Windows 10 Pro: (Amazon)

Samsung 500GB External SSD: (Amazon)

Samsung 970 EVO Plus SSD 1TB - M.2 NVMe: (Amazon)

Rosewill Hive-750S R750W PSU: (Amazon)

Phanteks Eclipse Tempered Glass Case: (Amazon)

MSI Arsenal Gaming AMD Ryzen Motherboard: (Amazon)

MSI Gaming GeForce RTX 2060 Super 8GB: (Amazon)

LG 34UM69G-B 34-Inch 21:9 UltraWide IPS Monitor: (Amazon)

Corsair 64GB (4 x 16GB) DDR4 Memory: (Amazon)

AMD Ryzen 7 2700X Processor: (Amazon)

Dell XPS 15 9500 15.6" Laptop / Windows: (Amazon)

Lenovo ThinkPad T15 15.6" Laptop / Linux: (Amazon)


Fujifilm X-T3: (Amazon)

Fujinon XF18-55mmF2.8-4: (Amazon)


Audio Technica AT2020: (Amazon)

Blue Snowball iCE: (Amazon)


I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to and affiliated sites.