I didn't had to use this until now because I was making some simple projects with Symfony and it didn't make a lot of sense to me, but now that I work with real world projects I can see how this can be implied. Great stuff. The tougher thing for me to do is to get my queries correctly before I dare to use the query builder which can be a pain but I'll work on it for a bit lol.
LMAO I can relate . I myself don't know if the error is in the way I'm using the query builder or the sal query it self . But I must make a confesssion. Sometimes I just write raw SQL instead of the query builder lol.
@@OverSeasMedia In my case what I'm doing is I have something like a searchbar in my website which is actually a form with checkboxes and a dropdown list that has different options which are not an actual property inside of my database, the checkboxes are categories which have a ManyToMany relation with let's say posts like in your case and then for each option I can do different stuff with these cateories, like, let's say I can show posts with one category and stuff like that. Well what I can do is if the form is submitted I use arrays to call each option and then I use the switch statement to get the result for each option. It's pretty dumb but it works I guess.
Oh man thank you for the nice comment. At the moment I have absolutely nothing planned but I'll definitely keep your suggestion in mind for the upcoming video. Cheers and thank you again :)
Great tutorial. Can you tell me how the map database was built, so I can follow the tutorial. I'm studying the methods of QueryBuilder.php, but I'm blocking (for example, qb->getRootAliases, what return it?). Thanks in advance. Cordially
im having problem of querybuilder on datetime field where i have to return results into json. it always carries "createdAt" : {"date":"2021-04-10 13:20:00.000000","timezone_type":3,"timezone":"UTC"} which i dont want. how to i convert to the datetime for json?
try $qb["createdAt"]["date"] if you want to select the datetime only. it will only get the date value. (try this after you get all the data in your query) $qb = $userRepository->getAll(); correct me if I understood your question wrong :)
Its NEVER a waste of time!!! Thanks for sharing your knowledge
You're most welcome mate, glad to hear that bro :)
1:27 "Sniffs coke"😂😂😂😂😂, great video by the way, i really needed more understanding
damn it dude focus on the information 😂, thank you mate :)
really really great job! better understanding than SF docs imho
Thank you man I'm glad it was helpful .
Cheers mate :))
You made my day :) THANKS for sweet examples!
I didn't had to use this until now because I was making some simple projects with Symfony and it didn't make a lot of sense to me, but now that I work with real world projects I can see how this can be implied. Great stuff.
The tougher thing for me to do is to get my queries correctly before I dare to use the query builder which can be a pain but I'll work on it for a bit lol.
LMAO I can relate . I myself don't know if the error is in the way I'm using the query builder or the sal query it self . But I must make a confesssion. Sometimes I just write raw SQL instead of the query builder lol.
@@OverSeasMedia In my case what I'm doing is I have something like a searchbar in my website which is actually a form with checkboxes and a dropdown list that has different options which are not an actual property inside of my database, the checkboxes are categories which have a ManyToMany relation with let's say posts like in your case and then for each option I can do different stuff with these cateories, like, let's say I can show posts with one category and stuff like that. Well what I can do is if the form is submitted I use arrays to call each option and then I use the switch statement to get the result for each option. It's pretty dumb but it works I guess.
Well as they say . If it works it ain't dumb lol
such a nice and funny guy you are..."I'm sorry if this was a waste of your time"...haha, hilarious 😂. I am sure most of us appreciate your effort
Great tutorial. More Symfony 4 videos!
Are you planning on creating RESTful API using Symfony 4?
Oh man thank you for the nice comment.
At the moment I have absolutely nothing planned but I'll definitely keep your suggestion in mind for the upcoming video.
Cheers and thank you again :)
Awesome work dude! (:
I appreciate it man thank you .
You are the best!
Great tutorial.
Can you tell me how the map database was built, so I can follow the tutorial.
I'm studying the methods of QueryBuilder.php, but I'm blocking (for example, qb->getRootAliases, what return it?).
Thanks in advance.
Cordially
im having problem of querybuilder on datetime field where i have to return results into json. it always carries "createdAt" : {"date":"2021-04-10 13:20:00.000000","timezone_type":3,"timezone":"UTC"} which i dont want. how to i convert to the datetime for json?
try $qb["createdAt"]["date"] if you want to select the datetime only. it will only get the date value. (try this after you get all the data in your query) $qb = $userRepository->getAll(); correct me if I understood your question wrong :)
When you make a video please check your sound as well as screen.