Laravel get result of each return QueryBuilder fields

Question

i want to get all row by all() and into foreach i want to get fields of other table in query builder.

$getResult = webLinks::all();

$result = array();

foreach ($getResult as $value) 
{
   $query = DB::table('webInformation')
            ->where('webLink', '=', $value->id)
            ->get();
    $r['site']  = $value->webLink;
    $r['webLink']  = $query->webLink; //I GET ERROR                 
    $result[] = $r;
}

in this coomand i can not save webLink of webInformation table into array.

i'm try this:

$r['webLink']  = $query->webLink;

or

$r['webLink']  = $query['webLink'];

how to fix this problem?

Result of that :

Array
(
    [0] => stdClass Object
        (
            [id] => 2
            [webLink] => 1
            [updated_at] => 2014-03-13 10:20:16
            [created_at] => 2014-03-13 10:20:16
        )

    [1] => stdClass Object
        (
            [id] => 3
            [webLink] => 1
            [updated_at] => 2014-03-13 10:25:32
            [created_at] => 2014-03-13 10:25:32
        )

)

Marwelln · Accepted Answer · 2014-03-15 13:16:25Z

2

->get() returns an array of all hits found. If you only want the first result you can use ->first() instead.

foreach ($getResult as $value) 
{
   $query = DB::table('webInformation')
            ->where('webLink', '=', $value->id)
            ->first();
    $r['site']  = $value->webLink;
    $r['webLink']  = $query->webLink;            
    $result[] = $r;
}

answered Mar 15, 2014 at 13:16

Marwelln

29.5k21 gold badges97 silver badges120 bronze badges

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

Collectives™ on Stack Overflow

Laravel get result of each return QueryBuilder fields

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