kzykhys/php-csv-parser

Convert CSV to array (Excel style is fully suppoted!)

1.4.1 2014-01-15 05:17 UTC

This package is not auto-updated.

Last update: 2024-10-26 13:14:12 UTC


README

Convert CSV to array/Iterator (Excel style is fully suppoted!)

Latest Stable Version Build Status Coverage Status SensioLabsInsight

Why PHPCsvParser?

As you know, PHP has built-in fgetcsv function. But has some probrems:

  • Line breaks in the cell
  • Multibyte string (especially NON UTF-8)
  • Double quote in the cell

Requirements

PHP5.3.3 or later

Installation

Create or modify your composer.json

{
    "require": {
        "kzykhys/php-csv-parser": ">1.4"
    }
}

And run

$ php composer.phar install

Usage

Parse a CSV file

1,"some text",150
2,"some multi line
text",2000
<?php

require('./vendor/autoload.php');

$parser = \KzykHys\CsvParser\CsvParser::fromFile('./test.csv');
$result = $parser->parse();

var_dump($result);

This is the same as:

<?php

require('./vendor/autoload.php');

$iterator = new \SplFileObject('./test.csv');
$parser = new \KzykHys\CsvParser\CsvParser($iterator);
$result = $parser->parse();

var_dump($result);

Parse from string

<?php

require('./vendor/autoload.php');

$parser = \KzykHys\CsvParser\CsvParser::fromString($string);
$result = $parser->parse();

var_dump($result);

Parse from array/Iterator

<?php

require('./vendor/autoload.php');

$parser = \KzykHys\CsvParser\CsvParser::fromArray(array('a,b,c,d', 'e,f,g,h'));
$result = $parser->parse();

$iterator = new ArrayIterator(array('a,b,c,d', 'e,f,g,h'));
$parser2 = new \KzykHys\CsvParser\CsvParser($iterator);
$result2 = $parser2->parse();

var_dump($result);
var_dump($result2);

Handling Large files

The class \KzykHys\CsvParser\CsvParser itself is Traversable. so You can convert CSV lines on-the-fly.

Following example is the best choice for performance:

<?php

require('./vendor/autoload.php');

$parser = \KzykHys\CsvParser\CsvParser::fromFile('./test.csv');

foreach ($parser as $record) {
    // handles each record
    var_dump($record);
}

Options

You can pass the options to 2nd argument of each static methods.

  • CsvParser::fromFile($file, $options);
  • CsvParser::fromString($string, $options);
  • CsvParser::fromArray($array, $options);
  • new CsvParser($iterator, $options);

Available options are:

Testing

Just run phpunit (PHPUnit is required)

Author

Kazuyuki Hayashi (@kzykhys)

Changelog

see CHANGELOG

License

The MIT License