Trouble with using variable

[franklin664]

Hello

What I am trying to do is have a form that has some input boxes which are made through a for loop. And named something like name$i. So each input box is going to be named name1, name2 and so on. The problem is when i submit the form and want to insert the values in to a database i figure i go just go through the variables with another for loop something like this

for($i=1;$i<13;$i++)
{
$query="insert into table (Name) values ('$name$i');

}

The problem is it does take $name$i as the variable $name1. It just puts in a 1.

Is there a way to make this work i know there must be.

Thanks

[jubripley]

To answer your question, you can do something like this:

for($i=1;$i<13;$i++)
{
$varname = "$name$i";
$query="insert into table (Name) values ('$$varname');

}

BUT DON'T DO THAT!!

Form element names can have subscripts (eg, foo[3]). PHP will create an array.

So to set up the form, do something like this:

for($i=0;$i<12;$i++)
{
  print "<input type='text' name='my_name[$i]' />\n";
}

When the form is submitted, a global array $my_name will be created, containing the values you submitted.

Then to process, do this:

for($i=0;$i<12;$i++)
{
$query="insert into table (Name) values ('$my_name[$i]');

}

or even cleaner (IMO):

foreach ($my_name as $name) {
  $query = "INSERT INTO table (Name) values ('$name')";
}

[franklin664]

Thanks for the info