\n";
+ echo implode(' | ',array_keys($in_fld));
+ echo " |
\n";
$first=false;
};
- $vals=str_replace("',","'",substr($vals,9,-1));
- echo " | ".str_replace("null,","null | ",$vals)." |
\n";
+ echo "";
+ echo implode(' | ',$vals);
+ echo " |
\n";
//echo "Import $j
\n";
flush();
- } else {
- $sql.=$keys."taxzone_id,import)";
- $sql.=$vals."0,$nun)";
- $rc=$db->query($sql);
- if (!$rc) echo "Fehler: ".$sql."
";
- }
- $j++;
} else {
- $vals=str_replace("',","'",substr($vals,9,-1));
- echo " | ".str_replace("null,","null | ",$vals)." |
\n";
- flush();
- }
+ $vals[] = $nun;
+ $sql = "INSERT INTO $file (".$infld.") values (".implode(",",$vals).")";
+ $rc=$db->query($sql);
+ if ($j % 10 == 0) { echo "."; flush(); };
+ if (!$rc) { echo "
Fehler: ".$sql."
"; flush(); };
+ }
+ $j++;
$zeile=fgetcsv($f,1200,$trenner);
}
fclose($f);
@@ -192,14 +279,31 @@ echo $j." $file importiert.\n";
- }; ?>
+