Create JSON Using PHP and MySQL, A Simple API - #75
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 an authentication script using Vanilla JavaScript, this week, we take the idea from there and create the API that the script will use to login in.
00:00 Intro
02:45 Setup Folder Structure
03:47 Autoloader
05:54 PDO Database Class
12:18 Build Script to Create Tables and Content
32:05 Setup Frontend Pages
39:56 Create Users Class
47:07 Create User Authentication Page
Vanilla JS Form Validation and Authentication (Part 1): • Login Validation & Authentication, Javascr...
Convert Data from MYSQL to JSON (Part 2): this video
JS Fetch with PHP RESTful API (Part 3): • Create JSON Using PHP and MySQL, A Simple ...
Become a Patreon to show support and get exclusive access to content: / devdrawer
`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````
Subscribe: https://bit.ly/2Wbsnj9
`````````````````````````````````````````````````````````````````````````````````````````````````````````````````````
Join us on our blog for video recaps and other tutorials: https://thedevdrawer.com
Become a fan on Twitter: / thedevdrawer
Applications Used
Visual Studio Code v1.43: https://code.visualstudio.com/
WAMP v3.2.0: http://www.wampserver.com/en/ #php #phptutorial #development #code #programming #webdesign
Computer Hardware:
Windows 10 Pro: https://amzn.to/3q5TyZw (Amazon)
Samsung 500GB External SSD: https://amzn.to/2ViAAAF (Amazon)
Samsung 970 EVO Plus SSD 1TB - M.2 NVMe: https://amzn.to/36jDwDy (Amazon)
Rosewill Hive-750S R750W PSU: https://amzn.to/36jiDbs (Amazon)
Phanteks Eclipse Tempered Glass Case: https://amzn.to/39qou0B (Amazon)
MSI Arsenal Gaming AMD Ryzen Motherboard: https://amzn.to/36hpAKm (Amazon)
MSI Gaming GeForce RTX 2060 Super 8GB: https://amzn.to/36hMyRm (Amazon)
LG 34UM69G-B 34-Inch 21:9 UltraWide IPS Monitor: https://amzn.to/2HSRxyI (Amazon)
Corsair 64GB (4 x 16GB) DDR4 Memory: https://amzn.to/3mlmQkI (Amazon)
AMD Ryzen 7 2700X Processor: https://amzn.to/3qdQIBF (Amazon)
Dell XPS 15 9500 15.6" Laptop / Windows: https://amzn.to/3fKEz2w (Amazon)
Lenovo ThinkPad T15 15.6" Laptop / Linux: https://amzn.to/2Jnmn33 (Amazon)
Camera:
Fujifilm X-T3: https://amzn.to/3llKBb5 (Amazon)
Fujinon XF18-55mmF2.8-4: https://amzn.to/3mfTkNb (Amazon)
Audio:
Audio Technica AT2020: https://amzn.to/2VgxU6K (Amazon)
Blue Snowball iCE: https://amzn.to/3lo1jGC (Amazon)
DISCLAIMERS:
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 Amazon.com and affiliated sites.
View Project on GitHub: https://github.com/thedevdrawer