Help Inserting from Dynamic Form

stevea

Hi All,

I'm using php and mysql on windows for a website.

I am pulling a list of names from a mysql database and dynamically displaying them in a form.

I want to give the user the option to insert the name in the form along with a numeric value of their choice (they would input this value in the form) into another database table.

The problem is that the dynamic form will never display the same amount of users.

How can I do this without hard-coding checks for form variables?

Thx,

leatherback

Hi,

I am a bit confused, and your question is not clear.

What is the problem you are facing?
How to get the data into the form? How to make a field where a user can place a number? Or how to insert data in a table?

stevea

Here's an example, I create the dynamic portion of the form with a while statement. Here's what the dynamic form inputs look like:

<input type="text" name="memberpoints<?php echo $memberid; ?>" size="1" maxlength="50"></input></td>

Lets say the two memberid's returned from my query are 1 and 2. My while statement creates the following variables:

$memberpoints1
$memberpoints2

My problem is this...after the form's submit button is pressed, how do I know which variables to call in my insert statement(s)?

Example:

insert into table (field) values ($memberpoints1);
insert into table (field) values ($memberpoints2);

The work around I'm using is to hard code if statements looking for the above variables.

Example:

if ($memberpoints1) { insert... }

if ($memberpoints2) { insert... }

But this means that if my original query returns 3 records for the dynamic form, I will miss the 3rd one.

Thx,

leatherback

Hi,

I think you are looking for array functions. This way, you can use one variable (memberpoints) and use the key (in this case one and three) to distinguish between persons, and the value for the ponts given:

<input type="text" name="memberpoints[<?php echo $memberid; ?>]" size="1" maxlength="50"></input></td>
 while statement creates the following variables:

=>

$memberpoints[1]
$memberpoints[3]


//----

foreach($memberpoints as $key=>$value)
  {
  echo $key;
  echo $value;
  }

stevea

leatherback,

Thanks very much for your suggestion - it is exactly what I wanted.