CODEWITHSUNDEEP
phparrays
seven
seven

Reputation: 115

Merging and looping multi dimensional array

I'm trying to loop some array using foreach. This is the code which demonstrates what I'm doing

     $q = "SELECT * "
       ."FROM ".TBL_FRUITSDETAILS."";
        $fruitsdetails = $database->query($q);
        $var = array();
    while($line = mysql_fetch_assoc($fruitsdetails)){
       $var[] = $line;
    }


  $q = "SELECT * "
       ."FROM ".TBL_NUMDETAILS."";
        $numdetails = $database->query($q);
        $var2 = array();
    while($line2 = mysql_fetch_assoc($numdetails)){
         $var2[] = $line2;
        // $n++;
    }

$out = array();
foreach ($var as $key => $value){
   // $out[] = array_merge_recursive($value, $var2[$key]);

    foreach ($var2 as $key => $value) {
        $out1[] = array_merge_recursive($var[$key], $var2[$key]);
    }
}


print_r(json_encode($out1));

However, this outputs

appleone
bananatwo
appleone
bananatwo

and I want to display it like this instead

appleone
appletwo
bananaone
bananatwo

Upvotes: 3

Views: 59

Answers (3)

Domain
Domain

Reputation: 11808

Try this,

$var = array (1,2);    
$var2 = array (a,b);

$out = array();
foreach ($var as $key => $value){
    foreach($var2 as $k=>$v){
        $out[] = $value.$v;
    }
}
print_r(json_encode($out));

Upvotes: 2

Narendrasingh Sisodia
Narendrasingh Sisodia

Reputation: 21422

I think your loop should be something like this. There's no need of using array_merge_recursive function

$var = array (1,2);    
$var2 = array ('a','b');
$result = array();
foreach($var as $key => $val){
    foreach($var2 as $k => $v){
        $result[] = $val.$v;
    }
}

Upvotes: 2

Daan
Daan

Reputation: 12246

There is no need to use array_merge_recursive just a nested loop will suffice:

$var = array (1,2);    
$var2 = array ('a','b');


$out = array();
foreach($var as $arrayNumeric){
  foreach($var2 as $arrayAlphaNumeric){
      $out[] = $arrayNumeric.$arrayAlphaNumeric;
  }
}

Upvotes: 1

Related Questions