Experts Exchange connects you with the people and services you need so you can get back to work.

PHP multidimensional arrays

I need a recursive function to return the keys and values of a multidimensional array.

cmccarroll

Asked: 2011-03-06

Advertise Here

2 Solutions

LVL 2

CybervanesCommented: 2011-03-06

the following is untested

function RL($array){
	foreach($array as $key => $value){
		if(is_array($array[$key])){
			RL($array[$key]);
		}else{
			echo 'Value for '.$key.' is '.$value.'<br/>';
		}
	}
}
RL($multidimensionalarray);

Open in new window

cmccarrollAuthor Commented: 2011-03-06

Your answer is close, but incomplete. This is the array I am trying to parse.

$array = array( 'john' => array( 'position' => 'CEO', 'salary' => 240000,
'reports'=>array( 'mary' => array( 'position' => 'CIO', 'salary' => 120000,
'reports'=>array( 'james'=>array('position' => 'Sales Rep', 'salary' => 50000,
'reports'=>array() ),'jason'=>array( 'position' => 'CS Rep', 'salary' => 24000,
'reports'=>array() ),'jules'=>array( 'position' => 'CS Rep', 'salary' => 24000,
'reports'=>array() ) ) ), 'charlie'=>array( 'position' => 'CTO', 'salary' => 120000,
'reports'=>array( 'david'=>array( 'position' => 'SysAdmin', 'salary' => 75000,
'reports'=>array( 'chris' => array( 'position' => 'Tech Support', 'salary' => 24000,
'reports'=>array() ) ) ),'sharon'=>array( 'position' => 'Developer', 'salary' => 100000,
'reports'=>array() ) ) ) ) ) );

LVL 2

CybervanesCommented: 2011-03-06

What are you trying to do with the results? Did you want to build a table?

cmccarrollAuthor Commented: 2011-03-06

Yes, possibly muultiple tables if appropriate. I haven't thought that part through

LVL 2

CybervanesCommented: 2011-03-06

What is the `reports` array? If possible you may need to restructure the way the array is built.

array('John' => array( 'position' => 'CEO', 'salary' => 240000, 'reports' => 'Mary')
'Mary' => array( 'position' => 'CIO', 'salary' => 120000, 'reports' => 'James')
)

Or I need a more descriptive explanation on what you are trying to accomplish.

Anybody else have any ideas?

cmccarrollAuthor Commented: 2011-03-06

The reports array is who the user "mary" reports to john. The user "james" reports to mary, etc. I agree the array iseems to be a little redundant, which I think is by design. I am unable to change the existing array. What I am tyring to accomplish is a table like this I believe;

user position salary reports
john ceo 240000
mary cio 120000 john
james Sales Rep 50000 mary
jason CS Rep 24000 mary
jules CS Rep 24000 mary
charlie CTO 120000 john
david Sys Admin 75000 charlie
chirs Tech Support 75000 david
sharron Developer 100000 charlie

LVL 2

CybervanesCommented: 2011-03-06

okay stand by....

LVL 2

CybervanesCommented: 2011-03-06

I'm sorry but this one is hurting my brain!

my plan was to restructure the array to allow proper parsing...
i cant get it to work properly and I've got to move on.

there is a plethora of php experts on this site somebody should be able to come up with a solution, just give it some time.

cmccarrollAuthor Commented: 2011-03-06

Yea, it hurts my brain as well. Thanks anyway.

LVL 82

hieloCommented: 2011-03-07

function getDetails(array $array,$boss='')
{
	$str='';
	if(!$boss)
	{
		$str.='<table border="1"><thead><tr><th>user</th><th>position</th><th>salary</th><th>reports</th></tr></thead><tbody>';
	}
	foreach($array as $person=>$details)
	{
		$str.=sprintf('<tr><td>%s</td><td>%s</td><td style="text-align:right;">%s</td><td>%s</td></tr>'
				,htmlentities($person,ENT_QUOTES)
				,htmlentities($details['position'],ENT_QUOTES)
				,'$'.htmlentities(number_format($details['salary'],2),ENT_QUOTES)
				,htmlentities( $boss,ENT_QUOTES)
				);
		$str.=getDetails($details['reports'], $person);
	}
	if(!$boss)
	{
		$str.='</tbody></table>';
	}
return $str;
}
echo getDetails($array);

Open in new window

LVL 2

CybervanesCommented: 2011-03-07

Very Nice hielo!

cmccarrollAuthor Commented: 2011-03-07

Thanks a bunch. Y'all rock!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

PHP multidimensional arrays

Join & Write a Comment Already a member? Login.

Featured Post