Full Tutorial: PHP & MySQL Database Integration + How to Build a Simple REST API!
Is your website still static, losing all its data the moment you close the page? 😱 Don't panic! In this video, we are going to learn how to make your website data permanent by connecting a PHP web application to a MySQL database.
This video is part of our Web Programming course series. Here, we won't just discuss the basic theory of what a database is and how to design a relational database, but we will also do a hands-on coding session covering full CRUD (Create, Read, Update, Delete) operations!
For the database connection, we will be using the modern PDO (PHP Data Objects) method, which is much more secure and helps prevent SQL Injection attacks.
But we won't stop at building a standard website! In the second half of this video, we will "level up" by discussing Web Services. We will build a simple REST API from scratch that responds in JSON format, complete with input validation, and then test it live using the Postman app!
👨🏫 Instructor: Dr. Achmad Arwan, S.Kom., M.Kom.
🎓 Faculty of Computer Science, Universitas Brawijaya
Don't forget to prepare XAMPP, phpMyAdmin, your favorite code editor, and the Postman app so you can code along with us!
👍 If you found this video helpful, make sure to hit the LIKE button, share it with your fellow developers, and SUBSCRIBE so you don't miss out on more awesome Web Programming content! If you run into any errors or have questions while coding, drop them in the comments section below! 👇
#Tags / Hashtags:
#PHP #MySQL #RESTAPI #WebProgramming #LearnToCode #PHPTutorial #Database #PDO #Postman #FILKOMUB #ITStudent #Coding #webdevelopment