PHP looping over JSON objects in my database

Question

I'm storing some values using the mysql json field type, in Sequel Pro I'm seeing them as follows

["feature1","feature2","feature3","feature4"]

In my PHP file, I can print out the contents using

echo $plan->features;

but what I want to do is look over each one so I can style them, but the problem is when I stick it in a foreach loop I get the following:

Invalid argument supplied for foreach()

My loop is straightforward

foreach ($plan->features as $features) {
}

I'm not sure I'm doing things right.

What is the output of print_r($plan->features);? I don't see where you decode your json, nor where you assign it to the property features. — Rizier123
– Rizier123, Commented Aug 30, 2016 at 12:41

halfer · Accepted Answer · 2016-08-30 19:44:21Z

6

This is a JSON String

["feature1","feature2","feature3","feature4"]

User json_decode() for the above string

$string = json_decode($teststring,TRUE);

And after that you can for loop the variable or foreach the variable

foreach($string as $single_value)
{
     echo $single_value.'<br>';
}

Output:

feature1

feature2

feature3

feature4

edited Aug 30, 2016 at 19:44

halfer

20.2k20 gold badges110 silver badges207 bronze badges

answered Aug 30, 2016 at 12:39

Naresh Kumar P

4,2802 gold badges18 silver badges34 bronze badges

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

3 Comments

Naresh Kumar P Over a year ago

Store the json_string in a variable called $teststring and after that decode it as shown in my example and use it in foreach loop. Cool it will work..

Naresh Kumar P Over a year ago

@BigJobbies. Have you obtained the output or you face hindrance still. Let me know if my help is needed....

Naresh Kumar P Over a year ago

Welcome @BigJobbies. That is the reason i pointed out the Error at first for your knowledge. Glad to help you...

Collectives™ on Stack Overflow

PHP looping over JSON objects in my database

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related