Can Anyone help me. I have problem insert into database when using convert date format. I am using codeigniter 4 and mysql database. below is my code:
foreach($worksheet_arr as $row){
// format date before convert = "1/15/2025"
$newDate = DateTime::createFromFormat("m/d/Y", $date);
$date = $newDate->format("Y-m-d");
$this->db->query("INSERT IGNORE INTO efakturheaderone (BRANCH, REFERENCE, DATE) VALUES (?, ?, ?)", [$row[0], $row[1], $date]);
}
but when I try dd($date); there is no problem.
Then when I code below, there is also no problem:
foreach($worksheet_arr as $row){
$this->db->query("INSERT IGNORE INTO efakturheaderone (BRANCH, REFERENCE) VALUES (?, ?)", [$row[0], $row[1]);
}