Converting a Multi-dimensional Array Structure

[Bannockburn]

Hi,

I have a database query returning the following array structure;

Array
(
    [0] => Array
        (
            [Category] => Array
                (
                    [id] => 9
                    [name] => ABC
                )

        [Ds] => Array
            (
                [ds_id] => 39
            )

    )

[1] => Array
    (
        [Category] => Array
            (
                [id] => 10
                [name] => DEF
            )

       [Ds] => Array
            (
                [ds_id] => 40
            )

    )

)

I need to change the structure of the array(to feed a json object) to this (dynamically);

Array
(
    [0] => Array
        (
           [id] => 9
           [name] => ABC
           [ds_id] => 39
         )

[1] => Array
    (
       [id] => 10
       [name] => DEF
       [ds_id] => 40
     )

)

I am embarassed to say i have spent the best part of two days mucking around with a multitude of recursive functions to no avail. At best i completely flatten the array at worst i end up with a complete mishmash.

I tried to set up a php debugger to watch the process but after 3 days of trying i came to the conclusion it was not compatible with my working environment. I am still using php 4.4.9.
Any assistance would be greatly appreciated.

[johanafm]

First off, you should not need to change it, provided you have the possibility of changing the javascript code. After you eval the response object client side

// assuming the evaled object is in a variable called data
for (var i = 0; i < data.length; ++i) {
	var id = data[i].Category.id;
	var name = data[i].Category.name;
	var ds_id = data[i].Ds.ds_id;

// Make use of the above...
}

Else, if you really want to change the structure, there's no need using recursion. All you need is a loop

// Once again assuming your array is in a var called $data
for ($i = 0; $i < count($data); ++$i) {
	$id		= $data[$i]['Category']['id'];
	$name	= $data[$i]['Category']['name'];
	$ds_id	= $data[$i]['Ds']['ds_id'];

$data[$i] = array("id" => $id, "name" => $name, "ds_id" => $ds_id);
}

[Bannockburn]

johanafm;10924443 wrote:

First off, you should not need to change it, provided you have the possibility of changing the javascript code. After you eval the response object client side

// assuming the evaled object is in a variable called data
for (var i = 0; i < data.length; ++i) {
	var id = data[i].Category.id;
	var name = data[i].Category.name;
	var ds_id = data[i].Ds.ds_id;

// Make use of the above...
}

Else, if you really want to change the structure, there's no need using recursion. All you need is a loop

// Once again assuming your array is in a var called $data
for ($i = 0; $i < count($data); ++$i) {
	$id		= $data[$i]['Category']['id'];
	$name	= $data[$i]['Category']['name'];
	$ds_id	= $data[$i]['Ds']['ds_id'];

$data[$i] = array("id" => $id, "name" => $name, "ds_id" => $ds_id);
}

thanks johanafm - i forgot to mention that the keys in the array can change , and possibly the arrays too maybe deeply nested - i posted what was what i thought was a simpler view.

#  function test ($data = null, $key = null){
# $key;
# foreach ($data as $k => $v){
# if(is_array($v){
# if(is_numeric($k){ $key = $k;}
# $this->test($v, $key);
# }else{
# echo "$key:::$k:::$v\n";
# }
# }

The echo out will iterate through the array with:
0:🆔:9
0::name::ABC
0::ds_id::41
etc

I just have to build a multi dim result set - and my mind has gone blank - i have sprinled the code with array_merge, array_push.

[NogDog]

See if this does what you need:

/**
 * Convert a n-dim array to a 1-dim array
 * @param array $arr
 * @return array
 */
function flatten($arr)
{
   $return = array();
   foreach($arr as $key => $val)
   {
      if(is_array($val))
      {
         $ret = flatten($val);
         $return = $return + $ret;
      }
      else
      {
         $return[$key] = $val;
      }
   }
   return $return;
}

// USAGE:
foreach($array as $key => $val)
{
   $array[$key] = flatten($val);
}

[johanafm]

Just setting up some test data...

$data = array(
			"Category" => array(
				"id"	=> 2,
				"name"	=> "car"
			),
			"Ds" => array(
				"ds_id" => 7,
				"content" => array(
					"title"	=> "Bla bla bla",
					"desc"	=> "Lots of bla bla bla",
					"name"	=> "another name"
				)
			)
		);

And very simple code to create a completely flat array.

function flatten($data, &$flat = array()) {
	foreach ($data as $k => $el) {
		if (is_array($el)) {
			 flatten($el, $flat);
		}
		else {
			/* In case you need to deal with the possibility of keys on different levels,
				being the same, this part renames them to "key", "key2", "key3" */
			if (array_key_exists($k, $flat)) {
				$i = 2;
				while (array_key_exists($k.$i, $flat))
					$i = intval($i) + 1;
			}
			else
				$i = "";

		$flat[$k.$i] = $el;
	}
}
}

$flat = array();
flatten($data, $flat);
print_r($flat);

And in case you want a 2-dimensional array like you said,

foreach ($topLevelArray as $k => $el) {
	if (is_array($el))
		$topLevelArray[$k] = flatten($el);
}

[Bannockburn]

Thanks NogDog and johanafm for your efforts - they work, really appreciated - i was close, just couldn't see that last mile.