PHP - Looking For An Orphan (comparing Arrays)

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 I have two arrays of mysql values $a1, $b1 I am trying to loop through each $a value, no problem, but I want to see if each element in $a = one of the values in $b so:

$a = array(1, 2, 3, 4, 5, 6);
$b = array(4, 6);
$y = '';
foreach ($a1 as $a){
 foreach ($b1 as $b){
  if ($a[val] == $b[val]){
  $y = '*';
  }
}
echo $y.$a.'<br />';
}  

I was kinna hoping it would give me 1 2 3 *4 5 *6 Its most definitely not though... Im sure Im flawed in my logic but have coded so much other crap I just can't see the answer!  ty for the look/help.  

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.

Here are the two arrays to compare.

Peopleskills            
PeopleID   SkillID
2          2   
2          7   
2          9
2              11
3          2
3                  12
3          14   
4          5
            
Equipskills            
EquipID   SkillID   
1                2          
1                9   
1               11   
2               5      
2               7      
2               9      
2               12   
2               13   
2               14   
3               2   
4               11      

The common link is SkillID.
Each EquipID has some required SkillIDs that people must have to operate that machine.
As long as a PeopleID has the required SkillIDs from the EquipSkills, that person has permission to that machine.
This will be used create a third array.
It will look something like the following.

                          EquipIDs
                      1     2     3     4     5     6     7     8      9      10       11     12
PeopleIDs   
2                    x     x
3                           x
4
5

What might be the best way to code this?

"Cannot find search daemon". I tried.

I've been wracking my brain for the last two hours trying to simplify this. It seems like I'm running over the two arrays far too many times, and that I should be able to do it in one pass somehow.

I have two associative arrays, the first contains a set of older options (previous version), the second is a default set of new options. I want to compare the two arrays, and strip out any old options that aren't in the new set. I want to add options from the new set that aren't already in the old, and I don't want to overwrite and of the old options that already have values.

Here's a copy of the sandbox I've been working it out in; it works, but it does four separate operations on the arrays to achieve the result: http://pastebin.com/erbFujkG