change key names in array in php

Question

ok..I'm trying to re-map the keynames of a key-value array in php using a fieldmap array ie. i want the $outRow array to hold $inRow['name1'] = 10 to $outRow['name_1'] = 10 for a large set of pre-mapped values..

        $fieldmap=array("name1"=>"name_1","name2"=>"name_2");

          private function mapRow($inRow) {

            $outRow = array();

            foreach($inRow as $key => $value) {

                $outRow[$this->fieldmap[$key]][] = $value;

            }

            return $outRow;

          }  // end mapRow


  public function getListings($inSql) {

    // get data from new table
    $result = mysql_query($inSql);
    if (!result) {
      throw new exception("retsTranslate SQL Error: $inSql");
    }

    while ($row = mysql_fetch_assoc($result)) {

      $outResult[] = $this->mapRow($row);

    }

    return $outResult;

  }  // end getListings

this is not working..I'm getting the array but its using $outResult[0][keyname]...I hope this is clear enough :)

hold on..its looking like the way im calling this function is the culprit. im posting some more code. — menriquez
– menriquez, Commented Sep 12, 2013 at 17:59

Ram Sharma · Accepted Answer · 2014-09-29 09:48:12Z

1

$fieldmap=array("name1"=>"name_1","name2"=>"name_2");

  private function mapRow($inRow) {

    $outRow = array();

    foreach($inRow as $key => $value) {

        $outRow[$this->fieldmap[$key]][] = $value;

    }

    return $outRow;

  }  // end mapRow


while ($row = mysql_fetch_assoc($result)) {

  //$outResult[] = $this->mapRow($row);
    $outResult[= $this->mapRow($row);

}

I commented your line of code and added new one..it definitely got what you mentioned in question.

edited Sep 29, 2014 at 9:48

Ram Sharma

8,8157 gold badges48 silver badges59 bronze badges

answered Sep 12, 2013 at 18:20

Subash

2301 gold badge3 silver badges12 bronze badges

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

Comments

Jason · Accepted Answer · 2013-09-12 18:17:09Z

0

If you can structure your arrays to where the keys align with the values (see example below) you can use PHP array_combine(). Just know that you will need to make absolutely sure the array is ordered correctly.

<?php

    $fieldmap = array( 'name_1', 'name_2', 'name_3' );

    private function mapRow($inRow)
    {
        $outRow = array_combine( $this->fieldmap, $inRow );

        return $outRow;
    }

For example, if your array was:
array( 'name1' => 10, 'name2' => 20, 'name3' => 30 );

The new result would be:
array( 'name_1' => 10, 'name_2' => 20, 'name_3' => 30 );

Let me know if this helps.

answered Sep 12, 2013 at 18:17

Jason

1,9621 gold badge14 silver badges16 bronze badges

Comments

Ram Sharma · Accepted Answer · 2014-09-29 09:48:27Z

0

Try this:

function mapRow($inRow) {
$outRow = array();

foreach($inRow as $key => $value) {
    $outRow[preg_replace('/\d/', '_$0', $key,1)] = $value;
}
return $outRow;
}

edited Sep 29, 2014 at 9:48

Ram Sharma

8,8157 gold badges48 silver badges59 bronze badges

answered Sep 12, 2013 at 18:07

Deewendra Shrestha

2,4552 gold badges26 silver badges55 bronze badges

Collectives™ on Stack Overflow

change key names in array in php

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related