How to add array to Laravel db result row?

Question

My code returns the first row from a Laravel $data = DB::table('sometable')->select('id')->get(); using:

$row = $data->first();

I can then return id using:

$row->id;

How can I now add an array with key 'moredata' to that row collection object for referencing later in the code? I've tried:

$row->put('moredata', $moredata);

Where $moredata is a populated array and 'moredata' is not a field in the table. Laravel throws the error 'Call to undefined method stdClass::put()'. I could convert to an array and simply extend the array, just wondered if it could be done retaining the Laravel collection structure?

$row->moredata = $moredata;

Kuldeep Mishra
– Kuldeep Mishra

2017-09-01 11:21:27 +00:00
Commented Sep 1, 2017 at 11:21 — Kuldeep Mishra
– Kuldeep Mishra, Commented Sep 1, 2017 at 11:21

Jerodev · Accepted Answer · 2017-09-01 11:21:20Z

1

You can just set the property on the object directly.

$row = DB::table('sometable')->select('id')->first();
$row->moredata = $moredata;

Also, If you only need one record, use the first function on your query builder. Otherwise, you will query the database for all records and filter the first in memory.

answered Sep 1, 2017 at 11:21

Jerodev

33.3k11 gold badges96 silver badges114 bronze badges

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

Comments

Sanni · Accepted Answer · 2017-09-01 11:23:22Z

0

<?php
$appends = ['moredata']

function getMoredataAttribute() {
    return ['data' => '...data...'];
}

put this into your Model

answered Sep 1, 2017 at 11:23

Sanni

1

Comments

vipin · Accepted Answer · 2017-09-01 11:59:07Z

0

try this :

$data = DB::table('sometable')->select('id')->first();
$data->moredata = $moredata;

or

$data = DB::table('sometable')->select('id')->get();
$data = $data[0];
$data->moredata = $moredata;

answered Sep 1, 2017 at 11:59

vipin

2,5101 gold badge22 silver badges37 bronze badges

Comments

jjj · Accepted Answer · 2017-09-01 13:00:03Z

0

You can append data: https://laravel.com/docs/5.4/eloquent-serialization#appending-values-to-json

Occasionally, when casting models to an array or JSON, you may wish to add attributes that do not have a corresponding column in your database.

answered Sep 1, 2017 at 13:00

jjj

1771 silver badge10 bronze badges

Collectives™ on Stack Overflow

How to add array to Laravel db result row?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related