Combing Array Elements Across Different Arrays

shanejeffery86 · December 5, 2008

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:

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?

premiso · December 5, 2008

Not exactly clear on the question, but this might help you get rolling. Also note that this gets insanely long depending on how many arrays you have.

<?php
// takes in multi dimm array
function combineArrays($arrays) {
     $newarray = array();
     $cnt = count($arrays);
     for ($i=0; $i < $cnt; $i++) {
           $array = $arrays[$i];
           foreach ($arrays as $nextArray) {
                  $newarray[] = compareArray($array, $nextArray);
           }
           unset($arrays[$i]); // unset cause we know this one does not compare;
    }

    return $newarray;
}

function compareArray($array1, $array2) {
     if ($array1['sessionid'] == $array2['session_id'] && $array1['type'] == $array2['type']) {
             $array1['ftp_url2'] = $array2['ftp_url'];
             // etc
              return $array1;
     }
     return false; // not compatible
}
?>

That code could easily be fine tuned but my mind is not into now, hopefully that gets you going on what you need. The ultimate result is a returned array of the combined values...I think.

shanejeffery86 · December 5, 2008

Not exactly clear on the question, but this might help you get rolling. Also note that this gets insanely long depending on how many arrays you have.

<?php
// takes in multi dimm array
function combineArrays($arrays) {
     $newarray = array();
     $cnt = count($arrays);
     for ($i=0; $i < $cnt; $i++) {
           $array = $arrays[$i];
           foreach ($arrays as $nextArray) {
                  $newarray[] = compareArray($array, $nextArray);
           }
           unset($arrays[$i]); // unset cause we know this one does not compare;
    }

    return $newarray;
}

function compareArray($array1, $array2) {
     if ($array1['sessionid'] == $array2['session_id'] && $array1['type'] == $array2['type']) {
             $array1['ftp_url2'] = $array2['ftp_url'];
             // etc
              return $array1;
     }
     return false; // not compatible
}
?>

That code could easily be fine tuned but my mind is not into now, hopefully that gets you going on what you need. The ultimate result is a returned array of the combined values...I think.

That is precisely what I am looking for. At the moment, I am attempting to fine tune it as I am getting some very odd data returns. I am getting 1 array with 592 blank elements

premiso · December 5, 2008

Yea, like I said it was more of psuedo code (layout/design) instead of a working example. At least you now have the idea to go off of.

I know where the blanks are coming form anyhow =)

<?php
// takes in multi dimm array
function combineArrays($arrays) {
     $newarray = array();
     $cnt = count($arrays);
     for ($i=0; $i < $cnt; $i++) {
           $array = $arrays[$i];
           foreach ($arrays as $nextArray) {
                  $compared = compareArray($array, $nextArray);
                  if (is_array($compared)) 
                        $newarray[] = $compared;
           }
           unset($arrays[$i]); // unset cause we know this one does not compare;
    }

    return $newarray;
}

That should narrow your results =)

shanejeffery86 · December 5, 2008

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

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:

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?

shanejeffery86 · December 8, 2008

Any ideas?

shanejeffery86 · December 8, 2008

Figured it out. Thanks.

Sign In

Combing Array Elements Across Different Arrays

Recommended Posts

shanejeffery86

Link to comment

Share on other sites

premiso

Link to comment

Share on other sites

shanejeffery86

Link to comment

Share on other sites

premiso

Link to comment

Share on other sites

shanejeffery86

Link to comment

Share on other sites

shanejeffery86

Link to comment

Share on other sites

shanejeffery86

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information