PHP explode conundrum.

[HCProfessionals]

I'm trying to add options to products.

 

Currently, I have them in this format: Leather reinforced hilt,5.00::Stabbing tip,3.00::Logo,10.00

 

$option_results = mysql_query("SELECT product_options FROM products WHERE product_id='".$product."'");
   while($option_row = mysql_fetch_array($option_results)){
         $option = explode("::", $option_row[0]);
         $option_part = explode(",", $option[0]);
         $option_part[0] = $option_name;
         $option_part[1] = $option_price;
         echo "<li><a href=\"#\">".$option_name.", Add $".$option_price."</a></li>";
    }

 

I would like the output to be:

 

<li><a href="#">Leather reinforced hilt, Add $5.00</a></li>

<li><a href="#">Stabbing tip, Add $3.00</a></li>

<li><a href="#">Logo, Add $10.00</a></li>

[smerny]

you are setting $option_part[0] to $option_name which has not been set... looks like you want to do the opposite... same with $option_price

[PFMaBiSmAd]

After the explode, $option is an array. You would need to loop over that array and process each entry in the array.

[freeloader]

Also, my escaping is a bit off, but putting the $ sign there blank between double quotation marks (") seems dangerous. Use single quotations (') for this, they also process slightly faster.

[scootstah]

but putting the $ sign there blank between double quotation marks (") seems dangerous

 

It won't hurt anything, because there is no valid variable there to parse.

[HCProfessionals]

I'm not really getting anywhere...

 

					$option_results = mysql_query("SELECT product_options FROM products WHERE product_id='".$product."'");
					while($option_row = mysql_fetch_array($option_results)){
							$sep_option = explode("::", $option_row[0]);
							foreach ($sep_option as $sep_result)
							{
								$option_part = explode(",", $sep_result);
								$option_part[0] = $option_name;
								$option_part[1] = $option_price;
								echo "<li class=\"product\" id=\"option-".$option_name."\"><input class=\"purchase\" type=\"button\" value=\"Add to cart\"><span class=\"title\">".$option_name."</span>, Add $<span class=\"price\">".$option_price."</span></li>";
							}

					}

[Jessica]

As was said before, you're not defining $option_name or $option_price. You're doing those statements backwards, you're saying that the first key in $option_part should be set to the value within $option_name. $option_name does not exist. Switch it around.

[HCProfessionals]

As was said before, you're not defining $option_name or $option_price. You're doing those statements backwards, you're saying that the first key in $option_part should be set to the value within $option_name. $option_name does not exist. Switch it around.

 

Wow, totally missed that. Thank You!!!!