Soon to by membership this month. Your way of explaining wastes no time and you to the point and so knowledgeable, been watching for year but I need to get into your full courses. Thanks for this, a super help. From cape town, south africa.
Thank you for this video. In real life we need in one query some fields from first level, some from second level, third, etc. But it is another story =)
This is great thank you.. Could you do a video explaining the different type of relationships and how the database structures should be set up in terms of where foreign keys are, etc?
I have an article: blog.quickadminpanel.com/eloquent-relationships-the-ultimate-guide/ Also, it's best to read the docs: laravel.com/docs/8.x/eloquent-relationships
Something done with few lines I have to do with complex sql queries with joins, to do the same on old projects running over laravel 5.2 in my main work. Thank for this video.
Thank you for the great video, I've a question for this scenario. is it a good practice to use keys in deep relations ? for example in employees table we add country_id to avoid complex queries when working on reporting. I've been looking for this answer for quite a long time
great video thanks. :) but i think in some situation like this performance will drop after 2 joins and more. I mostly using DB facade for retrieving data from database.
thank you so much Sir, i just have a question, you know when we use the 'with' function with a model? it generates two queries, one for the model and one for the relation, can i instruct Laravel to do left join to fetch the data with one query? i don't want to use the query builder too. thanks again for all of your work.
All the time i see that orm magic like this I'm asking myself does it worth it or maybe some escaped sql would be way easier to read and write. Because sql knowledge could be transferred between projects while knowledge of specific orm might be problematic.
exactly, it slowed it down but it did simplify the work, so if you're application doesn't require or need the small performance difference, it's a good choice though.
@ 8:00 you are showing off the functionality of `hasManyDeep` to associate employees with their countries. Could this also be achieved with an additional `hasManyThrough` definition? Where it is defined as `hasManyThrough(Employee::class, Shop::class)` ? Or do those methods not chain well / is this strictly better for performance?
Thanks for your videos! Could you please do one about constructing relationships between tables that are in different databases and connection names to those tables cannot be hard coded. E.g.: User table is in DB1, Post table is in DB2 and Comment table is in DB3. Can we construct a relationship here? Thanks!
Thanks or putting this together. If you had a page that needs to display say for every employee, the country, city and shop, what might the query look like?
Bro, if possible all your future video please make very big fonts and alsp zoom abit because when we use phone its hard to see. It cause not complete watch
It’s really helpful. Thank you so much. But if a table has the large data ( about 10.000 record and more) and I use eloquent to find a data. Is it great?. Or I must use DB query?. Please help me that quenstion!
Pardon! Could you explain it more directly?. I have been meeting about 30.000 records to query. I want to count some fields in that table. Does Eloquent still bring good performance?.
Eloquent can or cannot bring good performance, even on million records. The performance is not from Eloquent itself, it's from the exact query or statement you write.
Thank you I have a quistion I understand a for each loop ($example as $key) but I don't understand this one Can you make a video explaining when to use a foreach ($example as $key => $value)
This is basic php foreach loop. $key will give you index/key of the array $value will give you value of the key In some cases you will need the index thats why extending the foreach for key/value
Sir, @LaravelDaily If i want to add another table: shop_branches fields: 1) id 2)shop_id 3) shop_branch_name then how i define relationship to access: shop_branch_name
how to get all data of that relationships not through some. ex all countries, and all cities and all shop in 1 query, i wanna make tree.. pls advice sir
helo sir, thanks for the video. may i ask you about extension you use for Visual Code? it help me understand the code better, i really need that extension.
This will soon be the one of the most viewed video in this channel 😂 good work
Correct 😂
Yes I think ❤
Yup
Yes, it's me in 8 month, revisiting this video 😂
I cannot thank you enough! Your channel is AMAZING! Thank you for doing what you do!
This packages should be in the framework. They're really good.
Anyone can add anything to the framework, it's open-source, so you can try.
Ι was about to say the same.
Soon to by membership this month. Your way of explaining wastes no time and you to the point and so knowledgeable, been watching for year but I need to get into your full courses. Thanks for this, a super help. From cape town, south africa.
This is EXACTLY what I needed to see. Thank you so much!
Superb Laravel specialized developer of all the time. I like you Sir
You just earned a new subscriber. Kudos to you. You just showed me exactly what I needed to see
Большое спасибо) смотрю каждый день. Всегда очень полезно
Реал, не сложно говорит. Прекрасно понятно
Иногда такие вещи показывает что удивляешся
that is what i was searchingfor an hour, thanks alot sir !!!
Dude! you are awesome, so so accurate!
You are a good teacher! I love your channel!
Great work!
you are the best ,thanks you for improving my laravel knowledge, i was do stupid things before i see this video 😅
Life saving tip. Life saving package. Congrats to both.
finally the addon is mature enough to use! nice tutorial.
Thank you for this video. In real life we need in one query some fields from first level, some from second level, third, etc. But it is another story =)
You are the best, Povilas!
Many thanks You are best in yours job ... I cannot thank you enough! Thank you teacher for your trainings!
This is great thank you.. Could you do a video explaining the different type of relationships and how the database structures should be set up in terms of where foreign keys are, etc?
I have an article: blog.quickadminpanel.com/eloquent-relationships-the-ultimate-guide/
Also, it's best to read the docs: laravel.com/docs/8.x/eloquent-relationships
Thanks for your laravel daily tips.
I literally needed to know this, thank you so much 💓 keep up the great work 💪
Your videos are always wonderful.
Problem solving, thanks sir!
This is what I need!!! Thankyou so muchh for this
Excellent explanation 🎉
Really helpful video. Thank you
Очень крутое видео, спасибо за улучшение наших знаний в Laravel:)
ну я хз понял ли он)
Something done with few lines I have to do with complex sql queries with joins, to do the same on old projects running over laravel 5.2 in my main work. Thank for this video.
Your tutorials help a lot... Thanks
OMG, this is amazing thank you so much!
Thank you for the great video, I've a question for this scenario. is it a good practice to use keys in deep relations ? for example in employees table we add country_id to avoid complex queries when working on reporting. I've been looking for this answer for quite a long time
Up
Feel you bro, done the same: usign foreign keys to those deep deep relationships
First time seeing video on youtube without dislike button being tick.
Amazing content. It helps me a lot. Thanks
by this video you can understand the principle of has_many and belongs_to in other languages and frameworks also
you always provide good content
great video thanks. :)
but i think in some situation like this performance will drop after 2 joins and more.
I mostly using DB facade for retrieving data from database.
Yes, for complex queries raw queries are still the best.
This is really great. Love it
Really good job. Thanks 🙏
This is awesome bro......It will help me a lot :)
Wow! that`s really really awesome!
awesome, thanks you, please more and more advanced eloquent
I have a full course about advanced eloquent: laraveldaily.teachable.com/p/laravel-eloquent-expert-level
Thank sir , one of the best video
🎉 save the day, thanks a lot
Thank you.. this help me a lot..
Thank you so much. It's help me a lot.💝💝
very very very helpful package thanks !
6:03 the query count went down but the time & memory usage went up, less performant 🤔maybe it is not using an index
You are a god to me, thank you so so much
thank you very much for tutorial sir!!
Thx for the great content
what ide setup you use ? It looks so good and to the point
Phpstorm default
Great video💙
this help me a lot, thanks
Awesome! Thanks
Very informative video, thanks.
You are awesome 😍
Hi, I watched your video about function's return type, is there any documentation about the full list of return types? Thank you!
Any PHP variable type or PHP/Laravel class could be a return type. There's no list.
thank you so much Sir, i just have a question, you know when we use the 'with' function with a model? it generates two queries, one for the model and one for the relation, can i instruct Laravel to do left join to fetch the data with one query? i don't want to use the query builder too.
thanks again for all of your work.
No, it's either query builder with join and one query, or eloquent model with eager loading and two queries.
@@LaravelDaily okay, thanks a lot
All the time i see that orm magic like this I'm asking myself does it worth it or maybe some escaped sql would be way easier to read and write. Because sql knowledge could be transferred between projects while knowledge of specific orm might be problematic.
Thanks for this how can i learn more about eager loading
The BelongsToThrough query actually became less efficient, no? It reduced the queries and models used but memory and time to execute increased.
exactly, it slowed it down but it did simplify the work, so if you're application doesn't require or need the small performance difference, it's a good choice though.
Can you please do a Short video on how to create nested comment and also a Short video on how to retweet a post ( Just like Twitter)
Retweet feature will be nice
@@ikarahubs965 nested comment please
@ 8:00 you are showing off the functionality of `hasManyDeep` to associate employees with their countries. Could this also be achieved with an additional `hasManyThrough` definition? Where it is defined as `hasManyThrough(Employee::class, Shop::class)` ? Or do those methods not chain well / is this strictly better for performance?
good work!!!
Very helpful video.
Why laravel framework does not have these kind of relationships yet?
You're free to submit pull requests to the framework and add it.
Muchas gracias 🤯
Awesome!
very well. thank you.
Thanks for your videos! Could you please do one about constructing relationships between tables that are in different databases and connection names to those tables cannot be hard coded. E.g.: User table is in DB1, Post table is in DB2 and Comment table is in DB3. Can we construct a relationship here? Thanks!
It will work the same, the only thing you will have to do is overwrite the connection variable inside of the model.
Could you make one video of belongstomany with three level deep query with where condition (with the last one)?
Good job!
really helped me with retrieving data, but what about insert data? is it possible to do so?
This is cool!!!
This is all nice but the same thing can be achieved with php arrays if you know how.
Pretty helpful!
composer require staudenmeir/belongs-to-through:"^2.5"
not installing on laravel 8
Thanks or putting this together. If you had a page that needs to display say for every employee, the country, city and shop, what might the query look like?
Thank you!
Bro, if possible all your future video please make very big fonts and alsp zoom abit because when we use phone its hard to see. It cause not complete watch
Please make a video about this package belongstothrough
That package has a very good documentation, not sure why the video is needed
Best video. 👌
very helpfull
thanks
Helpful 🙌🖤
It’s really helpful. Thank you so much. But if a table has the large data ( about 10.000 record and more) and I use eloquent to find a data. Is it great?. Or I must use DB query?. Please help me that quenstion!
It depends, you need to debug different options and measure performance.
Pardon! Could you explain it more directly?. I have been meeting about 30.000 records to query. I want to count some fields in that table. Does Eloquent still bring good performance?.
Eloquent can or cannot bring good performance, even on million records.
The performance is not from Eloquent itself, it's from the exact query or statement you write.
I got it. Thank you so much !!
Brilliant!
how can we select only some attributes of the second table?
Thank you
Thank you
I have a quistion
I understand a for each loop ($example as $key) but I don't understand this one
Can you make a video explaining when to use a foreach ($example as $key => $value)
This is basic php foreach loop.
$key will give you index/key of the array
$value will give you value of the key
In some cases you will need the index thats why extending the foreach for key/value
@@renwar thank you i think i understand now lol
Thanks 🙏
Lovely!
You do not show how to set search filter with "with" relation and its deep level with multiple column. Can you do that?
Sir, @LaravelDaily If i want to add another table: shop_branches fields: 1) id 2)shop_id 3) shop_branch_name
then how i define relationship to access: shop_branch_name
thanks a lot
Thanks 👏
amazing thanks
What about A -> many to many -> B belongs to -> X, is possible using this package to access X from model A ?
how to get all data of that relationships not through some. ex all countries, and all cities and all shop in 1 query, i wanna make tree.. pls advice sir
thank you very much
awesome!!
Hey, When can we expect Flutter updates?
In September.
@@LaravelDaily Looking forward to it very eagerly bro
someone can tell me the extension for see laravel debugs in window conmsole? 8:30 thanks!
It's not an extension. It's a package called laravel debug bar!
helo sir, thanks for the video. may i ask you about extension you use for Visual Code? it help me understand the code better, i really need that extension.
I don't use Visual Code, I use PhpStorm.