How to get only JSON object values from a JSON array in LARAVEL 5.2

Question

My database query is below.

$beneficiary_id = DB::select('select Telephone from item ');

This returns a json array looks like this

[{"Telephone":"0111222333"},{"Telephone":"0112211223"},{"Telephone":"012345557"},{"Telephone":"0225545455"}]

For another database insertion operation I need only the telephone numbers. I have used json_decode() function, it is working only if we enter the array manually.

How to get only those values to another array?

Thanks in advance.

json_decode() expects parameter 1 to be string, array given. Code I have used. $tp = json_decode($beneficiary_id); return $tp; — Sachith Muhandiram
– Sachith Muhandiram, Commented Jun 23, 2016 at 8:47

Michal Bieda · Accepted Answer · 2016-06-23 08:22:17Z

2

Use the pluck function

If you would like to retrieve an array containing the values of a single column, you may use the pluck method.

$titles = DB::table('roles')->pluck('title');

foreach ($titles as $title) {
    echo $title;
}

answered Jun 23, 2016 at 8:22

Michal Bieda

9396 silver badges13 bronze badges

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

3 Comments

Sachith Muhandiram Over a year ago

when I use the method, it returns." Call to a member function pluck() on a non-object"

Michal Bieda Over a year ago

How you're using it? Try maybe something like this: $numbers = DB::table('item')->pluck('Telephone');

Sachith Muhandiram Over a year ago

Yes, It worked.This just returns only the telephone numbers.

Tony · Accepted Answer · 2016-06-23 08:14:38Z

0

use $beneficiary_id->column_name to get the value from your object.

answered Jun 23, 2016 at 8:14

Tony

213 bronze badges

Collectives™ on Stack Overflow

How to get only JSON object values from a JSON array in LARAVEL 5.2

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related