Hi guys. I have 3 tables. user, theme and theme_user. Its because I need a many to many relationship. I created in both the models the following:
// Theme.php public function users() { return $this->belongsToMany('App\User', 'theme_user', 'theme_code', 'user_id'); }
//User.php public function themes() { return $this->belongsToMany('App\Theme', 'theme_user', 'user_id', 'theme_code'); }
Now I want to get all users from a certain theme. Therefor I do $themeUser = Theme::where('code', '=', $code)->first()->users;
But the query I get is not right..
'select users.*, theme_user.theme_code as pivot_theme_code, theme_user.user_id as pivot_user_id from users inner join theme_user on users.id = theme_user.user_id where theme_user.theme_code is null'
How can I solve this?
Sorry, I've read your code wrong. What's the schema for themes table? Is code primary key of themes table?
Yes it is. code is the primary key for themes table and id is the primary key for the users table. the pivot table theme_user has user_id and theme_code as columns
Eloquent assumes the name of primary key is id, in your case you need to specify primary key for Theme model explicitly:
class Theme extends Model
{
protected $primaryKey = 'code';
...
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast