Level 14
@VINOTH06 Assuming you have the post...
$post->comments()->create([array-of-comment-data]);
Btw, that should return the new comment, so you can:
$new_comment = $post->comments()->create([array-of-comment-data]);
Feb 14, 2017
8
Level 25
Best way to save with one to many relationship
I have three tables,
- Users [fields: id, name, email]
- Posts [fields: id, user_id, post, category ]
- Comments [fields: id, user_id, post_id, message]
Model
- user->hasMany(posts), user->hasMany(comments)
- post->hasMany(comments), post->belongsTo(user)
- comments->belongsTo(posts), comments->belongsTo(user)
Now am a logged in user and I need to comment on a post. So the user and post are already created and now we need to create comment with post and user id on it.
what would be the best way to do that
Level 25
@goatshark hope we need to make user_id to be fillable on comments create. Please correct me if am wrong.
Level 14
@vinoth06 I think you'll need either user_id or post_id to be fillable on comments.
If user_id is fillable, it would look something like this, where "array-of-comment-data" includes the user_id.
$post->comments()->create([array-of-comment-data]);
If post_id is fillable, it would look something like this, where "array-of-comment-data" includes the post_id.
$user->comments()->create([array-of-comment-data]);
Level 25
@goatshark OK. Thank you. So we must make anyone to be fillable. So no way to make without fillable by like associate().
Level 14
@vinoth06 Good point on the associate(). That could very well allow you to have neither user_id nor post_id fillable. Sorry for the confusion, it's been a while since I tackled the 'owned by two' that wasn't a polymorphic thing.
You might start here: https://laravel.com/docs/5.4/eloquent-relationships#updating-belongs-to-relationships
Please or to participate in this conversation.