PHP REST API From Scratch [1] - Database & Read
Вставка
- Опубліковано 18 вер 2024
- In this series we will put together a REST API using PHP with NO FRAMEWORK. We will use object oriented programming along with PDO to connect and query a MySQL database.
Code:
github.com/bra...
💖 Become a Patron: Show support & get perks!
/ traversymedia
Website & Udemy Courses
www.traversymed...
Follow Traversy Media:
/ traversymedia
/ traversymedia
/ traversymedia
![PHP REST API From Scratch [2] - Single & Create](http://i.ytimg.com/vi/-nq4UbD0NT8/mqdefault.jpg)
![PHP REST API From Scratch [2] - Single & Create](/img/tr.png)
This is awesome! Can't wait to watch it all later tonight. We use an older framework to build our APIs (Apigility) at work and the documentation sucks. I think this is the series I need to understand what's going on under the hood. Thank you!!
RealToughCandy You’re very welcome 😉
N00B
@Omni, thank you!
@@RealToughCandy hah.. Just saw one of your videos. And what a coïncidence. 1st comment i see is yours ! This means i need to subscribe ! 😂
This is pretty epic
For those like me who are still quite new, doing it without frameworks is really useful as I actually learn a lot about how things work. Thank you!
Thank you for doing this with NO FRAMEWORK!
Frameworks come and go, but the language remains.
Many tutorials use {insert current trendy framework}, which obscures the inner workings of php.
Great job done, mate.
IMO frameworks are for people too lazy to learn the actual language and use it properly.
Man you read my mind. I have been searching this for 2 months
these little project series most exciting thing on your channel, thank you! I started my developer career a month ago, your role in it was HUGE Brad!
this is awesome, i created a php api from scratch today at work and this video goes to show me what needs to be improved as i made it in pure php, thanks alot. :)
I love PHP and have been using it off and on for about 10 years. I don't program full time. But i am always trying to learn new things. Thank you Brad, you are a really good instructor. I will be checking out your other courses. I actually learned a lot.
I love normal humans
I've spent 3weeks studying how API works but I didn't find any helpful resource like this serie. Thank you man we appreciate u. Please help us with a php PDO series with an simple project example 🙏🙏🙏🙏🙏
2020 update would be nice
PHP is quite old, is there a need for an update?
@@PASTRAMIKick It's about as old as Java, Python, and Javascript, and it's being regularly updated? That said this is still PHP 7, so there's probably little to no need to for an update.
Why? php still the same lol
That's really cool !! You and your videos are the main reasons to keep learning and continuing in this field
TOoma Dev thanks. That actually really means a lot and keeps me going
As an old Informix DBA, esql server side vi guy I found this demo dead simple and it demystified what all the kiddies drone on about these days. Well done sir!
Doing my first rest api now, feels like my head gonna explode. This video helped me a lot!
Why? Why do you make life's hardest problems seem like nothing?! Your videos never fail to impress, you have a true talent. Thank you for this, I was looking for an easy way to implement a PHP back end without using an adapter framework. This is perfect!
Awesome video! I'm currently migrating to Web Development and these 32:17 minutes gave me a bunch of valuable stuff + the main theme of the video. I've subscribed and will certainly watch the other classes.
Thanks for your great contribution Brad.
You can replace LEFT JOIN with WHERE clause such as "WHERE p.category_id = c.id" will do the same work as LEFT JOIN
Brad, not only are you a very bright and intelligent person, but you also posses the generosity to make amazing and professional tutorials like these for the community to view for free. Hats of to you sir :)
This tutorial was a life saver for me. I made my Rest Api and connected 3 servers. Thank your for this.
we need a part 4 where you implement this with an user interface :D
Calm and clear presentation. I tried and got this working. Thank you very much. Now I can take my time to get acquainted to it.
I've never loved PHP but this changed my mind i will learn it soon
hey brad thank you buddy
Hi Brad, thanks for your work. If I can suggest you something : I know the goal is to make something from scratch but you could use composer for autoloading and a basic router like Fast Route. It will be a more real world approach !
For most databases, PDOStatement::rowCount() does not return the number of rows affected by a SELECT statement. Instead, use PDO::query() to issue a SELECT COUNT(*) statement with the same predicates as your intended SELECT statement, then use PDOStatement::fetchColumn() to retrieve the number of matching rows.
The only code on the internet that actually worked. Thank you for sharing on git.
I've been integrating 3rd party API's recently and finally got given the task of creating an endpoint, i managed to figure it out although it wasn't my best work....always learning though so.....here i am. Great vid :)
Thanks for this really good tutorial!
All the documentation that I have read indicates that the PDOStatement::rowCount method is not guaranteed to work for mysql databases. One way to workaround this is to do a "Select count(*) " using the same where conditions as the original query then fetch the results.
wow, just saw your video. Great presentation making it all so easy. I knew all the pieces, but here put together so structured and clear, just perfect!! Bravo!
This is exactly what I was trying to build. Thank you
I love this so much currently having project that i am developing APIS in core php using PDO, can you please make authentication using JWT
Hello
Kindly refer me to a tutorial when u find one.
Thank u
Very well explained and easy to understand. if You can add utf8 support for the data also it will be helpful. Because while I implement for utf-8 it got stuck and i found the solution. Add : $this->conn->exec("set names utf8"); right after the new PDO statement in Database class. Thank You dear.
Thank you for the comment! It saved me a bunch of time.
Hey thanks man! I'am currently working on my own CMS to make it easy for my clients to change text and all that stuff on the websides I build for them. It's all based on PHP in the backend and this tutorial is just what I was looking for. Because I#m experimenting with object oriented PHP and not that happy with my solution so far. So great that you help me with new input!
Great tutorial, Brad. My only critique would be using the post table as an example since I'm so new to the PHP syntax, I felt confused at times if you were making a POST request or referencing the post table. That may just be me though.
I really like the way you stored the entire output in "data"
I love PHP, but PHP friendzoned me
Oh man. You too?
Python will never friendzone you
It's funny because in my language PHP stand for "Pemberi Harapan Palsu" translated as "False Promise Giver" as in friendzone.
Should have bought some phlowers every once in a while
Orang indonesia detected
Just in case you need an idea, I'm waiting for fullstack Vue.js, but no pressure ;D
Kamal Mahmud ill keep that in mind 😉
@@TraversyMedia good job
Very seldom do I run across a video that is as well organized and instructive as this one....thumbs up.
Really appreciate all those comments in code.
First thank you for this video. I have a question. In the Read API data from db is coming with "data" object ( example: {"data":[{"id":"30","title":"","body":"","author":"","category_id":"0","category_name":null}]} ). How can I do this for the CREATE API. So how can I send data to the database in the "data" object? (example: {"data":[{"id":"15","title":"test","body":"test","author":"test","category_id":"15","category_name":null}]} )
thanks THANKS my teacher never explained how the fuck do an api rest and told us you have google..........
THANKS YOU SAVED ME 6 MONTHS WITH THAT TEACHER AGAIN
LOVE FROM CHILE (the country xD)
TIp: IMO An easier (and cleaner) way to write SQL queries is by using double quotes and flower braces when you're including an object/associativeArray element.
$fetchLimit = 5;
$filter = array("month"=>"2020-08-30");
$query = "
SELECT
*
FROM
posts
WHERE
user_id='{$params->user_id}'
AND
month='{$filter['month']}'
LIMIT $fetchLimit
;
";
Should use prepared statements when accepting user inputs, a few extra steps but safer and many useful properties
Hey awesome video !
btw, just to point out you could save more line of codes using PDO::FETCH_CLASS, because you already have models for this case, something like: $row = $result->fetch(PDO::FETCH_CLASS, 'Post'); then you could just json_encode that object
i' am always wondering how you manage your time bcs this is not easy man, thank you
mstafa dev its hard but luckily its part my full time job
It'd be neat to see an episode about how you manage your time for the rest of us, maybe give us some pointers? :) I've also wondered as I'm trying to catch up with you! Absolute huge fan of your channel!
me also wana meet you
It was so professional. appreciation in an infinite loop. wow. expressions, style of coding, explanation, logic and procedure was so ideal. Thank you man. Thanks a lot. You are one of a kind really. We need you and more like you.
Really very Nice i Watched Many Videos About Restful API but i'm not understand well but when i watched this video i gated Helpful now i'm creating my own API without any other Help thank you Very Much , sorry for my Bad English .
thank you so much, i did it :D and deployed it in my own host website
Thank you, you are the best
Can you do video on how to make it secure and access by token or it required authentication
Hi, Brad. Could you please make video tutorials on JWT/Auth REST API in PHP and Laravel. I could not find any videos on your channel based on Authentication. Thanks.
Hello
Kindly refer me to a tutorial when u find one.
Thank u
ua-cam.com/play/PLe30vg_FG4OSbizS6Gpw_LICp9zBcmjZU.html
Brad your the best thks for your time, thanks for sharing
Dude, thank you!!!! you're the hero we need but not the one that we deserve.... If we ever meet in person drinks are on me!
Could you please send the method to connect to MSSQL Server? And also confirm whether it is gonna be slow unless using ODBC some ppl said that It’s slow when use PDO with SQL server. Thank you.
you should consider adding pagination data filtering to these
You're tutorials are always lit! Thanks Brad!
2021, I'm here. Thanks for this. Very helpful.
You are our saviour Brad. I can't thank you enough. This is really helpful and it means a lot. Huge fan!!!
In all honesty, This is my coding university
Brad, what's really needed are authentication tuts for APIs, JWT or otherwise.
Ross Elliot he seriously already has videos on that.
TaelurAlexis seriously?
Nice one Mr! I hope I can get everything you say here...It has been days looking for a good PHP PDO class.
Hello, thank you for all your videos :)
can you make a video to haw secure passwords before storing them in the database in PHP?
And will you do more courses about PHP?
It's as simple as - $hashedPassword = password_hash($providedPassword) - , of course you get set the algorithm, provide an actual salt if you want, etc. php.net/manual/en/function.password-hash.php
Just one word awesome u r reading the programmers mind
More PHP Please.... All Freelancers need to learn PHP to get mroe clients from all small businesses or wordpress.
Please make more content focused on freelancing (PHP)
hi brad, you explain complex topics in a simple way. Thank you for sharing good tutorials.
Awesome, this channel never disappoints whenever I come here, thanks a lot !!!
I've been looking at your Slim REST tutorial - is this new approach preferred or are they very similar? I know the Slim tutorial is two years old now.
And thanks for the tutorials and much appreciate your down to earth approach!
now i understand how fast we create api's via frameworks. there's so many tedious codes. but I think this will be faster as we are using vanilla php
For better usage and security for mysql
Use medoo for execute any sql query , its simple ans secure
Thanks
Thanks for making my day again 👍
Many thanks. The ajaxCall.html form id should read 'form' and not 'apiform' . This is necessary so as to match var url = $('form').serialize(); in the ajaxCall.js file. Now ajaxCall.html will work. Very small correction in a magnificent tutorial. Bless you.
Great video. Love seeing him making PHP content more
Wow, you read my mind 😁. Just what I need for school assignment.
Nice video. Can you please do a User Authentication[JWT] with PHP.
Hello
Kindly refer me to a tutorial when u find one.
Thank u
Waiting for a video on docker container + node js microservices! I guess it's in your to-do list
For me it makes way easier to understand: $str_concat = "mysql:host=$this->host;dbname=$this->db_name"; Dot/quotes/dots/quotes are quite confusing sometimes.
This is exactly what I want to learn!!!!Thank u!!!!Love your videos!!!
Awesome video! Which font are you using?
Brad, you are like a GOLD!!
Hi thanks for this video. How to use stored procedure in this kind of method?
Thank you so much. Please add one more video in this course about HOW to upload whole project or files on GIT & Gist. Thanks
Hey Brad! There's a tutorial on how to add auth on that API?
I've been searching that for a long time and still didn't found.
Thanks for all the help and all of those videos.
You'r videos are amazing, big thanks from Brazil.
+1 for the Quality of the Code you write. ❤️
I uploaded my app to my live share hosting server but I get "no page found." as long as I tested the app using php -S localhost:8080/quote it worked, but when I tried using it without the port number, just through apache, it doesn't work. I have created .htaccess file and enabled mod_rewrite in apache according to slim framework web server documentation for apache. How can I get this running in apache? thanks
Thanks for this series.Please make a series on vuejs,angular 5 or reactjs and graphql with mongodb.Also a series on sailsjs auth with passport.Or using vuejs, angular with a symfony 4 api.Or angular with laravel.Or this api with vuejs or angular.Or vuejs or angular with ruby on rails.Or authentication with adonisjs.Or vuejs or angular with an adonisjs api!Hope you consider these in future!Thanks anyways!
Hi, thank you for the video. I wonder why the result of the query is a boolean? This confuses me so much!
Awesome tutorial, just works.
Thank you very much for your tutorials Mr. Traversy.
some questions:
why not using routes and prettier URL ( without php extension)?
why are you not restrict the loading data only for get?
Thank you for all you do!!!! When in doubt you are my go to!
Thank u for this awesome series, can u make a video series on express, mongodb, nodejs store rest api
My favourite tutor
Laravel is darn hella complex now, it's time to go back to basic
PHP is life.
There's no need for the $row extraction and the existence of the $post_item. Just do $row['body'] = html_entity_decode($row['body']);
and array_push($posts_arr['data'],$row); to get the same result with less code.
Great tutorial. Just what I was looking for.
This is awesome, do you have a Laravel version?
He has a full Laravel series: ua-cam.com/video/EU7PRmCpx-0/v-deo.html
simple and well explained, Kudos 👍
Also, confusing note. Why do you have to type in
$posts_arr = array();
$posts_arr['data'] = array();
When you can just say
$posts_arr['data'] = array();
and remove the first one
Connection Error: SQLSTATE[HY000] [1049] Unknown database ' myblog'
Fatal error: Uncaught Error: Call to a member function prepare() on null in C:\xampp\htdocs\API_test\models\Post.php:41 Stack trace: #0 C:\xampp\htdocs\API_test\api\post
ead.php(17): Post->read() #1 {main} thrown in C:\xampp\htdocs\API_test\models\Post.php on line 41
What should I choose to become full stack php or node js? what will be "better" ?
omg just what i wanted. thank you
call to a member function prepare() on null. How can I fix this. need help
go to phpmyadmin->myblog->priviledges
Then Find username=root and host=localhost then click all priviledges ,find the change password option and change it to desired password.Make sure the password should match will phpymyadmin ->config.inc file
Hello everyone, Brad I suggest a tutorial with Pusher Chakit - it's one of the service Pusher offers (completely free for now in beta) to create chat app cli/frontend applications easily. Thanks
Anyone can tell me that it will work in xamm controller localhost