gistfile1.txt

$shop_id = 246,

$sql = '';

if (($handle = fopen("DATEI.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        
        $sql = sprintf('insert into ratings (comment, shop_id, score, import_date, rating_date) 
        values("%s", "%s", "%s", "%s", "%s")',
        
        $data[4],
        $shop_id,
        $data[2],
        date('Y-m-d G:i:s')   # heutiges Datum (import_date)
        date('Y-m-d G:i:s', $data[1]), # datum in der .csv (rating_date)) . "\n\n"
        
    }
}
echo $sql;