Installation

Execute composer command., _(*1)

composer require dsa-io/csv-validator:1.*

'providers' => [
    ...Others...,
    Dsaio\CsvValidator\CsvValidatorServiceProvider::class,
]

Also alias, _(*3)

'aliases' => [
    ...Others...,  
    'CsvValidator' => Dsaio\CsvValidator\Facades\CsvValidator::class,
]

Basic usage

$csv_path = 'test.csv';
$rules = [
    0 => 'required',
    1 => 'required|integer',
    2 => 'required|min:4'
];
$csv_validator = CsvValidator::make($csv_path, $rules);

if($csv_validator->fails()) {
    $errors = $csv_validator->getErrors();
}

Rules

You can set keys instead of indexes like so., _(*4)

$rules = [
    'First Name' => 'required',
    'Last Name' => 'required',
    'Email' => 'required|email'
];

In this case, the heading row of the CSV need to have First Name, Last Name and Email.
And This keys will be used as attribute names for error message., _(*5)

See the details of the rules.

Trimming

You can set the 3rd argument a boolean value. If it is set to true, it will trim the cells of the csv. (Default: true), _(*6)

CsvValidator::make($csv_path, $rules, true, 'SJIS-win');

Encoding

You can set a specific encoding as the 4th argument. (Default: UTF-8), _(*7)

CsvValidator::make($csv_path, $rules, 'SJIS-win');

Error messages

You can get error messages after calling fails()., _(*8)

$errors = $csv_validator->getErrors();

foreach ($errors as $row_index => $error) {

    foreach ($error as $col_index => $messages) {

        echo 'Row '. $row_index .', Col '.$col_index .': '. implode(',', $messages) .'<br>';

    }

}