javascript - How do I save data from a checkbox array into database -

- 

function check_uncheck(truefalse) {    var boxes = document.forms[0].chkboxarray.length;    var form = document.getelementbyid('checkform');    (var = 0; < boxes; i++) {      if (truefalse) {        form.chkboxarray[i].checked = true;      } else {        form.chkboxarray[i].checked = false;      }    }  }
<form name="checkform" id="checkform" method="post" action="checkboxes1.php">    <input type="checkbox" name="chkboxarray" value="1" /><br />    <input type="checkbox" name="chkboxarray" value="2" /><br />    <input type="button" name="checkall" value="check boxes" onclick="check_uncheck(true)" />    <input type="button" name="uncheckall" value="uncheck boxes" onclick="check_uncheck(false)" />    <input type="submit" value="save">    </form>    snippet shows how works without connection database

i trying save data sent checklist database i'm stuck. thinking of using foreach don't know put in it.

i though of putting as:

foreach($_post['id'] $add){ insert database... }

how do this?

if fred-ii , xjstratedgebx suggested change name="chkboxarray" name="chkboxarray[]" javascript code stop working. 

<?php include '../conec.php'; mysql_select_db("test",$conec)or die('database not exist.') or die(mysql_error());  $sql = mysql_query("select * user state='not signed up'"); ?>  <form name="checkform" id="checkform" method="post" action="checkboxes1.php">     <?php     while($row = mysql_fetch_array($sql)){         $id = $row['id'];         $name = $row['name'];         $lname= $row['lname'];         $concate = $name.' '.$lname;         echo '<input type="checkbox" name="chkboxarray" value="'.$id.'" />'.$concate.'<br />';     }       ?>     <!--<input type="checkbox" name="chkboxarray" value="1" /><br />     <input type="checkbox" name="chkboxarray" value="2" /><br />-->     <input type="button" name="checkall" value="check boxes" onclick="check_uncheck(true)" />     <input type="button" name="uncheckall" value="uncheck boxes" onclick="check_uncheck(false)" />     <input type="submit" value="save">  </form>  <script type="application/javascript"> function check_uncheck(truefalse){     var boxes = document.forms[0].chkboxarray.length;     var form = document.getelementbyid('checkform');     for(var i=0;i < boxes;i++){         if (truefalse) {             form.chkboxarray[i].checked=true;         } else {             form.chkboxarray[i].checked=false;         }     } } </script>

if change name of checkbox "chkboxarray" "chkboxarray[]", boxes checked when form submitted pass values array server under key of "chkboxarray".

basically, change line:

echo '<input type="checkbox" name="chkboxarray" value="'.$id.'" />'.$concate.'<br />';

to:

echo '<input type="checkbox" name="chkboxarray[]" value="'.$id.'" />'.$concate.'<br />';

as result, if var_dump $_post super global, should see like:

array(1) {     [chkboxarray]=>     array(2) {         [0]=>         string(1) "3"         [1]=>         string(1) "4"     } }

in example above, checkboxes id's 3 , 4 checked, sent server.

once have array, inserting database depends heavily on you're trying accomplish , database's schema.

hope helps.

also, in fairness, @fred meant in comment.

edit 1

to make javascript work change of input name, you'll need update places in javascript referencing name of input new name (chkboxarray[]).

the resulting code should this:

<script type="application/javascript">     function check_uncheck(truefalse) {         var boxes = document.forms[0]["chkboxarray[]"].length;         var form = document.getelementbyid('checkform');         (var = 0; < boxes; i++) {             if (truefalse) {                 form["chkboxarray[]"][i].checked = true;             } else {                 form["chkboxarray[]"][i].checked = false;             }         }     } </script>

i've created fiddle show works checking/unchecking boxes: https://jsfiddle.net/solvomedia/3ln468u3/


Comments

Post a Comment

Popular posts from this blog

c# - How Configure Devart dotConnect for SQLite Code First? -

-
can configure following sample code ? when run following code, error : no entity framework provider found ado.net provider invariant name 'devart.data.sqlite' setting in machine.config <system.data> <dbproviderfactories> <add name="dotconnect sqlite" invariant="devart.data.sqlite" description="devart dotconnect sqlite" type="devart.data.sqlite.sqliteproviderfactory, devart.data.sqlite, version=4.6.287.0, culture=neutral, publickeytoken=09af7300eec23701" /> </dbproviderfactories> </system.data> after add below block code in app.config <?xml version="1.0"?> <configuration>   <configsections> <!-- more information on entity framework configuration, visit http://go.microsoft.com/fwlink/?linkid=237468 --> <section name="entityframework" type="system.data.entity.internal.configfile.entityframeworksection, entit...
Read more

java - Copying object fields -

-
what best way of copying classes when need have 2 independent variables? have simple class: public class myclass { boolean = false; string b= "not empty"; } do need make method : assign(myclass data ) { a= data.a; b= data.b; } is there automatic method copy (duplicate) objects in java? do need make method : pretty close. instead of making method, should make constructor. such constructors called copy constructor , , create them this: myclass(myclass data) { = data.a; b = data.b; } and create copy of instance, use constructor this: myclass obj1 = new myclass(); myclass obj2 = new myclass(obj1); copy constructor can tedious : using copy constructor create deep-copy can tedious, when class has mutable fields. in case, assignment create copy of reference, , not object itself. have create copy of fields (if want deep copy). can go recursive. a better way create deep copy serialize , deserialize object. why not use clone()? ...
Read more

c++ - Clear the memory after returning a vector in a function -

-
i have function processes , stores lot of data in , returns results vector of class. amount of data stored in function tremendous , want clear storage memory of function after finished job. necessary (does function automatically clear memory) or should clear memory function? update: vector<customers> process(char* const *filename, vector<int> id) { vector<customers> list_of_customers; (perform actions) return list_of_customers; } variables defined locally within function automatically released @ end of function scope. destructors objects called, should free memory allocated objects (if objects coded correctly). example of such object std::vector . anything you've allocated new must have corresponding delete release storage. try avoid doing own allocation , use raii instead, i.e. containers or smart pointers.
Read more