問題描述
我在 MySQL 中有兩個(gè)表，其中第一個(gè)稱為用戶，第二個(gè)稱為游戲.表結(jié)構(gòu)如下.
I have two tables in MySQL, where the first one is called users and the second one is called games. The table structure is as follows.
用戶
- id(主要)
- 電子郵件
- 密碼
- 真實(shí)姓名
游戲
- id(主要)
- user_one_id(國外)
- user_one_score
- user_two_id(國外)
- user_two_score
我的游戲桌有兩個(gè)對外關(guān)系，兩個(gè)用戶.
My games table is holding two foreign relations to two users.
我的問題是如何為這個(gè)表結(jié)構(gòu)建立模型關(guān)系??- 根據(jù) laravel 文檔，我應(yīng)該在模型內(nèi)部創(chuàng)建一個(gè)函數(shù)并將其與其關(guān)系綁定
My question is how do I make the model relations for this table structure?? - According to the laravel documentation, I should make a function inside the model and bind it with its relations
例如
public function users()
{
$this->belongsTo('game');
}
但是我似乎無法在文檔中找到任何告訴我如何處理兩個(gè)外鍵的內(nèi)容.就像我上面的表格結(jié)構(gòu)一樣.
however I can't seem to find anything in the documentation telling me how to deal with two foreign keys. like in my table structure above.
我希望你能幫助我一路走來.
I hope you can help me along the way here.
謝謝
推薦答案
遷移:
$table->integer('player1')->unsigned();
$table->foreign('player1')->references('id')->on('users')->onDelete('cascade');
$table->integer('player2')->unsigned();
$table->foreign('player2')->references('id')->on('users')->onDelete('cascade');
還有一個(gè)模型:
public function player1()
{
$this->belongsTo('Game', 'player1');
}
public function player2()
{
$this->belongsTo('Game', 'player2');
}
編輯按照用戶 deczo 的建議將游戲"更改為游戲".
EDIT changed 'game' to 'Game' as user deczo suggested.
這篇關(guān)于兩個(gè)外鍵，如何用laravel eloquent映射的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！