我尝试将Jeffrey Way的多对多关系教程应用到我的私人消息应用程序中,但卡住了。我正在尝试获取与用户相关联的2个对话,“haha”和“hehe”。然而,Laravel给出了以下错误:
Column not found: 1054 Unknown column 'Conversations.user_id' in 'where clause' (SQL: select * from `Conversations` where `Conversations`.`user_id` = 1)
我在我的对话表中有这些数据:
+---------+----------+
| conv_id | name |
+---------+----------+
| 1 | haha |
| 2 | hehe |
+---------+----------+
在我的用户对话表中:
+----+-------------+--------+
| id | conv_id | user_id|
+----+-------------+--------+
| 1 | 1 | 1 |
| 2 | 2 | 1 |
+----+-------------+--------+
1. 我尝试过 : 在控制器中:
User : return $this->belongsToMany('User','id');
Conversatons : return $this->hasMany('Conversations','conv_id');
但我得到的结果是 : haha
而不是 haha
和 hehe
2. 我还尝试过 :
User : return $this->belongsToMany('User','user_conversations');
Conversatons : return $this->hasMany('Conversations','user_conversations');
但 Laravel 返回了以下错误 :
Column not found: 1054 Unknown column 'Conversations.user_conversations' in 'where clause' (SQL: select * from `Conversations` where `Conversations`.`user_conversations` = 1)
我在Laravel方面还比较新,可能会犯一些愚蠢的错误。
以下是我的代码:
模型
对话
class Conversations extends Eloquent {
protected $table = 'Conversations';
protected $fillable = array('name');
public function users(){
return $this->belongsToMany('User');
}
}
用户
<?php
use Illuminate\Auth\UserInterface;
use Illuminate\Auth\Reminders\RemindableInterface;
class User extends Eloquent implements UserInterface, RemindableInterface {
....
public function conversations(){
return $this->hasMany('Conversations');
}
}
控制器
对话控制器
public function create()
{
$loginuser = User::find(Auth::user()->id);
$conversations = $loginuser->conversations;
return View::make('msgsystem.Conversations.Conversations',array('conversations'=>$conversations));
}
迁移(在函数up()中)
用户
Schema::create('users',function($table)
{
$table->increments('id');
$table->string('email')->unique();
$table->string('password',100);
$table->string('name',150);
$table->string('usertype',50);
$table->boolean('block');
$table->string('remember_token',100);
$table->timestamp('lastlogin_at');
$table->timestamps();
$table->softDeletes();
});
对话记录
Schema::create('Conversations', function(Blueprint $table)
{
$table->increments('conv_id')->index();
$table->string('name',100);
$table->timestamps();
});
用户对话
Schema::create('user_conversations', function(Blueprint $table)
{
$table->increments('id')->unsigned();
$table->integer('conversation_id')->unsigned()->index();
$table->foreign('conversation_id')->references('conv_id')->on('conversations')->onDelete('cascade');
$table->integer('user_id')->unsigned()->index();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
$table->timestamps();
});
奖励点数用于改进代码。非常感谢!