checkboxes

[techmeister]

Good day all:

I have the following conundrum:

An admin page pulls data from a MySQL DB
It consists of and displays separate records
It is a single HTML form with hidden fields, the values of which are displayed as text
I want the values of the hidden fields of each item to be inserted into a new database if a single checkbox is checked against that item

I have had limited success with this, and at present only one record (the last one for some reason best known to php) is inserted whichever record I check.

Can anyone deliver me some insight into this??
Cheers!
Russ

[Anon]

Might I suggest a very simplified code snippet?

Nick

[techmeister]

Sure:

//Dynamic page with checkboxes:

$display_this = "
<form method=\"post\" action=\"step4.php\"><table>";
while($row = mysql_fetch_array($result)) {
$Name = $row['Name'];
$Age = $row['Age'];
$itemID = $row['id'];
blah blah...

    display_this .= "

//separate table cells with hidden fields in
<tr><td><input type=\"hidden\" name=\"Name\" value=\"$Name\"><p>$Name</p></td></tr>
<tr><td><input type=\"hidden\" name=\"Name\" value=\"$Name\"><p>$Name</p></td></tr>
<tr><td><input type=\"checkbox\" name=\"Accept[$Name]\" value=\"$itemID\"></td></tr>
//etc etc
}
display_this .= "
</table></form>";

//step4.php (processing script:

if (isset($addusers)) {
if(is_array($Accept)) {
$msg = "<p><b>These users now subscribed: </b></p>";
for($i=0; $i<=$teamID; $i++) {
$insertsql = "INSERT INTO $table_user (Name,Age)
VALUES('$Name','$Address')";
$result = mysql_query($insertsql, $connection) or die(mysql_error());
}
}
else {
$msg = "<p>You didn't select anyone!</p>";
}

All this does is insert the last result,
regardless of the number of results I
check.

Thanks for the offer of help.
Russ

[Anon]

Hmmm, looks like your checkbox value is the same for every hidden field, that is provavly the problem.

If not then I suggest you re-script a test model with just 2 fields and experiment with various versions untill you get it ríght, try printing the checkbox value each time it is used, I think you'll find the reason it's affecting only the last one is that it's overwriting all the previuos versions.

Try and let me know, but if you cna't find it post the 2 field version complete.

Good luck

Nick

[techmeister]

Okay Nick:

I can now succesfully echo to the page the required values as arrays of the array: $HTTP_POST_VARS (This is now a 2d array right?)

Obviousely enough, as I echo out my SQL query it is: INSERT INTO <table> VALUES, array, array, array, etc etc.

How can I first extract the info from each array as an array node of $HTTP_POST_VARS before doing an insert?

Many thanks for your help
Russ