Input in db multiple values

zzz

Somehow I can't seem to be able to figure this one out.

I have a simple form with text fields:

<input type="text" name="val1">
<input type="text" name="val2">
<input type="text" name="val3">
<input type="text" name="val4">

If a user enters info in val1-3 and submits, how do Iinput this in db.

Do I have to do a check for eac value submitted?

if ($_POST['val1'] != '') {
   // INSERT INTO...
}

and so on?..

laserlight

If a user enters info in val1-3 and submits, how do Iinput this in db.

The question is, how do you want to handle this? Require that the user input for val4? Just process what the user has entered?

zzz

Just whatever the user enters and skip the empty fields.

laserlight

In that case you have to handle them one by one. If you used an array a foreach loop would make it easier. Note that before testing "$_POST['val1'] != ''" you should check if the incoming variable existed using isset(). Alternatively, just use empty().

bradgrafelman

Is each value being stored in a separate row? If so, it would probably be simpler to rename the field to "val[]" in the HTML and use a [man]foreach[/man] to loop through the $_POST['val'] array.

laserlight

If so, it would probably be simpler to rename the field to "val[]" in the HTML and use a foreach to loop through the $_POST['val'] array.

Yes, that is precisely what I mean by "If you used an array a foreach loop would make it easier."

bradgrafelman

Woops, guess I didn't do a very job looking over your post - sorry bout that!