I'd like to find a match of a string in a CSV file in PHP 5.
There is, for me, 2 ways to do it :
Which is the best way to do it ? There is a lot of line in my CSV file so I care about performance.
If you know some clues about it, I'll be glad to heard it :)
For large csv files, you should use fgetcsv (http://php.net/manual/en/function.fgetcsv.php).
$handle = fopen('filename.csv', 'r'))
if($handle)
{
while(($line = fgetcsv($handle)) !== false)
{
// do whatever with csv data
}
fclose($handle);
}
The fastest way would be to read the file as a string, and then find the first occurrence of the word, something like this:
$file = file_get_contents('file_name.csv');
if (strpos($file, 'your string') !== false) {
// Found it
}
// Use mb_strpos for UTF-8
if (mb_strpos($file, 'your string') !== false) {
// Found it
}
If it is something more complex then your best bet is to use regex and preg_match.
UPDATE:
You can also go with this approach and check line by line, this way you won't store the whole 300K line file in your memory:
$file = new SplFileObject('file_name.csv');
while($file->valid()) {
if (strpos($file->current(), 'your string') {
// Found it
break;
}
$file->next();
}
firstapproach is basicallysecondin a loop, it should be pretty clear what makes more sense in terms of performance and resource usage w/o need to ask here.fgetcsvreads single lines of data to begin with, so breaking out of the loop when you found what you need would be quite easy using that one.