using multiple selection values to create a new page

[tapdancingtenor]

A man sells T-Shirts online. In order for him to select the sizes available for his product, I use a Javascript selectChooser in the PHP interface. However, once he has chosen his sizes from the list of possibilities and clicks the button, I want the form handler to 'remember' which sizes were selected and create a text field for each of the selected sizes. This way he can input a different price on each size, and then send to the DB the new product with the correct sizing/pricing combination. So far, all i am able to do is display each key and value that was selected (using a foreach statement) and to determine how many were selected (using a count). But the value I am getting with $value is the unique ID in the database rather than the description. The unique ID will not be much help to the seller who wants to plug in the right price on the right sized shirt! Also, it would be neat if I had a generic function that would use the count and run thru a procedure that simply creates the text field and the right size next to it as long as it finds elements in the array.

Can anyone help me out?

[devinemke]

a very basic example:

<form action="" method="POST">

<?php
if (!isset($_POST['submit']))
{
	echo '	
	step 1 - choose sizes:<br>
	<select name="sizes[]" multiple>
	<option value="S">small
	<option value="M">medium
	<option value="L">large
	<option value="XL">extra large
	</select><br>
	<input type="submit" name="submit" value="step 2">
	';
}

if (isset($_POST['submit']) && $_POST['submit'] == 'step 2')
{
	if (isset($_POST['sizes']))
	{
		echo 'step 2 - enter prices:<br>';
		foreach ($_POST['sizes'] as $value)
		{
			echo $value . ': <input type="text" name="prices[' . $value . ']"><br>';
		}
		echo '<input type="submit" name="submit" value="step 3">';	
	}
	else
	{
		echo 'you did not choose any sizes';
	}
}

if (isset($_POST['submit']) && $_POST['submit'] == 'step 3')
{
	foreach ($_POST['prices'] as $key => $value)
	{
		if ($value) {echo "INSERT INTO table SET size = '$key', price = '$value'<br>";}
	}
}
?>

</form>

[tapdancingtenor]

Thanks for the simple example. It just may prove to be useful....if I can get it to show something other than the VALUE. You see, in your example, it shows S M L XL which is pretty straightforward. However, in my case lets say the sizes are numbers such as 32, 34, etc. and stored in a DB. Using your code, I am able to retrieve the sizes selected but they are being displayed as 14, 9, 23 (which is their row ID in the D😎 instead of their respective sizes (32, 40, 38). Is there a way to get the actual size to show (in other words the same that was being shown to the user in step 1)?
I dont even know if this is doable but I imagine it would be. Keep in mind as well that I am using a side-by-side chooser of Unselected Sizes versus Selected Sizes to make my selections (for DB many-to-many friendliness) but I dont think that makes any difference...or does it?

Cheers,
tapdancingtenor

[devinemke]

tapdancingtenor wrote:

You see, in your example, it shows S M L XL which is pretty straightforward. However, in my case lets say the sizes are numbers such as 32, 34, etc. and stored in a DB. Using your code, I am able to retrieve the sizes selected but they are being displayed as 14, 9, 23 (which is their row ID in the D😎 instead of their respective sizes (32, 40, 38). Is there a way to get the actual size to show (in other words the same that was being shown to the user in step 1)?

sure. just echo the size instead of the row ID. pull the sizes out of the db and then loop thru the results and echo the size out to the <option> tag during each loop iteration.