Transpose a PHP multidimensional array with predefined keys

Question

I have a multidimensional array with 3 keys ("length", "width" and "height). Each key is associated with an array of values:

$data = [
    "length" => ["12", "44"],
    "width" => ["22", "45"],
    "height" => ["22", "34"]
];

How can I transpose the columns of each key into rows of 3 columns as follows:

$rows = [
    ["length" => "12", "width" => "22", "height" => "22"],
    ["length" => "44", "width" => "45", "height" => "34"]
];

What have you already tried to get those two new arrays (we are still not talking about isnserting but only about formatting data)? Do you know how to check length of input arrays and compare/confirm if those have the same element count? Have you used for loop with that element count and try to make new arrays from existing ones? — Tpojka
– Tpojka, Commented May 5, 2020 at 10:02
@YezanRafed one of the column name is lenght and width and height. — sepide
– sepide, Commented May 5, 2020 at 10:05
Lenght of input arrays is not fixed maybe have change in some times.@YezanRafed — sepide
– sepide, Commented May 5, 2020 at 10:09
I have lenght and width and height column. and i want save this data in two row of my data base because these arrays have two value. first value of all arrays in one row and second value of all arrays in Another row. @YezanRafed . — sepide
– sepide, Commented May 5, 2020 at 10:24

Yezan Rafed · Accepted Answer · 2020-05-05 23:15:36Z

1

The following function will do the job:

function transpose($data)
{
    $result = [];
    $keys = array_keys($data);
    for ($row = 0,  $rows = count(reset($data)); $row < $rows; $row++) {
        foreach ($keys as $key) {
            $result[$row][$key] = $data[$key][$row];
        }
    } 

    return $result;
}

Notice that the function is a general solution it doesn’t depend on the name of the keys nor on the number of entries of each key.

edited May 5, 2020 at 23:15

answered May 5, 2020 at 11:13

Yezan Rafed

8528 silver badges17 bronze badges

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

Comments

Kinglish · Accepted Answer · 2021-06-07 19:46:13Z

0

Late to the party, but here's a one-liner that would work

$data = [
    "length" => ["12", "44"],
    "width" => ["22", "45"],
    "height" => ["22", "34"]
];

foreach ($data as $n => $v) foreach ($v as $vn => $vv) $new[$vn][$n]=$vv;
print_r($new);

https://www.tehplayground.com/OvSeQW8X6JBiDZ4i

answered Jun 7, 2021 at 19:46

Kinglish

23.7k4 gold badges25 silver badges43 bronze badges

Comments

Tanvir Ahmed · Accepted Answer · 2020-05-05 10:24:10Z

-1

you can try this one to get the arrays like you said

   $height = array(12,44);
$width = array(20,50);
$length = array(30,50);
$new_array[0] = $height[0];
$new_array[1] = $width[0];
$new_array[2] = $length[0];
$new_array2 = $new_array[1];
print_r($new_array);
echo "<br>";
print_r($new_array2);

answered May 5, 2020 at 10:24

Tanvir Ahmed

9892 gold badges14 silver badges27 bronze badges

1 Comment

sepide Over a year ago

yes,you get first index in new arary but i want get second array too. I know should use loop but mabye i have 10 index in this array and i can get one element to store in loop

Collectives™ on Stack Overflow

Transpose a PHP multidimensional array with predefined keys

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related