Select * from 'table name' where category='categoryId' SELECT b.name, c.name AS categories FROM blog b JOIN category c ON p.category_id = p.id Something like that Hope this is what you asked
I was having the same issue, spent 16hours trying to solve it, turn out I declared the $host, $dbname variables static lol, you might have done the same. if not try to explicitly put the values raw in the new PDO("...") it might work.
as a Beginner, I learned a lot from this video. Thank you ❤❤
Glad this helped, Thanks for the comment.
This was a big help for me as a beginner. Thank you so much! :)
Thank you!
Can you make a tutorial of How to upload images and files to API using PDO PHP?
Hi there thank you for the comment, I will try to create this video.
can you tell me what i need to learn about restful api what is the steps
How will I write the join SQL query if I select a particular category and want to get all posts associated with that category?
Select * from 'table name' where category='categoryId'
SELECT b.name, c.name AS categories FROM blog b JOIN category c ON p.category_id = p.id
Something like that
Hope this is what you asked
SQLSTATE[HY000] [2002] No such file or directory , can you please assit ? The error occurs in the update.php file
I was having the same issue, spent 16hours trying to solve it, turn out I declared the $host, $dbname variables static lol, you might have done the same. if not try to explicitly put the values raw in the new PDO("...") it might work.
The Posts as table and the post as method confused me for a second there.