Convert CSV to SQL INSERT or UPDATE statements with PHP

<?php
// for mac os
ini_set("auto_detect_line_endings", true);

if (($handle = fopen("categories.csv", "r")) !== FALSE) {
    $data = fgetcsv($handle, 0, ";");
    while (($data = fgetcsv($handle, 0, ";")) !== FALSE) {
        for ($c=0; $c < count($data); $c++) {
            $data[$c] = trim($data[$c]);
            $data[$c] = str_replace("'", "\'", $data[$c]);
        }
        echo "INSERT INTO `categories` (`mappedId`, `name`, `path`, `isSub`, `provision`) VALUES ('{$data[0]}', '{$data[1]}', '{$data[2]}', {$data[3]}, {$data[4]});\n";
    }
    fclose($handle);
}
?>