Scan a csv file for certain value with php

Question

I'm just wondering is it possible to have a csv file (with many values) and scan the file for a specific value with php?

Ideally if this is possible, Id also like to get the index of that value in the file (i.e what row number the value falls on).

I'm quiet new to php so I'm not sure where to start. All help is greatly appreciated.

Yes it's possible. What have you tried?

Quotidian
– Quotidian

2016-03-23 14:14:24 +00:00
Commented Mar 23, 2016 at 14:14 — Quotidian
– Quotidian, Commented Mar 23, 2016 at 14:14
Did you look at php.net/manual/en/function.fgetcsv.php

Martin Brown
– Martin Brown

2016-03-23 14:20:24 +00:00
Commented Mar 23, 2016 at 14:20 — Martin Brown
– Martin Brown, Commented Mar 23, 2016 at 14:20

Mark van Herpen · Accepted Answer · 2016-03-23 14:23:50Z

1

Sure,

Not tested:

<?php
$search = 'mysearchstring';
$row = 1;
if (($handle = fopen("test.csv", "r")) !== FALSE) 
{
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) 
    {
        $num = count($data);
        $row++;
        for ($c=0; $c < $num; $c++) 
        {
            if ($data[$c] == $search)
            {
               echo "Found in row $row in column {$c+1} <br />\n";
            }
        }
    }
    fclose($handle);
}
?>

answered Mar 23, 2016 at 14:23

Mark van Herpen

3453 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user Over a year ago

Thanks a million! @Mark van Herpen, would it work the same if I was to search the file by row number?

Mark van Herpen Over a year ago

Sure, just check $row for it's value, so if ($row == 5) or something

user Over a year ago

If I was to search another file for the row number that Ive just gotten, how would I even get the value of that row though? I appreciate your help !! :) @Mark van Herpen

Mark van Herpen Over a year ago

OK, I guess that's outside the scope of this question.. You should store the value in a variable, open the second file and go through it the same way until the rownumber of this second file is the same as the first one.

user Over a year ago

Thanks a mill! you've been a great help!

Collectives™ on Stack Overflow

Scan a csv file for certain value with php

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related