Parsing multi-dimensional array with json_decode

Question

I'm trying to show the top voters of the month on my website but I'm having trouble with this array:

{
   "name":"Server name",
   "address":"***********",
   "port":"****",
   "month":"201601",
   "voters":[
      {
         "nickname":"John",
         "votes":"6"
      },
      {
         "nickname":"Beth",
         "votes":"4"
      },
      {
         "nickname":"Jimmy",
         "votes":"4"
      }
   ]
}

This is what I have but it's not working:

foreach($results as $nickname => $votes) {
    $i++;

    echo $i . '. ' . $nickname . ' (' . $votes . ')<br \>';
}

How would I go by doing this so it shows up like this?

John (6)
Beth (4)
Jimmy (4)

Thank you.

Update: Wow, thank you guys! You were all extremely helpful. It was hard to choose an answer between them all. You're all awesome!

foreach($results['voters'] as $voter) {echo $voter['nickname'] . '(' . $voter['votes'] . ')' ? — Scott
– Scott, Commented Jan 25, 2016 at 19:05

JAAulde · Accepted Answer · 2016-01-25 19:21:29Z

1

You need to decode the data structure, then operate on it as you would any other PHP variables/objects/arrays.

<?php
// Raw JSON input
$input = '{
   "name":"Server name",
   "address":"***********",
   "port":"****",
   "month":"201601",
   "voters":[
      {
         "nickname":"John",
         "votes":"6"
      },
      {
         "nickname":"Beth",
         "votes":"4"
      },
      {
         "nickname":"Jimmy",
         "votes":"4"
      }
   ]
}';

//Unserialize the JSON into PHP structures
$results = json_decode($input);

//$results is now an object with properties `name`, `address`, ..., `voters`, etc

// `$results->voters` is an indexed array of objects
// each of these objects have a `nickname` and `votes` property
// no need for a counter, use the index (gleaned from @trincot's answer)
foreach ($results->voters as $i => $voter) {
    // I like `printf` here bcause it keeps my template cleaner to understand
    printf(
        '%s. %s (%s)<br />',
        ($i + 1),
        $voter->nickname,
        $voter->votes
    );
}

edited Jan 25, 2016 at 19:21

answered Jan 25, 2016 at 19:09

JAAulde

19.5k5 gold badges56 silver badges65 bronze badges

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

1 Comment

bjaeger Over a year ago

This worked like a charm. It also taught me a little about printf. I did a little research and I'm definitely going to use it more. It does look a lot nicer!

trincot · Accepted Answer · 2016-01-25 19:09:38Z

1

You could do it with this loop:

foreach ($results->voters as $i => $el) {
    echo ($i+1) . ". {$el->nickname} ({$el->votes})<br/>";
}

Note that you need first to select the voters key, as you are not interested in the other keys at the top level.

Secondly, you're input has some objects (not arrays), so you need to use the -> operator to access the object properties.

answered Jan 25, 2016 at 19:09

trincot

357k38 gold badges282 silver badges338 bronze badges

Comments

JAAulde · Accepted Answer · 2016-01-25 19:17:00Z

1

What you can do is:

$i=1;
foreach($result as $r)
{
    echo $i . '. ' . $r['nickname'] . ' (' . $r['votes'] . ')<br \>';
    $i++;
}

edited Jan 25, 2016 at 19:17

JAAulde

19.5k5 gold badges56 silver badges65 bronze badges

answered Jan 25, 2016 at 19:05

pritesh

2,20222 silver badges26 bronze badges

Comments

LuanComputacao · Accepted Answer · 2016-01-25 20:03:21Z

1

You can use this code.

$string = '{"name":"Server         name","address":"***********","port":"****","month":"201601","voters":[{"nickname":"John","votes":"6"},{"nickname":"Beth","votes":"4"},{"nickname":"Jimmy","votes":"4"}]}';

$result = json_decode($string);

// To print HTML using DOM
echo "<ol>";
foreach($result->voters as $voter){
    echo "<li>$voter->nickname ($voter->votes)</li>";
}
echo "</ol>";

Working here -> https://eval.in/507711

This code print this HTML

<ol><li>John (6)</li><li>Beth (4)</li><li>Jimmy (4)</li></ol>

The result is here -> https://jsfiddle.net/h6q8zy86/

edited Jan 25, 2016 at 20:03

answered Jan 25, 2016 at 19:30

LuanComputacao

218 bronze badges

Collectives™ on Stack Overflow

Parsing multi-dimensional array with json_decode

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related