How to access array properties with Laravel Eloquent, if stored in a database?

Question

For example, I have JSON stored in a Row of a database called 'data'

External.php (model) - casting 'data' to an array:

protected $casts = [
    'data' => 'array',
];

I can access it using Tinker with this commmand:

$external = App\External::first()->pluck('data');

This returns

 Illuminate\Support\Collection {#3384
     all: [
       [
         "id" => 17566616456845,
         "name" => "#1008",
         "note" => "",
         "tags" => "",
         "test" => false,
         "email" => "[email protected]",
         "phone" => null,

         ...
         ..
         .

How do I access the "email" or "id" from that collection? How do I modify the tinker eloquent command to get the "id" or "email"?

$external = App\External::all()->pluck('data')->'email'

T_STRING or T_VARIABLE or '{' or '$' on line 1> Exception with message 'Property [email] does not exist on this> PHP Parse error: Syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting

Getting warmer:

>>> $external = App\External::pluck('data')->get('email')
=> null

Franz · Accepted Answer · 2019-10-02 06:35:41Z

1

pluck() method returns array. So if you want to access 'email' you must use.

$external = App\External::first()->pluck('data');

$email = $external['email']; // [email protected]

answered Oct 2, 2019 at 6:35

Franz

3541 gold badge4 silver badges15 bronze badges

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

2 Comments

lagbox Over a year ago

pluck returns a Collection

Josh Over a year ago

>>> $email = $external['email'] PHP Notice: Undefined index: email in /home/vagrant/code/{domain_name_censored}/vendor/laravel/framework/src/Illuminate/Support/Collection.php on line 1290 >>>

lagbox · Accepted Answer · 2019-10-02 06:47:53Z

0

If you are just trying to get the data for one record use the cast attribute as an array:

// one External record
$external = App\External::first();

$email = $external->data['email'];
$id = $external->data['id'];

answered Oct 2, 2019 at 6:47

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

1 Comment

Josh Over a year ago

This works thanks... However, how do you return all emails too?

HieuMinh · Accepted Answer · 2019-10-02 06:59:34Z

0

Try this

$external = collect(App\External::all()->pluck('data'))->pluck('email')->all();

answered Oct 2, 2019 at 6:59

HieuMinh

415 bronze badges

Comments

Tharaka Dilshan · Accepted Answer · 2019-10-02 07:18:49Z

0

You don't have to use pluck().

if you want to access email from the data of an External.

$email = App\External::first()->data['email'];

UPDATE

to get all the emails.

$emails = App\External::all()
    ->map(function($external) {
        return $external->data['email'];
    });

edited Oct 2, 2019 at 7:18

answered Oct 2, 2019 at 6:48

Tharaka Dilshan

4,4993 gold badges17 silver badges29 bronze badges

2 Comments

Josh Over a year ago

This works thanks... However, how do you return all emails too?

Tharaka Dilshan Over a year ago

to do so you can get all() and map() result.

Collectives™ on Stack Overflow

How to access array properties with Laravel Eloquent, if stored in a database?

4 Answers 4

2 Comments

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest