Laravel - Get specific array in JSON encoded database column

Question

Let's say I have a table called Posts with these columns:

-- uid (int)
-- title (str)
-- body (text)
-- data (json)

and in one row, inside the data column, I have a JSON encoded response like so:

[{
    "title": "Blue",
    "points": 0,
    "tags": [{
        "type": "Comedy",
        "uid": 45
    }]
}, {
    "title": "Green Orange",
    "points": 2,
    "tags": [{
        "type": "Horror",
        "uid": 1
    }]
}]

All of that is json_encode into one database column.

How can I make it so that I can get the Green Orange into a variable?

I have tried:

$post = Post::where('id', $id)->first();

$data = json_decode($post->data);

return $data[0];

But that just gives me: The Response content must be a string or object implementing __toString(), \"object\" given.

json_decodeprovides by default \StdClass use this to retrieve an array json_decode($post->data, true); And access properties with $data[0]['title'] — Unex
– Unex, Commented Dec 15, 2017 at 16:32
although irrelevant to your question, I would recommend $post = Post::find($id); — meewog
– meewog, Commented Dec 15, 2017 at 16:33

Luca C. · Accepted Answer · 2017-12-15 16:35:13Z

2

You are accessing the full object, instead you need its field:

$post = Post::where('id', $id)->first();//$post = Post::find($id); would be better

$data = json_decode($post->data);

return $data[1]->title;//note than Green Orange is in the second object of the array, so not index 0 but 1

answered Dec 15, 2017 at 16:35

Luca C.

12.7k2 gold badges89 silver badges83 bronze badges

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

Comments

user6679664 · Accepted Answer · 2017-12-15 17:20:08Z

0

you need to access the title field in the second object of array.

return $data[1]->title;

answered Dec 15, 2017 at 17:20

user6679664

Collectives™ on Stack Overflow

Laravel - Get specific array in JSON encoded database column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related