[RESOLVED] need help with arrays - drop down lists

TJC

Good'ay

I am very new to PHP and just cant seem to get this right. I have created what is hi-lighted in red below from tutorials/manuals etc and really have no idea what I'm doing yet.

I am trying to add 2 drop down lists to the view item page of my shopping cart so as users can select colours.

The info is writing to the data base as 'array' in both fields, instead of the selected fields-

I have tried a couple of different formats - always with the same result.

Any pointers in the right direction greatly appreciated

cheers

<td width=280 valign=top>
<font color=black face=verdana size=2><b><?=$a1[ItemName]?></b></font>
<br>
<font color=black face=verdana size=1><b>Category:</b></font> <?=$DisplayCategory?>
<br>
<font color=red face=verdana size=2><b>Price: $<?=$DisplayPrice?></b></font>

<br>
<p><b><font size="2">Please choose your colours before<br>
adding to your cart </font></b></p>
<table style="border-collapse: collapse;" cellpadding="0" cellspacing="0" width="242">
<tr>
<td width="123"><font size="2">Cloth Colour:</font></td>
<td width="116">
<?
$ItemClothcolour = array(
0=> "",
1=> "Porcelain",
2=> "Sandstone",
3=> "Navy Blue",
4=> "Midnight Green",
5=> "Aquamarine",
);
$ItemClothcolour = str_replace(" ", " ", $ItemClothcolour);

echo '<SELECT name=ItemClothcolour>';
foreach ($ItemClothcolour as $key => $value)
{
echo '<OPTION value='.$value.'> '.$value.'';
}
echo '</select>';

?>
</td>
</tr>

<tr><td width="123">
<p><font size="2">Webbing Colour: </font></td>
<td width="116">
<?
$ItemWebcolour = array(0=> "", 1=> "Black",2=> "White",);
$ItemWebcolour = str_replace(" ", " ", $ItemWebcolour);

echo '<SELECT name=ItemWebcolour>';
foreach ($ItemWebcolour as $key => $value)
{
echo '<OPTION value='.$value.'> '.$value.'';
}
echo '</select>';

?>

</select></td>
</tr>

</table>

<p><br>

</p>

</form>

</td>
</tr>

</table>

leatherback

I have no clue why you putr
<input type=hidden name=ItemClothcolour value="<?=$ItemClothcolour?>">
<input type=hidden name=ItemWebcolour value="<?=$ItemWebcolour?>">
in there?

What is the idea? Shouldn't the input type me <select> ?

devinemke

take out those 2 hidden fields. you don't want/need them. the form processor will receive the selected values form the form.

TJC

Hi
Thanks for the quick replies

Removed the lines

and nothing writes to the database in those fields

Put them in and the word array is sent to the data base for both fields

devinemke

post your form processing code

TJC

this is add.php

<?
require_once("conn.php");

$MyTotal = $POST[ItemPrice] + $POST[ItemShipping];

$q1 = "insert into devbg_orders_content set
OrderID = '$PHPSESSID',
ItemID = '$POST[ItemID]',
ItemName = '$POST[ItemName]',
ItemClothcolour = '$POST[ItemClothcolour]',
ItemWebcolour = '$POST[ItemWebcolour]',
ItemPrice = '$POST[ItemPrice]',
ItemQty = '1',
ItemShipping = '$POST[ItemShipping]',
ItemTotal = '$MyTotal' ";
mysql_query($q1) or die(mysql_error());

header("location:cart.php");

devinemke

obvious question: the first option is both of your select boxes is blank, are you in fact choosing a valid option before subittig the form?

put the following as the first line in your form processor...

print_r($_POST);

...to see the exact contents of the passed values. also echo the $q1 variable to see the fully formed query before running it.

leatherback

this:
echo '<SELECT name=ItemClothcolour>';
foreach ($ItemClothcolour as $key => $value)
{
echo '<OPTION value='.$value.'> '.$value.'';
}
echo '</select>';

?>
</td>
</tr>

<tr><td width="123">
<p><font size="2">Webbing Colour: </font></td>
<td width="116">
<?
$ItemWebcolour = array(0=> "", 1=> "Black",2=> "White",);
$ItemWebcolour = str_replace(" ", " ", $ItemWebcolour);

echo '<SELECT name=ItemWebcolour>';
foreach ($ItemWebcolour as $key => $value)
{
echo '<OPTION value='.$value.'> '.$value.'';
}
echo '</select>';

</select></td>
</tr>

Should of course take place WITHIN the <form..></form> tags, otherwise it is not within the form, and not submitted.

TJC

Array ( [ItemID] => 1 [ItemName] => SPECIAL - 14ft x 10ft Rectangle [ItemClothcolour] => Array [ItemWebcolour] => Array [ItemShipping] => 0 [ItemPrice] => 0.05 [s1_x] => 85 [s1_y] => 8 [s1] => Add to cart )

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/buysell/public_html/store/add.php:2) in /home/buysell/public_html/store/conn.php on line 26

Warning: Cannot modify header information - headers already sent by (output started at /home/buysell/public_html/store/add.php:2) in /home/buysell/public_html/store/add.php on line 27

leatherback

Hi TJC

Read the posts. The two hidden vars are supposed to go, and you need to echo the select boxes within the form tags.

TJC

moved the form tags -
Array ( [ItemClothcolour] => Array [ItemWebcolour] => Array [ItemID] => 1 [ItemName] => SPECIAL - 14ft x 10ft Rectangle [ItemShipping] => 0 [ItemPrice] => 0.05 [s1_x] => 99 [s1_y] => 21 [s1] => Add to cart )
Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/buysell/public_html/store/add.php:2) in /home/buysell/public_html/store/conn.php on line 26

Warning: Cannot modify header information - headers already sent by (output started at /home/buysell/public_html/store/add.php:2) in /home/buysell/public_html/store/add.php on line 27

It seems the values are incorrect and I cant work out why

leatherback

What is the code for the form now?

TJC

Thank you very muchly DM 🙂

Dropped the 2 hidden vars, moved the form tag and it seems fine.

Its 4.30am here and I'm about to get some shut eye

Once again - thank you

This is the form now

	<td width=280 valign=top>
			<font color=black face=verdana size=2><b><?=$a1[ItemName]?></b></font>
				<br>
			<font color=black face=verdana size=1><b>Category:</b></font> <?=$DisplayCategory?>
				<br>
			<font color=red face=verdana size=2><b>Price: $<?=$DisplayPrice?></b></font>


			<br>
            <p><b><font size="2">Please choose your colours before<br>
            adding to your cart </font></b></p>
            <table style="border-collapse: collapse;"  cellpadding="0" cellspacing="0" width="242">
              <tr>

<td width="123"><font size="2">Cloth Colour:</font></td>
<td width="116">
<?
$ItemClothcolour = array(
0=> "",
1=> "Porcelain",
2=> "Sandstone",
3=> "Navy Blue",
4=> "Midnight Green",
5=> "Aquamarine",
);
$ItemClothcolour = str_replace(" ", " ", $ItemClothcolour);

echo '<SELECT name=ItemClothcolour>';
foreach ($ItemClothcolour as $key => $value)
{
echo '<OPTION value='.$value.'> '.$value.'';
}
echo '</select>';

?>
</td>
</tr>

              <tr><td width="123">

<p><font size="2">Webbing Colour: </font></td>
<td width="116">
<?
$ItemWebcolour = array(0=> "", 1=> "Black",2=> "White",);
$ItemWebcolour = str_replace(" ", " ", $ItemWebcolour);

echo '<SELECT name=ItemWebcolour>';
foreach ($ItemWebcolour as $key => $value)
{
echo '<OPTION value='.$value.'> '.$value.'';
}
echo '</select>';

</select></td>
</tr>

            </table>

            <p><br>

			</p>


				<input type=hidden name=ItemID value="<?=$a1[ItemID]?>">
				<input type=hidden name=ItemName value="<?=$a1[ItemName]?>">
                <input type=hidden name=ItemShipping value="<?=$a1[ItemShipping]?>">
				<input type=hidden name=ItemPrice value="<?=$DisplayPrice?>">
				<input type=image src=images/img_20.gif border=0 name=s1 value="Add to cart" class=sub>

			</form>


		</td>					
</tr>

<tr>	
		<td colspan=2><?=$DisplayDescription?></td>
</tr>

<tr>	
		<td colspan=2 align=center><?=$DisplayRateing?></td>
</tr>

</table>

	<!-- View Item table end -->

leatherback

OK,

if it works, it works.

You do need closing tags for your options:
<option...>...</option>