Title: Insert multiple checkbox values
Last modified: August 30, 2016

---

# Insert multiple checkbox values

 *  [SombreroElGringo](https://wordpress.org/support/users/sombreroelgringo/)
 * (@sombreroelgringo)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/insert-multiple-checkbox-values/)
 * Hello,
 * I am trying to insert multiple checkbox values in my dataBase with the function
   insert() of WordPress, but it don’t work same when I use a SQL request. Although
   my table exist I really don’t see where is the problem…
 *     ```
       <form name="orderform" method="post" >
           <table id="Tableau" style="border-collapse: collapse;" id="tableauS" border="1"><tr><th>Attributs</th><th>Choix</th></tr></html>
           <?php
   
           $resultat= $wpdb->get_results("SELECT * from wp_frm_fields ",ARRAY_N); // lancement de la requete
   
           foreach ($resultat as $post) {
               echo '<tr><td>'.$post[2].'</td>';
               echo"<td><center><input type='checkbox' name='choixP' value='".$post[0]."'></center></td>";
           }
           ?>
           <html></tr>
   
              <input type="submit" name="sub" value="submit">
   
           </table></form>
           <?php
   
           if(isset($_POST['sub']))
           {
           global wpdb;
           $checkbox1=$_POST['choixP'];
           $chk="";
           foreach($checkbox1 as $chk1)
              {
                 $chk = $chk1;  
   
                $wpdb->insert( 'wp_choix_attributs_liste',
                array('att_id'=>$chk),
                array(%s) );
   
              -------- Dont Work too-----------
                 $query = "INSERT INTO wp_choix_attributs_liste (att_id)  VALUES ('".$chk."')";
                 mysql_query($query) or die(mysql_error());
              ---------------------------------
   
              }
           }
       ```
   

The topic ‘Insert multiple checkbox values’ is closed to new replies.

## Tags

 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 0 replies
 * 1 participant
 * Last reply from: [SombreroElGringo](https://wordpress.org/support/users/sombreroelgringo/)
 * Last activity: [10 years, 5 months ago](https://wordpress.org/support/topic/insert-multiple-checkbox-values/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics
