looping json array

[hyster]

im trying to loop the array but its throwing an error on the 500020315 saying its unexpected.

echo a single entry works fine but I don't understand why it dosent like the number in the foreach

 

thanks for any help 

$output = json_decode($json, true);

// works fine with single entry
echo $output['data']['500020315']['members']['3']['role']; // needs to be looped

foreach ($output->data->500020315->members as $item)
{

 echo $item->role . '<br>';

}

[Ch0cu3r]

You need to use array notation.

foreach ($output['data']['500020315']['members'] as $item)
{
   echo $item->role . '<br>';
}

[hyster]

thanks Ch0u3r

[hyster]

this code works fine but id like to sort by the account_name alphabetically.

I have found the sort() function  but the only examples I can find sort from the "1st" level of an array.

 

sort($output) wont work as there is nothing to sort by I need something like

sort($output['data']['500020315']['members']['account_name'])  

 

but when I try to use sort ill get an unexpected foreach

$output = json_decode($json, true);

echo '<table>';

foreach ($output['data']['500020315']['members'] as $item)
{
   echo '<tr><td>'.$item['account_name'] . '</td></tr>';
}
?>
</table>

[Barand]

Use a custom sort function with usort()

 

http://forums.phpfreaks.com/topic/298103-how-to-sort-associative-array/?do=findComment&comment=1520543

[hansford]

$output = array(
'data'=>array(
'500020315'=>array(
'members'=>array(
array('account_name'=>'zebra'),
array('account_name'=>'gazelle'),
array('account_name'=>'chiken'),
array('account_name'=>'antelope')
))));


usort($output['data']['500020315']['members'],function($a, $b) {

    $c = $a['account_name'];
    $d = $b['account_name'];

    if($c == $d) return 0;
    else if($c > $d) return 1;
    else return -1;
});

 

Edited September 16, 2015 by hansford

[Barand]

for string fields, just use strcmp() in the function (that's what it's for)

usort($output['data']['500020315']['members'],function($a, $b) {
            return strcmp($a['account_name'], $b['account_name']) ;
});

For numeric sorts, return  $a - $b

 

(To sort DESC, reverse a and b in the comparisons)

[hyster]

thanks barand.

as usual ur a star

[hyster]

I used strcasemp instead of strcmp