lundi 24 juin 2019

Laravel eloquent relationship between tables

Got stacked in laravel eloquent relationships. i have two tables.

fuel contains

  • id, fuel_name, fuel_rate

machine contains

  • id, machine_name, machine_rate fuel_id

    fields.

fuel_id is a foriegn key.

I have tried some examples from laravel.com

in Machine.php

class Machine extends Model
{
    protected $table = 'machine';

    public  function machineinfo()
    {
        return $this->hasMany('App\Fuel','id');
    }
}

and in controller

$items = Machine::find(1)->machineinfo;

i want to see machine name, machine code, fuel name and fuel rate in output.

but the output is

Column not found: 1054 Unknown column 'fuel.machine_id' in 'where clause' (SQL: select * from fuel where fuel.machine_id = 1 and fuel.machine_id is not null)



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire