renaming object keys in php

Question

I have spent the whole day since morning to handle this without the solution.

I have these data comes from database. I use PHP PDO connection.

Array (
 [0] => stdClass Object ( [testing_id] => 4 [testing_name] => please [testing_location] => kjnkdsnkdnskjndkjsndjknskdnsk )
 [1] => stdClass Object ( [testing_id] => 3 [testing_name] => please [testing_location] => jknds ndns )
 [2] => stdClass Object ( [testing_id] => 2 [testing_name] => please [testing_location] => be done to me ) )

I want to rename keys in objects instead of testing_id to be just id, testing_name to be name etc.

I have write number of functions like this below

function remove_keys($arr, $table) {
  $object = new stdClass();
  foreach ($arr as $key => $val) {
    $x = (array) $val;
    foreach ($x as $key2 => $value) {
      $new_key = str_replace($table, '', $key2);
      $object->$new_key = $value;
    }
  }
  return $object;
}

and this

function replaceKey(&$array,$table) {    
  $x = array();
  foreach($array as $k => $v){           
    $new_key = str_replace($table, '', $k);
    array_push($x, $new_key);
  } 
  $array = array_combine($x, $array);
  return $array;
}

In all cases, I get only one object result instead of renaming the whole object

stdClass Object ( [id] => 2 [name] => please [location] => be done to me )

How can I rename each index in object and get the full object renamed? Any help please

I need the output to be like this

Array ( 
  [0] => stdClass Object ( [id] => 4 [name] => please [location] => kjnkdsnkdnskjndkjsndjknskdnsk )
  [1] => stdClass Object ( [id] => 3 [name] => please [location] => jknds ndns ) 
  [2] => stdClass Object ( [id] => 2 [name] => please [location] => be done to me ) )

I have searched here without any similar solution

PDO supports selecting data into your own class. You should create your class with correct field names (eg. id,name,location) and use $statement>setFetchMode(PDO::FETCH_CLASS, 'your_class');. See This for a complete example. — Kep
– Kep, Commented Aug 10, 2014 at 21:38
If changing to FETCH_CLASS is not an option (for whatever reason) you can also change your query to rename fields, for example SELECT testing_id as id,testing_name as name,testing_location as location FROM testing_table WHERE [...]; — Kep
– Kep, Commented Aug 10, 2014 at 21:45
Thanks, but can't I handle it in php codes. I have a database with more than 30 tables, create class for each one will be a great pain — Ephra
– Ephra, Commented Aug 10, 2014 at 21:45

Ende Neu · Accepted Answer · 2014-08-10 21:36:48Z

1

You are overwriting the object value in the foreach:

$object->$new_key = $value;

$object is always the same variable, try something like this:

function remove_keys($arr, $table) {
  $temp_array = array();
  foreach ($arr as $key => $val) {
    $object = new stdClass();
    $x = (array) $val;
    foreach ($x as $key2 => $value) {
      $new_key = str_replace($table, '', $key2);
      $object->$new_key = $value;
    }
    $temp_array[] = $object;
  }
  return $temp_array;
}

This will give you back an array of objects.

answered Aug 10, 2014 at 21:36

Ende Neu

15.8k5 gold badges61 silver badges72 bronze badges

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

1 Comment

Ephra Over a year ago

Greeeeet, thanks Ende Neu, It just work fine.... I can't believe if it was just a trick like that...Thanks sana

Collectives™ on Stack Overflow

renaming object keys in php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related