Welcome Guest, Not a member yet? Register   Sign In
Inserting multiple rows in to multiple columns
#4

[eluser]xeroblast[/eluser]
why not just do this in your model?
Code:
function insert_entry( $code, $title, $unit, $status, $level, $semester ) {
for ( $i=0; $i < count( $code ); $i++ ) {
  $data = array(
   'course_code' => $code[$i],
   'course_title' => $title[$i],
   'course_unit' => $unit[$i],
   'course_status' => $status[$i],
   'level' => $level[$i],
   'semester' => $semester[$i]
  );
  $this->db->insert( 'tbl_course', $data );
}
}

so that your controller is just sending your data to be inserted
Code:
$this->your_model->insert_entry( $this->input->post(‘course_code’), $this->input->post(‘course_title’), $this->input->post(‘course_unit’), $this->input->post(‘course_status’), $this->input->post(‘level’), $this->input->post(‘semester’) );


Messages In This Thread
Inserting multiple rows in to multiple columns - by El Forum - 07-05-2013, 10:39 PM
Inserting multiple rows in to multiple columns - by El Forum - 07-05-2013, 11:09 PM
Inserting multiple rows in to multiple columns - by El Forum - 07-05-2013, 11:29 PM
Inserting multiple rows in to multiple columns - by El Forum - 07-05-2013, 11:44 PM
Inserting multiple rows in to multiple columns - by El Forum - 07-06-2013, 03:53 AM
Inserting multiple rows in to multiple columns - by El Forum - 07-06-2013, 04:00 AM
Inserting multiple rows in to multiple columns - by El Forum - 07-10-2013, 09:23 AM



Theme © iAndrew 2016 - Forum software by © MyBB