On Thursday 06 June 2002 12:03, Steven Jarvis wrote:
> I'm trying to store an array in a mysql db. I'm creating the array
> variable through an html form and passing it to the page where I store
> it in the db. I want to create the array with a form, store it in the
> db, then display it in another form with a <select> statement. However,
> I'm getting extra array elements, including another array in the final
> element. I can't figure out how to deal with this extraneous data.
>
> Page 1:
> The insertion form looks like this:
> <form method="post" action="arraytest.php">
> COLORS:<br />
> <input type="text" name="color[]" size="30" /><br />
> <input type="text" name="color[]" size="30" /><br />
> <input type="text" name="color[]" size="30" /><br />
> <input type="text" name="color[]" size="30" /><br />
> <input type="text" name="color[]" size="30" /><br />
> <input type="text" name="color[]" size="30" /><br />
> <input type="submit" value="do it!" />
> </form>
>
> That's five input fields.
>
> Page 2:
> I want the user to be able to use none, some, or all of the fields, so I
> don't know how many elements will be in the array.
>
> $color[] = $_POST["color"];
That should be:
$color = $_POST["color"];
Actually from your results below it seems like you've enabled register_globals
and it's not necessary to explicit (re)assign $color.
> I'm testing the incoming array with:
>
> while ($element = each($color))
> {
> echo $element["key"];
> echo ": ";
> echo $element["value"];
> echo "<br>\n";
> }
>
> And I get results like this printed to the browser (I always get seven
> entries, including the last array entry):
>
> 0: green
> 1: black
> 2: blue
> 3:
> 4:
> 5:
> 6: Array
>
> First question: is there something I can do at this point to cut the
> empty entries
foreach ($color as $key => $val) {
if ($val) {
$tmp[] = $val;
}
}
$color = $tmp;
That will remove empty values from $color.
> (and that extra seventh array entry) out of the array so
> that it's clean going into the db?
See above about assigning $color from $_POST.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
You're always thinking you're gonna be the one that makes 'em act different.
-- Woody Allen, "Manhattan"
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
