PHP - Comparing Nested Associative Arrays

I have an array that has several amounts (based on $$$ sales) attached to a 'name' 'id' and 'goal'. As you can see some of the names, id's, and goals are the same. My goal is to gather a total of amounts and attach each total to whichever 'name', 'id', and 'goal' that made the sale. I'm honestly not sure how to go about this as I'm still learning.

Probably easiest to explain what I am trying to do, to illustrate the impasse I have came to. I have online store With a number of products. Visitors can click on products, clicking brings details of the product came up in a frame on the right (with a field to enter the quantity), which can than be added to the shopping cart in a separate frame below it bottom right (passed using a different script (the one which I am having issues with)). So each time a product is added to the cart, three dynamic fields are passed via post script, which are named "product_name", "unit_quantity" and "unit_price" (these are all hidden fields called from a sql database based on what product the user clicked on).

So for the shopping cart, I want to incorporate an associative array using the three dynamic fields described above("product_name", "unit_quantity" and "unit_price") within a session so that a number of products can be added (hence using an array rather than a variable).

So shopping cart i have done so far reads:

<?php
session_start();

if (!isset ($product_name) && !empty($product_name))
{

if (!session_is_registered("product_info"))
{
$pos=0;
session_register("pos");
$product_info[$pos]= array ( 'product_name'=>$product_name, 'unit_quantity'=>$unit_quantity,
'product_quantity'=>$unit_quantity * $unit_price);
session_register("product_info");
}


?>

Not sure (as I am new to sessions, how to call the array to the screen). I have read through past threads but have not been able to found anything similar to what I am trying to achieve).

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

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.