Code: Select all
while (($data = fgetcsv($handle, 1000, "\t")) !== FALSE)
{
//print_r($data);
$i = 0;
$values = array();
foreach($dbkey as $k) {
if (!empty($data[$i])) {
if($k!='patient_date'){
$values[$k] = $data[$i];
$i++;
}
else{
$str=$data[$i];
$values[$k]=DateTime::createFromFormat('d/m/y H:i', $str)->format('Y-m-d');
$i++;
}
}
else{
$values[$k]='';
$i++;
}
}
$ks = "`" . implode("`, `", array_keys($values)) . "`";
$values = "'" . implode("', '", $values) . "'";
$sql = "INSERT INTO ".WP_eemail_TABLE_SUB." ({$ks}) VALUES ({$values})";
$wpdb->get_results($sql);
}