Merge and invert multi dimensional array

[_s_]

I have a form that runs through a database and outputs values like this:

 for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
echo '<input type="hidden" value="'.$order->products[$i]['qty'].'" name="qty[]">';
   echo '<input type="hidden" value="'.$order->products[$i]['name'].'" name="name[]">';
   echo '<input type="hidden" value="'.$order->products[$i]['final_price'].'" name="price[]">';
}

I need to rearrange the posted result, after submitting the form, so that I have an array containing "qty, name, price" for each line, instead of "qty, qty, qty, qty, qty" and "name, name...etc"

What is the best way of going about this? I am comfortable with loops, but I don't know how to go about this particular problem of rearranging the form data...

[bogu]

This is the first ideea that come into my mind:

$tmp_arr = array();
foreach ($_POST['qty'] as $key=>$value) {
	$tmp_arr[$key]['qty'] = $value;
	$tmp_arr[$key]['name'] = $_POST['name'][$key];
	$tmp_arr[$key]['price'] = $_POST['price'][$key];
}
echo "<pre>",print_r($tmp_arr,1),"</pre>";

[_s_]

Thanks! That rearranges it.

...but only outputs first row three times over. I've tried the following without luck:

for ($i=0, $n=sizeof($temp_arr); $i<$n; $i++) {
echo "<pre>",print($temp_arr[$i]['name']),"</pre><br><br>"; 
}

But I still only get the same row repeated three times over.

I should probably ask this in the newbie forum. It's probably pretty basic

[_s_]

...this is getting pretty annoying. Having same problem with another script as well. Got a number of arrays posted from <input> fields. With the help of bogu (thanks!) I'm now able to rearrange the arrays so they come out as rows, instead of columns. However, I'm not getting past this step, as the print_r keeps coming out as

Array
(
    [0] => Array
        (
            [qty] => 1
            [name] => Product name one
            [price] => 15.0000
        )

[1] => Array
    (
        [qty] => 1
        [name] => Product name one
        [price] => 15.0000
    )

[2] => Array
    (
        [qty] => 1
        [name] => Product name one
        [price] => 15.0000
    )
)

This array is supposed to print out product name two and three, and the relevant qty and price for these as well, instead of repeating product one.

Any suggestion appreciated. Thanks!

[bpat1434]

How about:

$tmp_array = array();
for($i=0; $i<count($_POST['qty']); $i++)
{
  $tmp_array[] = array($_POST['qty'][$i], $_POST['name'][$i], $_POST['price'][$i]);
}

echo '<pre>';
var_dump($tmp_array);
echo '</pre>';

What does that give you?

[_s_]

Thanks bpat!

This one here actually worked pretty well:

for($i = 0; $i < count($tmp_arr); $i++) {
  $value = $qty[$i].' - '.$name[$i].' - '.$price[$i];
  echo $value.'<br>';
}

[bpat1434]

Glad to be of some help!! 🙂

[macexperts]

function array_join( $multidimensional_array ) {

/*
	Writen by: Leonardo Martinez
	Contact: [url]http://www.leonardomartinez.com/guest-book/[/url]

	Created: 10-10-2009
	Modified: 10-15-2009

	This routine takes an unlimited number of two dimensional arrays array[x][y], 
	and flips, or swaps, the two keys so it becomes an array[y][x]. Explained differently, 
	it swaps or flips the first key with the second key, thus inverting the two keys
	so the values can be referenced. 		

	// Example:  	
				samplearray['directiory'][0] = "myicons";
				samplearray['directiory'][1] = "myicons";
				samplearray['directiory'][2] = "myiconsold";
				samplearray['directiory'][3] = "myiconsold";

				samplearray['filename'][0] = "hat.png";
				samplearray['filename'][1] = "dog.png";
				samplearray['filename'][2] = "mice.png";
				samplearray['filename'][3] = "rat.png";

	// the above array converts it to

				newarray[0]['filename'] 	= "hat.png"
				newarray[0]['directiory'] 	= "myicons"
				newarray[1]['filename'] 	= "dog.png"
				newarray[1]['directiory'] 	= "myicons"
				newarray[2]['filename'] 	= "mice.png"
				newarray[2]['directiory'] 	= "myiconsold"
				newarray[3]['filename'] 	= "rat.png"
				newarray[3]['directiory'] 	= "myiconsold"


*/


$keys = array_keys( $multidimensional_array );

$arr_joined = array();

foreach($multidimensional_array[$keys[0]] as $key_counter => $value1) {

	$temp_array = array();

	foreach($keys as $key) {
		$temp_array[$key] = $multidimensional_array[$key][$key_counter];
	}

	$arr_joined[] = $temp_array;
}

return $arr_joined;

}