Laravel add values to object based on foreign key

Question

I have a TABLE A called diagnoses . It has a disease_id and a visit_id. I am trying to return the diagnosis from TABLE A along with the disease name and visit details. I keep getting sql syntax errors. Is there a recommended way to push an objects to the array?

My code is

public function diagnosis_diseases(Disease $disease) {

        $id = $disease->id;

        $items = DB::select(DB::raw('SELECT * FROM diseases WHERE diseases.id = '.$id.'  ;'));
        foreach($items as $item){
            $diagnosis = DB::select(DB::raw(' select * from diagnoses
                   where disease_id = '. $id.';' ));

            $items->push($diagnosis);
        }

        dd($items);

    }

Oana Mircea · Accepted Answer · 2020-08-04 21:34:29Z

1

You might need to use an inner join:

public function diagnosis_diseases(Disease $disease) {

        $id = $disease->id;

        $items = DB::select(DB::raw('SELECT * FROM diseases WHERE diseases.id = '.$id.'  ;'));
        foreach($items as $item){
            $diagnosis = DB::select(DB::raw(' select * from diagnoses
                   inner join diseases on diagnoses.id = ' .$id' '));

            $items->push($diagnosis);
        }

        dd($items);
    }

answered Aug 4, 2020 at 21:34

Oana Mircea

313 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel add values to object based on foreign key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related