Convert string with array of json (PHP)

Question

I stored array of JSON in mysql as a string

[{"id": 1, "mark": 5}, {"id": 2, "mark": 3}, {"id": 3, "mark": 2}]

When I try to use it

@foreach ($places as $place)
   @foreach ($place->rates as $rate)

      {{var_dump($rate->marks)}}

   @endforeach
@endforeach

There is a problem. $rate->marks is a string. How shoul I decode it to array?

UPD

of course I tried to use json_decode, but it returns error

htmlentities() expects parameter 1 to be string, array given

SOLVED

I', stupid. Problem was not in json_decode. I tried to print result with {{ }} which needs string as argument.

First decode the json string and then use it in foreach loop. — Murad Hasan
– Murad Hasan, Commented May 28, 2016 at 10:23
@splash58 of course I tried to use json_decode, but it returns error htmlentities() expects parameter 1 to be string, array given — sqlnoob
– sqlnoob, Commented May 28, 2016 at 10:25

Murad Hasan · Accepted Answer · 2016-05-28 10:27:25Z

0

There are no rate in your json, and also no marks.

Check Online

$json = '[{"id": 1, "mark": 5}, {"id": 2, "mark": 3}, {"id": 3, "mark": 2}]';
$places = json_decode ($json);

foreach ($places as $place)
      var_dump($place->mark);

Design the code for the Laravel, Online Debug does't have that feature.

Let me know.

answered May 28, 2016 at 10:27

Murad Hasan

9,5932 gold badges23 silver badges43 bronze badges

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

Comments

luchaninov · Accepted Answer · 2016-05-28 10:29:47Z

0

You need to json_decode your marks and then iterate them as array. Something like this (I don't know if it works in Laravel but you can get an idea):

@foreach ($places as $place)
   @foreach ($place->rates as $rate)
      @foreach (json_decode($rate->marks) as $mark)
        {{var_dump($mark->mark)}}
      @endforeach
   @endforeach
@endforeach

answered May 28, 2016 at 10:29

luchaninov

6,8556 gold badges64 silver badges77 bronze badges

Comments

luchaninov · Accepted Answer · 2016-05-28 10:33:40Z

0

<?php
$str = '[{"id": 1, "mark": 5}, {"id": 2, "mark": 3}, {"id": 3, "mark": 2}]';

$places = json_decode($str);

foreach ($places as $place) {
    echo 'id=>' . $place->id;
    echo 'mark=>' . $place->mark;
    echo "<br>";
}

edited May 28, 2016 at 10:33

luchaninov

6,8556 gold badges64 silver badges77 bronze badges

answered May 28, 2016 at 10:31

Kruti Aparnathi

1751 silver badge11 bronze badges

Collectives™ on Stack Overflow

Convert string with array of json (PHP)

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related