· 7 years ago · Aug 15, 2018, 08:30 PM
1<?php
2
3use Doctrine\Common\Collections\Criteria;
4use League\Csv\Reader;
5use function Bakame\Csv\Extension\criteria_convert;
6
7$criteria = Criteria::create()
8 ->andWhere(Criteria::expr()->contains('email', '@gmail.com'))
9 ->setFirstResult(0)
10 ->setMaxResults(10);
11
12$csv = Reader::createFromPath('/path/to/my/file.csv');
13$csv->setHeaderOffset(0);
14$csv->setDelimiter(';');
15
16$stmt = criteria_convert($criteria);
17$resultset = $stmt->process($csv);