Create a PHP REST API : Write a RESTful API from Scratch using Plain, Object-Oriented PHP and MySQL

Learn how to develop a complete, RESTful API using plain, object-oriented PHP, MySQL and best practices. Full API course, including authentication: ‣ https://davehollingworth.net/phpapisy Please consider supporting my channel: ☕ https://ko-fi.com/davehollingworth In this video you'll learn how to: • create RESTful URLs • list, show, create, update and delete database records using an API • organise your PHP code • use controllers and table gateways • return relevant HTTP status codes • validate data in an API • decode and encode requests and responses as JSON Code shown in the video: ‣ https://github.com/daveh/php-rest-api Relevant documentation: ‣ https://curl.se/ ‣ https://www.postman.com/ ‣ https://httpie.io/ ‣ https://www.php.net/manual/en/function.set-exception-handler.php ‣ https://www.php.net/manual/en/pdo.setattribute.php ‣ https://www.php.net/manual/en/class.errorexception.php 00:00 Introduction 00:18 API client 00:31 Front controller 01:38 RESTful endpoints 02:03 URL rewriting 03:03 HTTPie usage 03:28 Routing 03:59 404 response 04:23 Collection and resource URLs 05:19 Controller class 06:27 Class autoloading 08:19 Process the request 09:06 Collection requests 09:55 JSON Content-type 10:56 Create the database 11:53 Connect to the DB 14:08 Exception handling 16:44 Table gateway class 17:42 List all records 19:52 Encode JSON values 21:35 Insert a record 21:55 Get request data 27:04 201 response 28:00 Error handling 30:00 Data validation 31:46 422 response 32:28 405 response 33:36 Resource requests 34:43 Get a resource 35:59 404 response 37:02 Update a resource 40:03 Conditional validation 41:12 Delete a resource 43:12 Summary #PHP #MySQL #REST #API