paalg/csv

A little library handling CSV files

v0.1.0 2023-09-11 11:43 UTC

Requires

• php: ^7

Requires (Dev)

• phpunit/phpunit: ^9.6

apache-2.0

• Pål Gammelsæter

README

This library is for parsing an iterating through lines in a CSV file.

Versions

• v0.1 The first version published

Usage

// Load standard CSV file with headers and "," as field separator
$csv = new Csv('import.csv');
$data = $csv->getData();
print_r($data);
print_r($csv->getHeaders());

The output of above code can be like this:

Array
(
    [0] => Array
        (
            [Year] => 1997
            [Make] => Ford
            [Model] => E350
            [Description] => ac, abs, moon
            [Price] => 3000.00
        )

    [1] => Array
        (
            [Year] => 1999
            [Make] => Chevy
            [Model] => Venture "Extended Edition"
            [Description] => 
            [Price] => 4900.00
        )
)
Array
(
    [0] => Year
    [1] => Make
    [2] => Model
    [3] => Description
    [4] => Price
)

If you need to iterate the CSV file, you can do this:

$csv = new Csv('data.csv');
foreach ($csv as $row) {    
    print_r($row);
    foreach ($row as $fieldName => $value) {
        // do things with the fields in current row
    }
}

One iteration of above script will output something like this:

Array
(
    [Year] => 1999
    [Make] => Chevy
    [Model] => Venture "Extended Edition"
    [Description] =>
    [Price] => 4900.00
)

Unit testing

The library has been thoroughly tested with unit tests (phpunit). You can run the tests with command composer test.