Import CSV file in a SQLite table, including column headers

csv2sqlite.php

<?php

$fp = fopen($argv[1], 'r');
$db = new SQLite3($argv[1] . '.sqlite');

$db->exec('BEGIN;');

$header = null;

$i = 0;

while (!feof($fp))
{
	$line = fgetcsv($fp, 4096);

	if (!$line)
	{
		continue;
	}

	if (!$header)
	{
		$header = $line;
		$db->exec(sprintf('CREATE TABLE data (%s);', aggregate($header)));
		continue;
	}

	$db->exec(sprintf('INSERT INTO data (%s) VALUES (%s);', aggregate($header), aggregate($line)));
	echo $i++ . " lines\r";
}

echo "\nCommiting...";

$db->exec('COMMIT;');

echo " Done.\n";

fclose($fp);

function aggregate(Array $fields)
{
	return implode(', ', array_map('escape', $fields));
}

function escape($str)
{
	global $db;

	return sprintf('\'%s\'', $db->escapeString($str));
}