CSV Functions

csv_shared.php

<?php

function table(string $filename): array
{
	$fp = fopen($filename, 'r');

	if ($fp === false) {
		die('could not open file' . chr(10));
	}

	$headers = clean(fgetcsv($fp));

	$rows = [];

	while (($row = fgetcsv($fp)) !== FALSE) {
		$rows[] = array_combine($headers, clean($row));
	}

	fclose($fp);

	return $rows;
}

function clean(array $row): array
{
	foreach ($row as $idx => $column) {
		$row[$idx] = preg_replace('/[\x00-\x1F\x80-\xFF]/', '', $column);
	}

	return $row;
}

function find(array $table, string $columnName, string $value): array
{
	foreach ($table as $row) {
		if ($row[$columnName] == $value) {
			return $row;
		}
	}

	return [];
}