How to store an element in a variable from array in Laravel?

Question

I want to store the "area" in the $area variable from $school_info array. Using $area I want more 3 rows stored into 3 different arrays like: $school_info1, $school_info2, $school_info3.

public function schooldetailviewid($id)
{
    $school_id = $id;
    $school_info = DB::table('school_infos')->where('school_id', '=', $school_id)->get();
    $area = $school_info->area;

    // recomendation start
    $school_info1 = DB::table('school_infos')->where('area', '=', $area)->get();
    $school_info2 = DB::table('school_infos')->where('area', '=', $area)->get();
    $school_info3 = DB::table('school_infos')->where('area', '=', $area)->get();
    // recomendation end

    return view('schooldetail', compact('school_info', 'school_info1', 'school_info2', 'school_info3'));
}

Problem: Storing of elements is not working and also the 3 more rows are not fetched! I am trying to make a simple recommendation system.

Error

Exception Property [area] does not exist on this collection instance.

what is your school_infos table structure?

Anatoliy R
– Anatoliy R

2020-01-11 17:29:52 +00:00
Commented Jan 11, 2020 at 17:29 — Anatoliy R
– Anatoliy R, Commented Jan 11, 2020 at 17:29

MEDZ · Accepted Answer · 2020-01-11 17:32:10Z

1

The .get() returns an array of objects to get only one object use .first():

$school_info = DB::table('school_infos')->where('school_id', '=', $school_id)->first();
$area = $school_info->area;

Otherwise, you need to access the first element of the array:

$school_info = DB::table('school_infos')->where('school_id', '=', $school_id)->get();
$area = $school_info[0]->area;

answered Jan 11, 2020 at 17:32

MEDZ

2,2952 gold badges17 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

How to store an element in a variable from array in Laravel?

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