PHP Forum

**knucklehead00** · 12-05-2008, 10:39 AM

Hey there guys.

I am trying to combine two or more arrays based on values that match within those arrays.

Here is an example of the array I am working with:

Code:

Alright, so, here is what needs to happen.

If Array #5 and #6 have the the same session_id and type, I need the file_name, ftp_url, and http_url of Array #6 to be appended to Array #5. All of the values within the arrays are the same minus the file_name, ftp_url, and http_url.

Also, please know that their could be 4-5 matching arrays all with the same session_id and type and they would all need to be merged into *1* entry with their respective file_name, ftp_url, and http_url.

Any ideas on how to do this?

**knucklehead00** · 12-05-2008, 02:45 PM

Alright I got it VERY close to what I want. Just have one issue.

Code:

function combineArrays($arrays) {
    $newarray = array();
    $cnt = count($arrays);
    for ($i=0; $i < $cnt; $i++) {
        $array = $arrays[$i];
        
        $comparison_found = false;
        $exists_in_array = false;
        
        foreach ($arrays as $nextArray) {
            
            foreach($newarray as $storedarray)
            {    
                if(strpos($storedarray['id'], $nextArray['id']))
                {
                    $exists_in_array = true;
                }
            }
            
            if(!$exists_in_array)
            {
                if($comparison_found == true)
                {
                    $match_existing_array = end($newarray);
                    $compared_array = compareArray($match_existing_array, $nextArray);
                    if($compared_array)
                    {
                        $value_holder = array_pop($newarray);
                        array_push($newarray, $compared_array);
                    }
                    
                }
                else
                {
                    $compared_array = compareArray($array, $nextArray);
                    if (is_array($compared_array))
                    {
                        $newarray[] = $compared_array;
                        
                        $comparison_found = true; 
                    }    
                    else
                    {
                        $comparison_found = false;
                    }
                }
            }
        }
        
        if($comparison_found == false || $exists_in_array == false)
        {
            $newarray[] = $array;
        }
        
        unset($arrays[$i]);
    }
    return $newarray;
}

function compareArray($array1, $array2) {
    if ($array1['session_id'] == $array2['session_id'] && $array1['type'] == $array2['type'] && 
                $array1['id'] != $array2['id']) {    
             
                 $array1['id'] = $array1['id'].", ".$array2['id'];
                 $array1['file_name'] = $array1['file_name'].", ".$array2['file_name'];
                $array1['ftp_url'] = $array1['ftp_url'].", ".$array2['ftp_url'];
                 $array1['http_url'] = $array1['http_url'].", ".$array2['http_url'];
                 $array1['rating']['class'] = $array1['rating']['class'].", ".$array2['rating']['class'];
                 
                 return $array1;
             }
             return $false;
}

The problem I am having now is that I cannot get the duplicate entries to go away.

Here is what is coming out:

Code:

Now because ID 179 and 180 were already used in Array #2, they should not be getting their own output like shown in Array #3 and Array #4. If the ID 179 and 180 already exist in a previous array, then do not let them create their own arrays.

Any ideas?