Jump to content

Update via checkbox


Recommended Posts

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

 

 

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.