PHP - Comparing Two Arrays And Merging Values That Are A Near Match

This has kept me busy for a couple of hours. I have two arrays that I would like to compare against each other to see matches and otherwise. Simple enough, right?


foreach ($array1 as $value){
if (in_array($value, $array2)) {
 echo $value."-FOUND<br />";
} else {
 echo $value."-NOT!<br />";
}
}


Using print_r I can CLEARLY see matches:

Code: [Select]
array1 = Array ( [0] => CHARLES [1] => TOM [2] => DICK [3] => HARRY)

array2 = Array ( [0] => HARRY [1] => DICK [2] => TOM [3] => CHARLES)



The only difference I can see is the keys - but why should that matter for what I'm trying to do?

Both arrays were converted to uppercase. I have done variations of search_array, array_intersect and array_unique - but absolutely nothing is working. 3 hours later and I'm no further then I started off. WTF?

Hi there,

I am using HTML forms to post values from a data entry page. When they arrive on the second page - I have to extract them from the POST array. This is fine, but I now have to merge them somehow.

When I use print_r to view the POSTed data, I see:

Code: [Select]

    [namesUnem] => Array
        (
            [0] => Brian
            [1] => Richard
            [2] => Sarah
        )

    [commentsUnem] => Array
        (
            [0] => Brian Comments here
            [1] => Richard Comments should be entered here
            [2] => Sarah's Comments were also entered here
        )

    [namesHW] => Array
        (
            [0] => Sally
            [1] => Kate
            [2] => William
        )

    [commentsHW] => Array
        (
            [0] => Sally Comments here
            [1] => Kate's Comments should be entered here
            [2] => William's' Comments were also entered here
        )


There are 2 more such arrays being POSTed. I would need to merge in order to see the following:

Quote


[Name] => Brian [Comment] => Brian Comments here [Type] => namesUnem
[Name] => Richard [Comment] => Richard Comments should be entered here [Type] => namesUnem
[Name] => Sarah [Comment] => Sarah's Comments were also entered here [Type] => namesUnem
[Name] => Sally [Comment] => Sally Comments here [Type] => namesHW
[Name] => Kate [Comment] => Kate's Comments should be entered here [Type] => namesHW
[Name] => William [Comment] => William's' Comments were also entered here [Type] => namesHW




Any help greatly appreciated

Kindest Regards

AikenD

Hi wondering if there's a simple way to merge or update the data from one array to another . I've tried merge data but it just adds additional records rather than merging them off one common key.   The array is just simply adding a name to another array the format of both is as follows   Array 1   [0] => stdClass Object
(
[name] =>
[market] => Football
[selection] => 7051575

)   )   Array 2   Array
(
[0] => stdClass Object
(
[name] => Something
[market] =>
[selection] => 7051575

) )     There are other fields but I'm just trying to merge the name from Array two into Array one using the selection as a common key. Is there an easy command like merge or do I have to loop thru the arrays to add the data.   Thanks

Hello

I am having a problem getting the difference between two arrays.
The first array $list has all codes that can be linked to a specific id
The second array $exist has the values select and linked to a specfic id.
Both arrays are storing integers array $list should have 110,111,112,113,114,115.
Array $exist gets 110, 114 115 from the database the difference should be 111 & 112

I think the problem is with array $exist that is getting its values from the database.
Could the problem be that the arrys are storing data differently?
How do I resolve this problem?


/**==========ARRAY 1=======**/
/**All values for this type in array for comparison against**/
Code: [Select]
$list = array('110','111','112','113','114','115');
/**view values in array $list**/
Code: [Select]
var_dump($list);
array(6) { [0]=> string(3) "110" [1]=>  string(3) "111" [2]=>  string(3) "112" [3]=>  string(3) "113" [4]=>  string(3) "114" [5]=>  string(3) "115" }

/**==========ARRAY 2=======**/
 /**Get stored types for specific id **/
Code: [Select]

 $exist = array();//create array
 
  //store values in array
  $query = "SELECT type
    FROM contact
    WHERE id ='$id'
            AND deleted = 'N'
            ORDER BY type";
 $result = mysqli_query ($mysqli, $query);
 while($row = mysqli_fetch_array($result))
     {
        $exist[] = $row;
     }
/**View values in array for specific id in array $exist**/
Code: [Select]
var_dump($exist);
array(3){ [0]=>array(2){ [0]=>string(3) "110" ["contact_type"]=> string(3) "110"} [1]=> array(2){[0]=> string(3) "114" ["contact_type"]=> string(3) "114"} [2]=> array(2){ [0]=> string(3) "115"["contact_type"]=> string(3) "115"}}

/**==========RESULT=======**/
/**Get the difference between all possible type and stored values linked to a specific id **/
Code: [Select]
$difference = array_diff($list, $exist);
/**viewthe difference between the two arrays**/
Code: [Select]
var_dump($difference);
array(6) { [0]=>  string(3) "110" [1]=>  string(3) "111" [2]=>  string(3) "112" [3]=>  string(3) "113" [4]=>  string(3) "114" [5]=>  string(3) "115" }

Hello everyone,

I'm currently working on a large inventory management screen; the website has multiple "distributors" with their own inventory of products. Each distributor has the potential to carry the entire catalog of SKU's so right now, I have the stock/sku/dealer ID/product ID in one table with the product data/ID in another and am only inserting new rows if they are carrying the product.

However they want to manage all of the inventory at once so I need to determine which IDs are update queries and which are insert queries.

I'm trying to achieve this by comparing an array of the submitted data against an array of their existing inventory. If they don't have an entry for the submitted data key, we need to insert a new row for it to track their inventory.

I just can't figure out how to get the keys to line up. Here is what I have; I tried to put it all into obviously defined variables for this forum.

Code: (php) [Select]
// assign our submitted values to an array
$submitted_data = $_POST;

// remove the SKUs with 0 or no inventory submitted
$submitted_data = array_filter($submitted_data);

// pull the distributor id out of the array before the insertion loop
$distributors_inventory_distributor_ID = array_pop($submitted_data);

// pull all existing inventory for this distributor to see if we are adding new inventory
// or updating old inventory
$existing_Inventory_Result = mysql_query("SELECT distributors_inventory_product_ID FROM distributors_inventory WHERE distributors_inventory_distributor_ID = $distributors_inventory_distributor_ID ORDER BY distributors_inventory_product_ID ASC", $db);

// verify there is a result
$existing_Inventory_num_results = mysql_num_rows($existing_Inventory_Result);
if ($existing_Inventory_num_results > 0){

while($existing_Inventory_row = mysql_fetch_assoc($existing_Inventory_Result)){

// put existing inventory into an array
$existing_Inventory[] = $existing_Inventory_row['distributors_inventory_product_ID'];

}

}

$update_Inventory_Array = array_diff($submitted_data, $existing_Inventory);

// print the array [DEBUG ONLY]
echo '<h1>$update_Inventory_Array:</h1>';
print_r($update_Inventory_Array);
echo '<hr/>';
echo '<h1>$submitted_data:</h1>';
print_r($submitted_data);
echo '<hr/>';
echo '<h1>$existing_Inventory:</h1>';
print_r($existing_Inventory);

That is outputting this:
Quote

$update_Inventory_Array:
Array ( [963] => 5 [979] => 2 [982] => 2 [974] => 1 [32] => 5 )

$submitted_data:
Array ( [963] => 5 [979] => 2 [982] => 2 [974] => 1 [32] => 5 )

$existing_Inventory:
Array ( => 32 [1] => 963 [2] => 974 [3] => 979 )

I'd like it to be:
Quote

$update_Inventory_Array:
Array ( [963] => 5 [979] => 2  [974] => 1 [32] => 5 )

$submitted_data:
Array ( [982] => 2 )

$existing_Inventory:
Array ( [32] => 5 [963] => 1 [974] => 1 [979] => 2 )


Can anyone suggest how to do this? I think if I could make the existing_Inventory array line up with my submitted_data array I could sort the rest out but I'm not sure how to get the keys/data to line up properly.