How to pull json data from data mysql as object using laravel5?

Question

I have a table which contain JSON in a column that I have to get as an object but when I pull data using laravel model then it obviously return as JSON or string which I have to decode every where, where I use this model (this is not dry concept) but the thing is if I pull one record and one place then it is only one execution of code and ok but what if I have to pull collection of the data and multiple place then I have to run same decode every time is there any way in laravel that can do for me instead of using self made loop

here is the table

+-----------------------------------------------------------------------------+
|                                   table                                     |
+-----------------------------------------------------------------------------+
|id | title | text                                                            |
+-----------------------------------------------------------------------------+
| 1 |   A1  | {"subject":"Subject1","word":"Lorem ipsum dolor sit amet, ..."} |
| 2 |   A2  | {"subject":"Subject2","word":"Lorem ipsum dolor sit amet, ..."} |
| 3 |   A3  | {"subject":"Subject3","word":"Lorem ipsum dolor sit amet, ..."} |
| 4 |   A4  | {"subject":"Subject4","word":"Lorem ipsum dolor sit amet, ..."} |
| 5 |   A5  | {"subject":"Subject5","word":"Lorem ipsum dolor sit amet, ..."} |
| 6 |   A6  | {"subject":"Subject6","word":"Lorem ipsum dolor sit amet, ..."} |
| 7 |   A7  | {"subject":"Subject7","word":"Lorem ipsum dolor sit amet, ..."} |
| 8 |   A8  | {"subject":"Subject8","word":"Lorem ipsum dolor sit amet, ..."} |
| 9 |   A9  | {"subject":"Subject9","word":"Lorem ipsum dolor sit amet, ..."} |
| 10|  A10  | {"subject":"Subject10","word":"Lorem ipsum dolor sit amet..."}  |
+-----------------------------------------------------------------------------+

i have tried this

$tables = TableModel::all();
foreach ($tables as &$table) {
    $table->text = json_decode($table->text);
}

Result what I want

Array
(
    [0] => stdClass Object
        (
            [id] => 1
            [title] => A1
            [text] => stdClass Object
                (
                    [subject] => Subject1
                    [word] => Lorem ipsum dolor sit amet...
                )

        )

    [1] => stdClass Object
        (
            [id] => 2
            [title] => A2
            [text] => stdClass Object
                (
                    [subject] => Subject2
                    [word] => Lorem ipsum dolor sit amet...
                )

        )

    ...
)

If is there any easy way to that which is more efficient and follow dry then share with me.

Thanks in advance.

i called model then loop through it and overwrite then element with object using json_decode() — User97798
– User97798, Commented Feb 25, 2017 at 21:31

nextt1 · Accepted Answer · 2017-02-26 10:18:12Z

1

You can use Attribute Casting concept to get the result in the desired format every time you fetch the record from database. To convert from JSON to Array you can use the following code.

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

As mention in the Official Documentation.

answered Feb 26, 2017 at 10:18

nextt1

4,0082 gold badges20 silver badges27 bronze badges

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

1 Comment

User97798 Over a year ago

Thanks :) this helps me lot and saved the day

Collectives™ on Stack Overflow

How to pull json data from data mysql as object using laravel5?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related