forms and arrays - newbie

[Anon]

Hi, newbie question sorry.

I want to have a form with 3 input text fields that the user can fill in if they wish.

When the user submits the form I would like into to do an SQL insert for each field that has been completed and loop through.

What is the besy way ?? reading it into some sort of array and then doing foreach ?????

Thanks.

[khaine]

The foreach sounds like a winner to me. you could use a count on the field and then a for loop.

ie. html reads

-- form --

<INPUT type="text" name="box[]">
<INPUT type="text" name="box[]">
<INPUT type="text" name="box[]">

-- end of form --

php reads

<?

$howmany=count($box);
for ( $temp=0; $temp<$howmany; $temp++ )
{
sql insert
}

?>

[simons]

I wrote small form handling program in PHP. It can remember content in the fields after submition, it can check if those fields were field in correctly and if they were filled in at all. You can even convert data that was entered into SQL statment after submition. Take it a try and tell me if you find it useful.

You can download it from here:
http://sourceforge.net/projects/phpform

Simon

[Anon]

cheers guys,

sorted it by pulling the information from the http_get_vars

if (isset($http_get_vars)) {
while(list($var, $value ) = each($HTTP_GET_VARS)) {
if (empty($value)) {
}
else {
run sql insert query
{
}
}

thanks again