function import_csv($file_path) { $file_name = basename($file_path); // Enter main loop. if (!($fp = fopen($file_path, 'r'))) { die("Error: File cannot be opened.\n"); } $header = fgetcsv($fp, 4056); $rows = array(); if (($pos = array_search('id', $header)) !== false) { $header[$pos] = 'item_id'; } while ($row = fgetcsv($fp, 8112)) { $rows[] = array_combine($header, $row); } fclose($fp); $table_name = preg_replace('/[^a-zA-Z0-9_]+/', '', str_ireplace('.csv', '', $file_name)); if (preg_match('/(_[0-9]+_[0-9]+)$/', $table_name, $matches)) { $table_name = str_replace($matches[1], '', $table_name); } $profile = profile_resultset($rows); $table_sql = make_table_sql($table_name, $profile); kill_table($table_name); $res = mysql_query($table_sql); if (!$res) { throw new Exception("DB Error: " . mysql_error()); } bulk_insert($table_name, $rows); }
function read_csv($filename) { $f = fopen($filename, "r"); $row = 0; while (!feof($f)) { $fcontent = fgetcsv($f); if ($row == 0) { $row = 1; continue; } if (count($fcontent) == 3) { $query[] = "('" . implode("','", $fcontent) . "')"; } if (count($query) == 1000) { bulk_insert($query); $query = ''; } } return $query; }