samedi 23 juillet 2016

How to return multiple relationships with Laravel Eloquent?

I have a table called users. Each of these users has different things:

  • country
  • device
  • computer
  • category

I have created a table for each of these above 'things'. Similar the following:

1 | United States
2 | United Kingdom
3 | Australia
4 | Canada
5 | Italy

etc...

I'm storing these values in the users table as follows:

ID | Country | Device | Computer | Category |
---|---------|--------|----------|----------|
1  |       3 |      2 |        6 |        2 |
2  |       4 |      3 |        9 |        1 |

etc...

Now each of the above numbers are associated with the corresponding table's ID.

What I want is do an Eloquent Query and search for all the users and 'replacing' their corresponding values from their helper table.

I was thinking about doing a hasOne() Eloquent relationship for each of those things in the users table, but then I'm not sure how to get/call them at once.

Anyone can help me tacke this issue?



from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2a8yrSK
via IFTTT

Aucun commentaire:

Enregistrer un commentaire