Online PHP editor | refs for MDb8j

<?php $csv = <<< CSV "LOADERS", "S130", "Above & 524611001, 524711001 & Above", "MAINTENANCE ITEMS", "SCHEDULED MAINTENANCE ITEMS (500 HOUR)" "", "", "Above & 524611001, 524711001 & Above", "MAINTENANCE ITEMS", "SCHEDULED MAINTENANCE ITEMS (1000 HOUR)" "", "S140", "Above & 524611001, 524711001 & Above", "MAIN FRAME", "OPERATOR CAB" CSV; foreach(preg_split("/(\r?\n)/", $csv) as $line) { list($column1, $column2, $column3, $column4) = explode('", "', $line); //$column1 = preg_replace('/^"/', '', $column1); //$column4 = preg_replace('/\"(?<!\\")/', '', $column4); //foreach(explode(', ', $column3) as $column3_part) { // $temp_array[$column3_part][] = $column4; //} $big_array[$column1][$column2] = $temp_array; } echo '<pre>' . print_r($big_array, 1) . '</pre><hr />'; $counter = 50; foreach($big_array as $key1 => $level1) { foreach($level1 as $key2 => $level2) { foreach($level2 as $key3 => $level4) { foreach($level4 as $level5) { echo '<pre>' . print_r('INSERT INTO DATABASE: ' . $counter . ', ' . $key1 . ', ' . $key2 . ', ' . $key3 . ', ' . $level5, 1) . '</pre>'; $counter++; } } } }