[Resolved] Form w/ x # of repeated rows of variables

Donald_King

In order to ease the treasurer's task of recording members' payment of annual dues, I have developed a form which displays all members in a category with their id and current dues information.
Therefore, I have a page of x number of rows of data with input fields showing members' current values.
The entire "while" process to select the proper members from the MySQL db is within the form parameters.

Problem: On my edit page, when attempting to identify rows with changes, I am only able to access the values from the last row.
Does the form process save iterations of the same form "input field name"?

Is there a qualifier or 'whatever?' which I can attach to a variable to enable processing of all rows?

THANKS

paulnaj

Hi Donald,

I'm not quite sure what you're trying to say ... is it something like ...

<html>
<head>
<title>Dues</title>
</head>
<body>
<table>
	<tr>
		<th>Name</th>
		<th>ID</th>
		<th>Dues</th>
	</tr>
<?php
$result = mysql_query('SELECT * FROM members');
while($member = mysql_fetch_array($result)){
  echo '
	<tr>
  		<td>'.$member['name'].'</td>
	  	<td>'.$member['id'].'</td>
  		<td>'.$member['dues'].'</td>
	</tr>
';
}
?>
</table>
</body>
</html>

Obviously, I've guessed the field names etc, but is this the sort of thing you're trying to achieve?

Paul.

Donald_King

Thanks for your response and accurate example.

Yes - dynamically creating iterations of rows within the form for x rows without specifically renaming the input field name. I can build the form and load the form with data, but the submit provides only the last row.

Thanks!

paulnaj

Aaah, I think I see ...

You have a list of textboxes, or checkboxes, all on the same form and all with the same name.

I do believe you need to alter the names (again I'm guessing the details) of the elements on the form from something like ...

... to ...

The [] after the name tells PHP to create an array of 'dues' in $POST['dues'] (or $GET['dues'] depending on the form action).

Is that it?

Paul.

Donald_King

Paul - Hi

It is working better, but now I am getting the word 'Array'. I had this problem once long ago, but I do not remember how I got rid of it.

Thanks again!!

paulnaj

Hi Donald,

We'll get there!

Following on from my previous post, $_POST['dues'] would now contain an array ... to be specific, the array of values (dues) that were in the rows in the form, one for each row! You'll need to loop through the array to get the values.

Something like ...

for($i = 0; $i < count($_POST['dues']); $i++){
	echo $_POST['dues'][$i].'<br>';
}

// P.S.The next line ...
echo $_POST['dues'];
// ... prints the word 'Array' to the browser.

Paul.

Donald_King

Paul - Hi

Works like a charm. Thanks for 'hanging in there.' I appreciate your help.

Thanks!

Donald