-3

I am write code in for loop , for multiple insert value using codeigniter framework .

this is my code

 $oldjoindate = $this->input->post('fldWorkHistoryJoiniedDate')  ;
$fldWorkHistoryJoiniedDate = date("Y-m-d", strtotime($oldjoindate));

for ($i=0; $i < count($fldWorkHistoryCompanyName); $i++) {
    $data5[] = array(

        'fldUserID' => $insert_id,
        'fldWorkHistoryCompanyName'=>$fldWorkHistoryCompanyName[$i],
        'fldWorkHistoryJoiniedDate'=>$fldWorkHistoryJoiniedDate[$i],
        //'fldWorkHistoryResignedDate'=>$fldWorkHistoryResignedDate[$i],
        'fldCompanyID' => $fldCompanyID

            );
  $this->db->insert_batch('tblWorkHistory',$data5);
}
JIJOMON K.A
  • 1,290
  • 3
  • 12
  • 29
it.supun
  • 21
  • 6

1 Answers1

-1

Can Yo please check $fldWorkHistoryJoiniedDate this an array format like $fldWorkHistoryJoiniedDate[0],$fldWorkHistoryJoiniedDate[1] ?

$oldjoindate = $this->input->post('fldWorkHistoryJoiniedDate');
// check db data type is Date ?
$fldWorkHistoryJoiniedDate = date("Y-m-d", strtotime($oldjoindate));
// check date is coming proper 
// echo $fldWorkHistoryJoiniedDate;
for ($i=0; $i < count($fldWorkHistoryCompanyName); $i++) {
    $data5[] = array(
        'fldUserID' => $insert_id,
        'fldWorkHistoryCompanyName'=>$fldWorkHistoryCompanyName[$i],
        'fldWorkHistoryJoiniedDate'=>$fldWorkHistoryJoiniedDate[$i],
        //'fldWorkHistoryResignedDate'=>$fldWorkHistoryResignedDate[$i],
        'fldCompanyID' => $fldCompanyID
    );
  $this->db->insert_batch('tblWorkHistory',$data5);
}

// may be thisis not required $fldWorkHistoryJoiniedDate[$i] simple coming $fldWorkHistoryJoiniedDate

Ravi Chauhan
  • 1,409
  • 13
  • 26
  • normally code is work in single inserting without using array .. but inserting using for loop in array not work code display this error strtotime() expects parameter 1 to be string my view code is there – it.supun Dec 27 '18 at 06:27