Getting value in array

[asa_carter]

Edit: I just noticed this post appears in Install. It should be in Coding. Please move if possible.

Hi

I am building a shopping cart which uses a size matrix for different sizes of clothing.

http://www.argyllnewmedia.co.uk/itrenz/list.php?id=01010000

1@@51::1@@13

The cart array has three values. The item id, the quantity and the size matrix id. This example shows two items in the shopping cart.

My question is can I directly access a value in the array without iterating through the entire cart to get the value?

I want to get the quantity of the item in stock, subtract the quantity of the same item in the cart, and then display an option to add more to the cart only if there is a sufficient quantity.

[asa_carter]

I cant get the logic right in the code below. I'm iterating through all items in the array to get the value but this is causing problems as it displaying the links multiple times depending on how many items are in the array.

It would be better if I could just access the item in the array that I need instead of looping thorugh them all but I'm not sure how.

     // size matrix
     echo "<form action=\"addbasket.php?id=$item[0]\" method=\"post\">";
     echo "<select name=\"size\">";
     echo "<option value=\"0\">Please select</option>";

 // get the size data from the DB
 $size_matrix = mysql_query("SELECT * FROM size_matrix WHERE item_id='$item[0]'");

 // loop through all the different sizes
 while($sizes = mysql_fetch_row($size_matrix))
 {

   // if the quantity for this size is greater than 0 get cart data
   if ($sizes[3]>0)
   {

	 // get the cart array
     $array_item = explode("::", $cart);

	 // loop through all the items in the cart
     while (list($value, $contents) = each($array_item))
     {
       $split=explode("@@", $contents);
       $item_id=$split[0];
       $item_quant=$split[1];

       $split=explode("**", $item_quant);
       $item_quant=$split[0];
       $item_size=$split[1];

	   // if the item id in the size matrix is the same as item id in the array AND the size id in the size matrix is the same as the size id in the array
	   if (($sizes[1]==$item_id) && ($sizes[0]==$item_size))
	   {

   	     // subtract the quantity in the array from the quantity in the DB and display option if quantity > 0
	     $qt = $sizes[3] - $item_quant;
         if ($qt>0)
           echo "<option value=\"$sizes[0]\">$sizes[2] in array</option>";
	   }

	   // the current item and its size are not stored in the cookie array so we will display it anyway as it has a quantity > 0 in the DB 
	   else
         echo "<option value=\"$sizes[0]\">$sizes[2]</option>";

 	 }
   }
 }

 echo "</select>";

[asa_carter]

I've rewritten the code to store the array.

It is now stored as "1@@11". That is "Item ID@@Size IDQuantity.

I thought I could use something like this to get the quantity:

if (in_array("$sizes[1]@@$sizes[0]**15",$array_item))
  echo "<option value=\"$sizes[0]\">dgdgdfgdf</option>";

But it only returns true if the match is exact. I only want to be able to search for $sizes[1]@@$sizes[0]** and miss of the quantity and then use it to return the quantity.

How do you search for a substring in an array?

[NogDog]

Merged similar threads.

[Weedpacket]

asa_carter wrote:

How do you search for a substring in an array?

Have a look at [man]preg_grep[/man].

Maybe also consider making your data structure a bit smarter so that, e.g.:

if(!empty($array_item[$sizes[1]][$sizes[0]]))
echo "<....$sizes[0]>";

[asa_carter]

Is the correct regular expression to match 1@@1**

$keys = preg_grep("/^[".$sizes[1]."]@{2}[".$sizes[0]."]\*{2}/", $array_item);
echo "<option value=\"$sizes[0]\">$keys[0]</option>"; 

This displays the option for the first item in the cart but if I change $keys[0] to $keys[1] It displays the second.

It should only be matching one item but its matching both. Is there something wrong with the reg exp?

[asa_carter]

Sorted.

     echo "<select name=\"size\">";
     echo "<option value=\"0\">Please select</option>";

 // get the size data from the DB
 $size_matrix = mysql_query("SELECT * FROM size_matrix WHERE item_id='$item[0]'");

 // loop through all the different sizes
 while($sizes = mysql_fetch_row($size_matrix))
 {
   // if the quantity for this size is greater than 0 get cart data
   if ($sizes[3]>0)
   {
     $incart = false;
	 // get the cart array
     $array_item = explode("::", $cart);

     $keys = preg_grep("/^[".$sizes[1]."]@{2}[".$sizes[0]."]\*{2}/", $array_item);

     foreach($keys as $key =>  $value)
     {
       if($value)
	   {
         $incart = true;
         $split=explode("**", $value);
         $item_quant=$split[1];
	     $qt = $sizes[3] - $item_quant;
         if ($qt>0)
	       echo "<option value=\"$sizes[0]\">$sizes[2]</option>";
	   }
     }
     if ($incart==false)
       echo "<option value=\"$sizes[0]\">$sizes[2]</option>";		 
   }
 }
 echo "</select>";