Home / Questions / 399524
Accepted
Satisfacción
Asked: 2021-10-20 12:26:22 +0800 CST 2021-10-20 12:26:22 +0800 CST

Get the comments associated with a post

  • 772

I am making an Api with Laravel, and I wanted to make a route: posts/comments where it would show all the posts with their respective comments in json format, but when showing the posts I wanted there to be a new field where the comments would be shown there , something like that:

"Posts": [
{
  "id": 1,
  "user_id": 7,
  "titulo": "Dr.",
  "contenido": "Adipisci sequi nam distinctio inventore magnam rerum fuga.",
  "created_at": "2020-10-17 17:16:49",
  "updated_at": "2020-10-17 17:16:49"
  "Comentarios": "Aqui se muestran todos los comentarios del post"
},
{
  "id": 2,
  "user_id": 2,
  "titulo": "Dr.",
  "contenido": "Quia dicta sunt mollitia eos tenetur.",
  "created_at": "2020-10-17 17:16:49",
  "updated_at": "2020-10-17 17:16:49"
  "Comentarios": "Aqui se muestran todos los comentarios del post"
},

My question is, how can I make it show me the posts with their respective comments like the previous example?

api.php

Route::get('posts/comments', 'PostController@posts_comments');

PostController.php

    public function posts_comments(){

    return response()->json([
        "Posts" => DB::table('posts')->get(),
        "Comments" => DB::table('comments')->get(), //solo muestra la tabla, no hay relacion con un post
    ],200);
}

Model Post.php

class Post extends Model
{

public function user() {
    return $this->belongsTo('App\User');
}

public function comment(){
    return $this->hasMany('App\Comment');
}
}

Model Comment.php

class Comment extends Model
{
public function post(){
    return $this->belongsTo('App\Post');
}
}
laravel

1 Answers

  1. Best Answer

    Observations:

    • The way you process the query is not correct and you currently have 2 options:
      • You continue to invoke the entities via the facade DBand its method tableto constitute ajoin
      • Or you can ( since it seems you have them defined ) occupy the Eloquent relations, ( important to clarify this is not a join )

    I am telling you about the above because you are doing 2 isolated queries that will return information to you but they do not have under this criterion that you use to show the information with the structure that you want ( that is, there you only have 2 SELECTSindependent of each other ).

    Once the previous points have been clarified, in the comment model declare the inverse of the relationship, which would be: belongsTo()like this ( at some point you will end up occupying it ):

    class Comment extends Model
{
    public function post()
    {
        return $this->belongsTo(Post::class);
    }
}

    Once the above is done, now we can indicate a query that returns the requested information in this way:

    Post::with('comments')->get();

    The above will return 2 collections:

    • The post collection
    • For each post a collection with all its associated comments

    References

    I'll leave the rest to you...

    • 1