How to modify PHP array keys

Question

I have some basic data coming from a csv upload, the table is formatted like so:

Cost 1	Cost 2	Cost 3
5	12	5
1	13	9
9	0	1

The data saves to the database and using array_chunk I have an array that looks like this (I will need to loop through these later)

array(
  [0] => Array
      (
          [Cost 1] => 5
      )
  [1] => Array
      (
          [Cost 2] => 12
      )
  [2] => Array
      (
          [Cost 3] => 3
      )
   )

I want to modify the array to read the keys as values instead, so the final array would look like this with the column title saving in every instance:

array(
  [0] => Array
      (
          [cost] => Cost 1
          [demand] => 5
      )
  [1] => Array
      (
          [cost] => Cost 2
          [demand] => 12
      )
  [2] => Array
      (
          [cost] => Cost 3
          [demand] => 3
      )
   )

I know I can use array_keys and array_values to target each, but can't quite get my head around how I'd use that to create the above.

azibom · Accepted Answer · 2021-02-15 16:16:04Z

1

This script work for you
I first iterate the array with foreach and then in each element use the array_keys and array_values for give the keys and values and because that is just one row in the element I use the [0]

<?php

$array = [
    [
        "Cost 1" => 5
    ],
    [
        "Cost 2" => 12
    ],
    [
        "Cost 3" => 3
    ],
];

$formattedArray = [];
foreach($array as $element) {
    $formattedArray[] = [
        "cost" => array_keys($element)[0],
        "demand" => array_values($element)[0],
    ];
}

print_r($formattedArray);

output

Array
(
    [0] => Array
        (
            [cost] => Cost 1
            [demand] => 5
        )

    [1] => Array
        (
            [cost] => Cost 2
            [demand] => 12
        )

    [2] => Array
        (
            [cost] => Cost 3
            [demand] => 3
        )
)

edited Feb 15, 2021 at 16:16

answered Feb 15, 2021 at 16:11

azibom

1,9541 gold badge11 silver badges24 bronze badges

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

1 Comment

threeedv Over a year ago

This is exactly what I needed, thank you so much for your help.

Beshambher Chaukhwan · Accepted Answer · 2021-02-15 16:16:05Z

0

$newCostArray=[];
foreach($costArray as $index => $carr) {
  $newCostArray[$index]=[];
  foreach($carr as $key => $val) {
     echo "$key = $val<br>";
     $newCostArray[$index]['cost']=$key;
     $newCostArray[$index]['demand']=$val;
  }
}

answered Feb 15, 2021 at 16:16

Beshambher Chaukhwan

1,4482 gold badges9 silver badges13 bronze badges

2 Comments

Oliver Over a year ago

Rather than adding the link to your answer as a comment, add a line of text "As suggested here we can do something like". It improves the readability of your question and can improve the answers performance (votes).

Beshambher Chaukhwan Over a year ago

I created that link though 😂 but thanks alot I'll keep that in mind @Oliver 🥺

Collectives™ on Stack Overflow

How to modify PHP array keys

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related