LaravelEloquent-relationship between models (Association)

LaravelEloquent-relationship between models (association) What is Eloquent?

Eloquent is an ORM called Object Relational ING. it is translated as "Object relationship ing" (if you only treat it as the Database Relational action Layer array library Abstraction Layer, it is too small to look at it ). The so-called "object" refers to the "Model" mentioned in this article, and the object relationship ing refers to the relationship between models. English document: http://laravel-china.org/docs/eloquent#relationships

Next, let's start learning one by one.
One-to-one relationship

As the name suggests, this describes the one-to-one relationship between two models. This relationship does not require an intermediate table.

Assume that we have two models: User and Account, which correspond to the registered users and consumers respectively. they are in a one-to-one relationship. if we want to use the one-to-one relationship method provided by Eloquent, the table structure should be as follows:

User: id... account_id

Account: id... user_id

Suppose we need to query the information of the corresponding Account table in the User model, the code should be like this. '/App/models/User. php ':


Class User extends Eloquent {



Protected $ table = 'users ';

Public function hasOneAccount ()

{

Return $ this-> hasOne ('account', 'User _ id', 'id ');

}

}

Then, how should we use this relationship? As follows:

$ Account = User: find (10)-> hasOneAccount;

The obtained '$ account' is an instance of the 'account' class.

The most difficult part here is the subsequent settings of foreign_key and local_key. you can remember that in the User class, no matter who hasOne is, the second parameter is 'user _ id ', the third parameter is generally 'id '. Because the previous 'Find (10) 'has locked id = 10, the corresponding SQL of this function is: 'select * from account where user_id = 10 '.

This code not only demonstrates how to use a one-to-one relationship, but also conveys three pieces of information, which is my advice for using Eloquent:

1. specify the table name in each Model.

2. the relationship like has one account is written as 'hasoneaccount () 'instead of simply 'account ()'

3. write full parameters every time you use the relationship between models. do not omit them.

Correspondingly, if belonsto () is used, it should be written as follows:


Class Account extends Eloquent {

Protected $ table = 'accounts ';



Public function belongsToUser ()

{

Return $ this-> belonsto ('user', 'User _ id', 'id ');

}

}

One-to-multiple relationship

After learning the basic method of using one-to-one relationships, the following relationships are much simpler.

We introduce a new Model: Pay, payment record. The table structure should be as follows:

User: id ......

Pay: id... user_id

There is a one-to-multiple relationship between User and Pay. In other words, a User can have multiple Pay. in this way, only one 'user _ id' field exists in the Pay table. '/App/models/User. php ':


Class User extends Eloquent {



Protected $ table = 'users ';

Public function hasManyPays ()

{

Return $ this-> hasMany ('pae', 'User _ id', 'id ');

}

}

Then, how should we use this relationship? As follows:

$ Accounts = User: find (10)-> hasManyPays ()-> get ();

The obtained '$ accounts' is an instance of the 'illuminate \ Database \ Eloquent \ collect' class. You should have noticed that this is not a simple '-> hasoneaccount' but'-> hasManyPays ()-> get () '. why? This is 'hashid', which operates on a collection of objects.

The usage of the corresponding belonsto () is the same as that in the previous one-to-one relationship:


Class Pay extends Eloquent {

Protected $ table = 'pays ';



Public function belongsToUser ()

{

Return $ this-> belonsto ('user', 'User _ id', 'id ');

}

}

Many-to-many relationship

The multi-to-many relationship is completely different from the previous one, because many redundant data may exist in the multi-to-many relationship, and the existing tables cannot be stored.

We define two models: Article and Tag, which respectively represent articles and tags. they are multi-to-many relationships. The table structure should be as follows:

Article: id ......

Tag: id ......

Article_tag: article_id tag_id

Use in Model:


Class Tag extends Eloquent {

Protected $ table = 'tags ';



Public function belongsToManyArticle ()

{

Return $ this-> belongstole ('article', 'article _ tag', 'tag _ id', 'article _ id ');

}

}

Note that the third parameter is the id of the class, and the fourth parameter is the id of the class of the first parameter.

Use the same as hascript:

$ TagsWithArticles = Tag: take (10)-> get ()-> belongsToManyArticle ()-> get ();

Here we will get a very complex object. you can 'Var _ dump () 'on your own ()'. Let's talk about it. after 'Var _ dump () ', right-click Chrome and choose "View Source Code" to see the neat object/array expansion.

Here we will show you a rare usage ):

Public function parent_video ()

{

Return $ this-> belongsToMany ($ this, 'video _ hierarchy ', 'video _ id', 'video _ parent_id ');

}

Public function children_video ()

{

Return $ this-> belongsToMany ($ this, 'video _ hierarchy ', 'video _ parent_id', 'video _ id ');

}

Yes. you are not mistaken. you can belongsToMany yourself.