title: how to insert multiple checkbox values as successive rows in mysql codeigniter
body: <p><em>employer_rgn.php</em></p>
  
  <pre><code>&lt;div class="form-group"&gt;
    &lt;label for="" class="control-label col-xs-2"&gt;
      &lt;?php echo $this-&gt;lang-&gt;line('spclzd_ctgry'); ?&gt;
    &lt;/label&gt;
    &lt;div class=" col-md-8"&gt;            
      &lt;input type="checkbox" name="spec_cat[]" value="Information Technology"&gt; Information Technology 
      &lt;input type="checkbox" name="spec_cat[]" value="Engineering / Manufacturing"&gt;Engineering / Manufacturing &lt;br /&gt;
      &lt;input type="checkbox" name="spec_cat[]" value="Banking &amp; Financial Services"&gt; Banking &amp; Financial Services  
      &lt;input type="checkbox" name="spec_cat[]" value="BPO / ITES"&gt; BPO / ITES &lt;br /&gt;
      &lt;input type="checkbox" name="spec_cat[]" value="FMCG / Retail"&gt; FMCG / Retail  
      &lt;input type="checkbox" name="spec_cat[]" value="Telecom / ISP"&gt; Telecom / ISP &lt;br /&gt;
      &lt;input type="checkbox" name="spec_cat[]" value="Pharmaceuticals / Health Care"&gt; Pharmaceuticals / Health Care  
      &lt;input type="checkbox" name="spec_cat[]" value="Sales &amp; Marketing"&gt; Sales &amp; Marketing &lt;br /&gt;
      &lt;input type="checkbox" name="spec_cat[]" value="Other Non IT"&gt; Other Non IT
    &lt;/div&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p><em>employer_model</em></p>
  
  <pre><code>public function insert()
  {
    //Insert second stage details for employer into database.
    $Specilized_category = $this-&gt;input-&gt;post('spec_cat');
    $data=array('Specilized_category'=&gt;implode(",", $Specilized_category),);
    $this-&gt;db-&gt;insert('tbl_employer', $data);
  </code></pre>
  
  <p>I'm inserting check box values into database separated by commas. But the problem is, I need to get back the checked values from database in order to edit my code. How could I get those values as I had used the implode method? Or do I have to change my code for inserting values into database?</p>