back to notes

Import CSV data

function parseCsvFile($file, $columnheadings = false, $delimiter = ',', $enclosure = "\""){
$row = 1;
$rows = array();
$handle = fopen($file, 'r');

while (($data = fgetcsv($handle, 1000, $delimiter, $enclosure)) !== FALSE) {

if (!($columnheadings == false) && ($row == 1)) {
$headingTexts = $data;
} elseif (!($columnheadings == false)) {
foreach ($data as $key => $value) {
unset($data[$key]);
$data[$headingTexts[$key]] = $value;
}
$rows[] = $data;
} else {
$rows[] = $data;
}
$row++;
}

fclose($handle);
return $rows;
}

$array = parseCsvFile('zipcodes.csv', false);

foreach ($array as $key => $value) {
$zipcode = new Zipcode();
$zipcode->fromArray($value);
$zipcode->save();
}