Topic: Update via checkbox

[khna]

Hi all,

I am looking for a way to batch update checkbox fields values in Mysql
database. I have a repeat region with checkboxes and am trying to update checkbox fields in MySQL database.

Something like Update command in ASP/Vbscript.

I have tried:
<?php
$ParamID = "1";
if (isset($HTTP_GET_VARS['checkbox'])) {
$ParamID = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['checkbox'] :
addslashes($HTTP_GET_VARS['checkbox']);
}
$result=mysql_query("UPDATE tbl_model_name SET fld_select = 1 WHERE ID =
$ParamPicID")
or die ("Invalid Query");
//header ("Location: test_selected.php");
?>

First i am not sure if the code is 100% correct.
2nd which i am pretty sure it seems like the checkbox values are not being passed from the previous page.

How do i pass or force to pass the checkbox values in the repeated region to make this code work?

I thank you in advance.

Best Regards
Khna  
 
 
 

[morpheus.100]

This insert will only execute a single time. To udate multiple rows you need to create a loop with a counter to insert the data one row at a time.

[khna]

Thanks for the reply,
I am new to PHP and to be honest i need a bit more help.

To udate multiple rows you need to create a loop with a counter to insert the data one row at a time.

How????

[morpheus.100]

Ok you have say 30 checkboxes all needing to input data to the same row.

Each checkbox in your for needs a count identifier. Create this by making a loop.

Firstly I would have a selector so I can select how many for fields i need and create the form dynamically.

so
<?php
for($i=0; $i <= $number; $i++){
?>
<input type="checkbox" name="element_name[<?php echo $i ?>]">
<?php } ?>

This will repeat the <input> line the amount of times you define in $number. The php echo $i line will add a count value to the field to identify for the sqlupdate.

Now you need a similar function for the insert. You should now be able to play around to achieve a similar cycle to insert the data.