// get arrays of values for each input field
$doctornames = $this->input->post('doctorname');
$doctorfields = $this->input->post('doctorfield');
$dates1 = $this->input->post('date1');
$dates11 = $this->input->post('date11');
// array for rows to insert
$rows = array();
// iterate one of input arrays and fill next row
// with corresponding values from all other arrays
foreach($doctornames as $index => $doctorname){
$doctorfield = $doctorfields[$index];
$date = $dates1[$index] . '-' . $dates11[$index];
$rows[] = array(
'doctorname' => $doctorname,
'doctorfield' => $doctorfield,
'schedule' => $date
);
}
$this->load->model('emp_model');
$this->emp_model->insertMonday($rows);
id => auto increment;
doctorname => varchar
doctorfield => varchar
schedule => varchar
My Model:
function insertMonday($rows){
$this->db->insert('monday', $rows);
}
My controller:
function insertMonSched(){
// get arrays of values for each input field
$doctornames = $this->input->post('doctorname');
$doctorfields = $this->input->post('doctorfield');
$dates1 = $this->input->post('date1');
$dates11 = $this->input->post('date11');
// array for rows to insert
$rows = array();
// iterate one of input arrays and fill next row
// with corresponding values from all other arrays
foreach($doctornames as $index => $doctorname){
$doctorfield = $doctorfields[$index];
$date = $dates1[$index] . '-' . $dates11[$index];
$rows[] = array(
'doctorname' => $doctorname,
'doctorfield' => $doctorfield,
'schedule' => $date
);
}
$this->load->model('emp_model');
$this->emp_model->insertMonday($rows);