Remove Int keys and values from Multidimensional array PHP

Question

I have this array (i can't change it) :

   array(3) {   
[0]=>
  array(8) {
    ["kampania"]=> string(6) "dasdas"
    [0]=> string(6) "dasdas"
    ["300x250"]=> int(1)
    [1]=> int(1)
    ["160x600"]=> int(2)
    [2]=> int(2)
    ["728x90"]=> int(3)
    [3]=> int(3)
  }
  [1]=>
  array(8) {
    ["kampania"]=> string(12) "aaaaaaaaaaaa"
    [0]=> string(12) "aaaaaaaaaaaa"
    ["300x250"]=> int(4)
    [1]=> int(4)
    ["160x600"]=> int(5)
    [2]=> int(5)
    ["728x90"]=> int(6)
    [3]=> int(6)
  }
  [2]=>
  array(8) {
    ["kampania"]=> string(20) "AAAAAAAAAAAAAAAAAAAA"
    [0]=> string(20) "AAAAAAAAAAAAAAAAAAAA"
    ["300x250"]=> int(7)
    [1]=> int(7)
    ["160x600"]=> int(8)
    [2]=> int(8)
    ["728x90"]=> int(9)
    [3]=> int(9)
  }
}

As you can see, I got repeated values, because the array as the defined key and then an integer key.

How can I create a function which will remove the integer key and value from array and return a new array already "clean"

the result expect should be like this:

array(3) {
    [0]=>
      array(8) {
        ["kampania"]=> string(6) "dasdas"
        ["300x250"]=>  int(1)
        ["160x600"]=>  int(2)
        ["728x90"]=>   int(3)
      }
      [1]=>
      array(8) {
        ["kampania"]=> string(12) "aaaaaaaaaaaa"
        ["300x250"]=>  int(4)
        ["160x600"]=>  int(5)
        ["728x90"]=>   int(6) 
      }
      [2]=>
      array(8) {
        ["kampania"]=> string(20) "AAAAAAAAAAAAAAAAAAAA"
        ["300x250"]=> int(7)  
        ["160x600"]=> int(8) 
        ["728x90"]=>  int(9) 
      }
    }

Thanks Guys! I'm really sorry for ask it , but I loose already so much time trying to fix it by myself

Why can't you change it? Surely Isn't it your code that's doing the database query as well? — Mark Baker
– Mark Baker, Commented Nov 26, 2015 at 10:36
For the record, I assume this is caused by using something like mysql_fetch_array instead of mysql_fetch_assoc and really should be fixed at that level instead of post-processing the data... — deceze
– deceze ♦, Commented Nov 26, 2015 at 10:39
So where is this array coming from? How is it being generated? — Mark Baker
– Mark Baker, Commented Nov 26, 2015 at 11:12

user2959229 · Accepted Answer · 2015-11-26 10:44:13Z

2

function unset_num_keys($array)
{
    $array_out = array();
    foreach($array AS $k => $v)
    {
        if(is_array($v))                            //value is an array, so clean it
        {
            $array_out[$k] = unset_num_keys($v);    //clean "child" arrays
        }
        elseif(!is_numeric($k))
        {
            $array_out[$k] = $v;                    // key is "safe"
        }
    }
    return $array_out;
}

Then

$clean_array = unset_num_keys($old_array);

answered Nov 26, 2015 at 10:44

user2959229

1,3552 gold badges11 silver badges21 bronze badges

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

1 Comment

user4838566 Over a year ago

Thank you very much, it does exactly what i wanted! Thanks again

Tintu C Raju · Accepted Answer · 2015-11-26 10:46:24Z

1

Loop threw the array and if the key(index) is numeric then remove that item from the array.

foreach($level1_array as &$arr){

  foreach ($arr as $key => $value) {
    if (is_int($key)) {
      unset($arr[$key]);
     }
   }
}

Example

<?php 
$level1_array = array(

    array(
            "smith",
            "name" => "smith",
            "20",
            "age"=>20
        ),
    array(
            "smith",
            "name" => "smith",
            "20",
            "age"=>20
        ),
     array(
            "smith",
            "name" => "smith",
            "20",
            "age"=>20
        ),
);

foreach($level1_array as &$arr){

 foreach ($arr as $key => $value) {
   if (is_int($key)) {
     unset($arr[$key]);
    }
  }
}

var_dump($level1_array);
?>

edited Nov 26, 2015 at 10:46

answered Nov 26, 2015 at 10:33

Tintu C Raju

2,7002 gold badges23 silver badges25 bronze badges

3 Comments

Steve Over a year ago

this will result in an empty array - you need a nested loop to iterate the second level arrays, all the 1st level indexes are numeric

Steve Over a year ago

You need the key from the outer loop as well, (or iterate by reference as &$arr) else you are just unsetting the element in a copy

Tintu C Raju Over a year ago

@Steve yes i miss the reference and corrected. thank you. :-)

rain · Accepted Answer · 2015-11-26 10:59:12Z

0

You can try this code:

//$data = $yourData;
$newData = array();
foreach($data as $v){
    array_push($newData,array_flip($v));
}

answered Nov 26, 2015 at 10:59

rain

2431 silver badge8 bronze badges

Collectives™ on Stack Overflow

Remove Int keys and values from Multidimensional array PHP

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related