Add multiple entries in another table from a module - template form?

Comments

• discofuel

  February 2014 edited 9:02PM

  oops wrong section...
• admin

  February 2014 edited 9:02PM

  So in this case, your album module's form_fields method would need to include the code to display the template field. The trickier part will be since you are not storing this in a single serialized field, you'll need to setup an on_after_save hook to store the track information for that album in the tracks table. Then in your form_fields method of your album model, you'll need to pull in the tracks for that album by loading the album and creating an array format that the template field will understand like so:
  function form_fields($values = array(), $related = array()) { ... $CI =& get_instance(); $CI->load->model('tracks_model'); $track_values = array(); if (!empty($values['id'])) { $track_values = $CI->tracks_model->find_all_array(array('album_id' => $values['id'])); // then set the 'value' => $track_values as a template field parameter } }
  See if something like that works...
• discofuel

  February 2014 edited 9:02PM

  Thank you very much. I have managed to display the track listing in the template form and I'm able to add new/delete tracks. I've implemented the on_after_save, however I'm not sure where to begin saving the update track information in the track table. Is there any tutorial or example code that might help?
  
  Thanks again
• discofuel

  February 2014 edited February 2014

  Ok I figured it out! Probably a better way but it works.
  
  function on_after_save($values) { parent::on_after_save($values); $new_tracklisting = $_POST['tracklisting']; //delete old tracks $this->db->where('album_id', $values['id']); $this->db->delete('tracks'); //add new tracks foreach($new_tracklisting as $track) { $track['album_id'] = $values['id']; $this->db->insert('tracks', $track); } }