i have array checkbox
<?php     $query = $handler->query("select * colors");     while ($row = $query->fetch()) {?>  <input type="checkbox" name="check_list[]" id="<?php echo $row['id']?>" value="<?php echo $row['hex'];?>"> <?php } ?> php query
<?php     if(!empty($_post['check_list'])) {     foreach($_post['check_list'] $check) {     $query = $handler->query("insert images (color_tags) values ('$check')");         }     }         ?> i want insert data's array without inserting on every row want separated in commas data1,data2,data3 insert it.
store in json.
json_encode($array)  <?php if(!empty($_post['check_list'])) {  $query = $handler->query("insert images (color_tags) values ( json_encode($_post['check_list']))");  } ?> 
Comments
Post a Comment