g105b/phpcsv

Wraps SplFileObject's CSV capabilities with a more human approach

v1.0.3 2016-06-03 22:14 UTC

Requires (Dev)

• phpunit/phpunit: 4.5.*

MIT

• database
• csv
• import
• filter
• export
• read
• write
• iterate

README

Wraps SplFileObject's CSV capabilities with a more human approach

Features at a glance

• Enhances PHP's SplFileObject, a memory-efficient file stream.
• Simple filtering of rows by field value (getAllBy("fieldName", "fieldValue")).
• Results are associative arrays, the indices are the CSV header names.
• Iterate over CSV files by row.
• Reference CSV rows by row number.
• Reference CSV rows by ID value.

Screenshot in action

Usage

Here are a few use cases to best show the functionality of the library. For a complete guide, visit the documentation.

Add rows

$csv = new Csv("/path/to/file.csv");
$csv->add([
    "firstName" => "Alan",
    "lastName" => "Statham",
    "Job Title" => "Consultant Radiologist",
]);
$csv->add([
    "firstName" => "Caroline",
    "lastName" => "Todd",
    "Job Title" => "Surgical Registrar",
]);

Get rows

$csv = new Csv("/path/to/file.csv");
$resultRows = $csv->getAllBy("gender", "F"); // array of all matching rows.
$firstRow = $csv->getBy("gender", "F"); // single row, first matching.

Iterate over rows

$csv = new Csv("/path/to/file.csv");

foreach ($csv as $rowNumber => $row) {
    // $row is an associative array with CSV headers as each key.
    // $rowNumber starts from 1 (ignoring header row).
}

Update row

$csv = new Csv("/path/to/file.csv");
$row = $csv->getBy("email", "[e-mail]");

// Update the matching row with provided fields, keeping any
// existing field data on the existing row.
$csv->update($row, [
    "dateOfBirth" => "1961-08-04",
]);

Delete row

$csv = new Csv("/path/to/file.csv");

// Delete a row by its index.
$csv->deleteRow(22);

Future feature ideas

• Requesting only certain fields in result (v2)
• Type handling (v3)
• Sorting (v4)
• Faster retrieval of indexed rows (v4)