Laravel Eloquent: Deeper Relationships with One Query

Подписаться 141 тыс.

Просмотров 137 тыс.

50% 1

If you work with a project that has multiple levels of hasMany relationships, you can use hasManyThrough instead, or one of a few packages I will show in this video.
Official docs on HasManyThrough: laravel.com/docs/8.x/eloquent...
Packages by Jonas Staudenmeir: github.com/staudenmeir
My course "Eloquent: Expert Level": laraveldaily.com/course/eloqu...
My course "Better Eloquent Performance": laraveldaily.com/course/eloqu...
- - - - -
Support the channel by checking out my products:
- My Laravel courses: laraveldaily.com/courses?mtm_...
- Laravel QuickAdminPanel: quickadminpanel.com
- Livewire Kit Components: livewirekit.com
- - - - -
Other places to follow:
- My weekly Laravel newsletter: us11.campaign-archive.com/hom...
- My personal Twitter: / povilaskorop

Хобби

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 180

@chengkangzai 3 года назад

This will soon be the one of the most viewed video in this channel 😂 good work

@muditgulgulia5350 3 года назад

Correct 😂

@aboodlibda7161 3 года назад

Yes I think ❤

@dibbyo456 2 года назад

Yup

@chengkangzai 2 года назад

Yes, it's me in 8 month, revisiting this video 😂

@0x0456 Год назад

This is EXACTLY what I needed to see. Thank you so much!

@KasimSheyi 3 года назад

Your videos are always wonderful.

@DennisBraga 3 года назад

Life saving tip. Life saving package. Congrats to both.

@bilaljan7659 Год назад

that is what i was searchingfor an hour, thanks alot sir !!!

@salman-804 2 года назад

I learnt a lot from this tutorial. Thanks a lot !!

@tiagooliveira14 3 года назад

This packages should be in the framework. They're really good.

@LaravelDaily 3 года назад

Anyone can add anything to the framework, it's open-source, so you can try.

@KgfLikia 2 года назад

Ι was about to say the same.

@pankajbokdia 2 года назад

I cannot thank you enough! Your channel is AMAZING! Thank you for doing what you do!

@worthsalive Год назад

You just earned a new subscriber. Kudos to you. You just showed me exactly what I needed to see

@hamzaradouan4074 3 года назад

I literally needed to know this, thank you so much 💓 keep up the great work 💪

@shaadishtiaque2084 3 года назад

Your tutorials help a lot... Thanks

@MahmodurRahmanShihab 3 года назад

Thanks for your laravel daily tips.

@levieraf 3 года назад

Dude! you are awesome, so so accurate! You are a good teacher! I love your channel! Great work!

@philipcook6191 Год назад

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.

@AldhiAlbadri 2 года назад

Problem solving, thanks sir!

@glowiever 2 года назад

finally the addon is mature enough to use! nice tutorial.

@jeanfrancois3605 3 года назад

OMG, this is amazing thank you so much!

@azeroth5672 2 года назад

This is what I need!!! Thankyou so muchh for this

@JamesShisiah 2 года назад

This is really great. Love it

@HadiHasanpur Год назад

Many thanks You are best in yours job ... I cannot thank you enough! Thank you teacher for your trainings!

@msdeav 3 года назад

Really helpful video. Thank you

@vigneswarans13 4 месяца назад

Excellent explanation 🎉

@md.robelahammed4763 Год назад

Amazing content. It helps me a lot. Thanks

@auroraapps1853 Год назад

Superb Laravel specialized developer of all the time. I like you Sir

@shahosanandaji9894 10 месяцев назад

You are the best, Povilas!

@ValeriyaPolovinkina 2 года назад

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 =)

@biplobshaha2829 Год назад

Thank you so much. It's help me a lot.💝💝

@vbadheli 3 года назад

Thank you.. this help me a lot..

@alexandergontsov6219 Год назад

Really good job. Thanks 🙏

@Trizen321 2 года назад

you always provide good content

@MUJAHIDKHAN 3 года назад

Thank sir , one of the best video

@poplach 3 года назад

Very informative video, thanks.

@Matheus708 Год назад

Wow! that`s really really awesome!

@hostname47 2 года назад

very very very helpful package thanks !

@Dinookys Год назад

🎉 save the day, thanks a lot

@abdalkhalekchamkha3622 Год назад

you are the best ,thanks you for improving my laravel knowledge, i was do stupid things before i see this video 😅

@user-zg1pc6md6y 3 года назад

Большое спасибо) смотрю каждый день. Всегда очень полезно

@user-ld1gz1cr1j 3 года назад

Реал, не сложно говорит. Прекрасно понятно

@ARMONEY666 2 года назад

Иногда такие вещи показывает что удивляешся

@codepilot2766 3 года назад

This is awesome bro......It will help me a lot :)

@aryarizkysandi8351 2 года назад

thank you very much for tutorial sir!!

@g3n1kindra 2 года назад

this help me a lot, thanks

@nbqenglishvietsubstyle117 3 года назад

You are a god to me, thank you so so much

@amrqawasmeh Год назад

Thx for the great content

@user-rm4zo1mg5o 3 года назад

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.

@claudiomenares4172 4 месяца назад

Muchas gracias 🤯

@QianZhiwei Год назад

very well. thank you.

@newtonsefa5721 10 месяцев назад

Thank you

@tarekalhalabi8776 3 года назад

Great video💙

@YT-Gmailer 3 года назад

Thank you!

@programadorweb8403 Год назад

good work!!!

@cethartest469 3 года назад

awesome, thanks you, please more and more advanced eloquent

@LaravelDaily 3 года назад

I have a full course about advanced eloquent: laraveldaily.teachable.com/p/laravel-eloquent-expert-level

@erh4rdt 3 года назад

great, thank you!

@demeja16 3 года назад

Очень крутое видео, спасибо за улучшение наших знаний в Laravel:)

@maxgoose4671 3 года назад

ну я хз понял ли он)

@my_religion 2 года назад

Pretty helpful!

@rdvr 3 года назад

Brilliant!

@Raftor74 3 года назад

Awesome!

@ahmedsyam 3 года назад

Good job!

@amgadalwattar2863 2 года назад

very helpfull thanks

@bmtamim7818 3 года назад

You are awesome 😍

@developer_sagor 3 года назад

thank you very much

@mostafamahfouz1139 2 года назад

thanks a lot

@berthojoris 3 года назад

The best....Thanks

@rishabhandari2501 3 года назад

Helpful 🙌🖤

@RANJEETKUMAR-wz4dg 3 года назад

amazing thanks

@devsun9063 3 года назад

Thanks 🙏

@fuhfaysal Год назад

awesome!!

@AlexTheGreatish 3 года назад

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?

@LaravelDaily 3 года назад

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

@achmadimanfirmansyah663 3 года назад

thank you

@chibuikeumezinwa7827 3 года назад

Lovely!

@aineelzihnee9634 2 года назад

First time seeing video on youtube without dislike button being tick.

@ekselyum34 3 года назад

Thanks 👏

@huynguyenduyit4441 Год назад

Amazing

@GabrielMoura32 2 года назад

thanks

@GergelyCsermely 3 года назад

Thanks

@josuebarros5727 2 года назад

This is cool!!!

@muditgulgulia5350 3 года назад

Best video. 👌

@ChangeYourLifeForever 2 года назад

by this video you can understand the principle of has_many and belongs_to in other languages and frameworks also

@arashpirhadi1326 3 года назад

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.

@LaravelDaily 3 года назад

Yes, for complex queries raw queries are still the best.

@jimishukurow2286 3 года назад

royal like from me!

@martinh4982 3 года назад

Hi Povilas, In Eloquent is it possible to join to an arbitrary sql statement? For example, say I have a User model and I want to create a UserStats relationship. However UserStats is not a table, but a sql statement that computes stuff like last_login, number_of_posts, up_votes etc. The only way I've found to do this so far is with a database view that I manage with migrations, but was wondering if this could be done purely in Laravel.

@ugayashan8659 3 года назад

Great content, can you make a video on user referral system using laravel Eloquent

@anisurrahman6634 3 года назад

❤

@shofada 3 года назад

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?

@akintandavid2500 Год назад

Thanks for this how can i learn more about eager loading

@afestacincome2224 3 года назад

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)

@ikarahubs965 3 года назад

Retweet feature will be nice

@niffeydovie4906 3 года назад

@@ikarahubs965 nested comment please

@ilyasabdut 2 года назад

what package did you used to showing relation and through text in the model?

@AbdulMajeedShehzad 3 года назад

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

@kauandouglas 2 года назад

@javieru5871 2 года назад

Feel you bro, done the same: usign foreign keys to those deep deep relationships

@TechITWorld 2 года назад

Could you make one video of belongstomany with three level deep query with where condition (with the last one)?

@Formula7Driver 2 года назад

What if we want to update data? I have a Sales Order, with Items, and each item has a list of Operation IDs to produce the item

@titon9688 2 года назад

how to query with scope to show id 1 from shop ?

@yogeshwarbarai9686 11 месяцев назад

what ide setup you use ? It looks so good and to the point

@LaravelDaily 11 месяцев назад

Phpstorm default

@fylzero 2 года назад

The BelongsToThrough query actually became less efficient, no? It reduced the queries and models used but memory and time to execute increased.

@gethermedel3620 2 года назад

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.

@martinjones8231 3 года назад

I follow all of your video u are great because the laravel path am on is just what u can teach so I need ur personal contact.

@taghreedomer6208 Год назад

really helped me with retrieving data, but what about insert data? is it possible to do so?

@dApoTB 3 года назад

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!

@SonsParaRelaxar 3 года назад

It will work the same, the only thing you will have to do is overwrite the connection variable inside of the model.

@renwar 3 года назад

Very helpful video. Why laravel framework does not have these kind of relationships yet?

@LaravelDaily 3 года назад

You're free to submit pull requests to the framework and add it.

@insider-analyst 2 года назад

composer require staudenmeir/belongs-to-through:"^2.5" not installing on laravel 8

@Ayvengo21 3 месяца назад

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.