Question 16372 in Laravel Question posted in
The official Laravel Documentation can be found here.

Retrieving data from hasMany Relationship – Laravel

I want to show data from ‘personas’ (parent table) that has at least one ‘residente’ (child table), its a one to many relationship, and i want to show data of that residente too.
I was trying to do it using the has() method like the laravel documentation says:
https://laravel.com/docs/9.x/eloquent-relationships#querying-relationship-existence
but it does not work.

Models looks like this

//in the Persona class

  public function residentes()
    {
        return $this->hasMany(Residente::class);
    }

//in the Residente class

public function persona()
  {
    return $this->belongsTo(Persona::class);
  }


//in the PersonasController

public function index()
    {
        $personas = Persona::has('residentes')->get();

        dd($personas);
           
    }

the Result
enter image description here
//it doesn’t get the data from "residentes"

Tags:

2

Answers


  1. 0

    Try :

     public function index()
{
    $personas = Persona::with('residentes')->get();
    dd($personas);
       
}

    If you want to search using some keys inside the residentes relationship you can use whereHas

    Persona::with('residentes')
       ->whereHas('residentes',function($residente){
           return $residente->where('column_name',$value);
         })->get();

    Also try to mention the local_key and the foreign_key in the relationship itself reference : https://laravel.com/docs/9.x/eloquent-relationships

    return $this->hasMany(Comment::class, 'foreign_key', 'local_key');
    Login or Signup to reply.
  2. 0

    Please try the following in the place of key give actual field names.

    //in the Persona class
    
public function residentes()
{
   return $this->hasMany(Residente::class, 'foreign_key', 'local_key');
}
    
//in the Residente class
    
public function persona()
{
    return $this->belongsTo(Persona::class,'foreign_key', 'owner_key');
}
    
    
//in the PersonasController
    
public function index()
{
    $personas = Persona::with('residentes')->get();
    foreach($personas as $person){
       echo "<pre>";
       print_r($person->residentes()->get()->toArray());
     }
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search