Array question 1

[Aeros]

Im still kind of new to php and Ive looked into solving this on my own...so I must post the question.

Im trying to post the results of a multiple select list to a new page. I realize that I will be passing an array and on the second page (ive tried tons of configurations) the result I get is just 'Array' instead of the actual value(s).
Thank in advance



list.htm
-----------------------------
<form action="list2.php" method="post">
<select multiple name="intColorID[]" size="5">
<option value="1">Red</option>
<option value="2">Green</option>
<option value="3">Blue</option>
<option value="4">Purple</option>
</select>
<input type="submit" name="submit" value="submit">
</form>

list2.php
-----------------------------
<?
$colors = $HTTP_POST_VARS['intColorID'];
echo $colors;
?>

 

[ericbrunson]

Try: echo implode( $colors, "," );
or: print_r( $array );

 

[ericbrunson]

oops, that would be: echo implode( ",", $colors );

 

[Aeros]

hmmm..I never came across that function. That seems to work perfectly.

Thanks!

 

[Aeros]

Now I have a second part to this question. What I am basically trying to do is to take the results from the array, loop through them and do an insert oneach of them. Right now it is only inserting the last record in the array:

$colors = $HTTP_POST_VARS['intColorID'];
$colorCount = count($colors);

while($colorCount > 0)
{
$insertSQL2 = sprintf("INSERT INTO ProductColor_JUNC (intProdID, intColorID) VALUES (last_insert_id(),%s)",
GetSQLValueString($colors[$colorCount], "int"));
$colorCount--;
}

Thanks!

 

[ericbrunson]

Most php tutorials would have covered this, you might google for one.

I'm not really sure why your code isn't working. Here's the easiest way to do it in my opinion:

foreach ( $colors as $color ) {
    // now $color will iterate through each element of your array
}

 

[Aeros]

Yea thats a way to do it...but its still not correcting what is wrong in the insert query which is where the problem lies.

Thanks though

 

[ericbrunson]

Try printing your insert statements to see what's wrong with them.

 

[Olavxxx]

Can you paste the export of the table structure?
So we can look at fieldtypes, etc?

 

[Aeros]

intProdID int(11) nonull
intColorID int(11) nonull

 

[Olavxxx]

I have to go now, but I'll check back on this thread later.. in approx. 3 hrs.

 

[DRJ478]

The answer to the failed SQL is fairly evident:
I see you populating the SQL query, but never executing it. Your query is probably executed outside the foreach() loop and thus only the last color is added.