Using PHP to search CSV by Column?

Question

Having trouble searching CSV file by Column. For example, I have the following CSV file:

NAME, HAS AN IPHONE, HAS ANDROID

bob, yes, no,

fred, no, yes,

How could I search column 2 for a 'yes' value using php, then return only the rows with "yes" in second column results?

i dont knwo what you mean AbraCadaver ?? $file = fopen("example.csv","r"); $fileholder = fgetcsv($file); — Woolff, Aug 09 '15 at 16:30
You need to print out "yes" and "no" or count them? What's the purpose for it? — Mr.Web, Aug 09 '15 at 16:34
well for example i would just want to print all the users who have yes in there second column. Not displaying those with a no in the second column. — Woolff, Aug 09 '15 at 16:38

score 5 · Answer 1 · edited Nov 30 '21 at 16:40

5

I think, This can help you. Read about fgetcsv

 <?php

    $result  = [];
    if (($handle = fopen("test.csv", "r")) !== FALSE) {
        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
          if($data[1] == 'yes') //Checks second column is 'yes' 
              array_push($result, $data);
        }
        fclose($handle);

      var_dump($result);
    }
    ?>

edited Nov 30 '21 at 16:40

tirenweb

30,963
73
183
303

answered Aug 09 '15 at 17:02

Sanoob

2,466
4
30
38

2

It should be array_push($result, $data); – sanjeet bisht Mar 01 '21 at 08:56

score 3 · Answer 2 · answered Aug 09 '15 at 17:00

3

Have you tried anything if so please post that also, you may find this helpful

$csv = array_map('str_getcsv', file('data.csv'));

foreach($csv as $line){
    if($line[1] == 'yes'){
        //do what ever you want
        echo "found yes";
    }
}

answered Aug 09 '15 at 17:00

Ruwanka De Silva

3,555
6
35
51

thanks for the response, i don't want to search rows ( lines ) instead only columns though ? – Woolff Aug 09 '15 at 19:19
1

you may find this question useful http://stackoverflow.com/questions/15191682/how-to-read-specific-columns-of-a-csv-file-with-php – Ruwanka De Silva Aug 10 '15 at 02:41

score 3 · Accepted Answer · edited May 23 '17 at 12:14

3

Assuming you have already parsed the csv file into an array.
The second parameter of array_keys function is mixed $search_value

If specified, then only keys containing these values are returned.

To search a specific column, use array_column:

$res = array_keys(array_column($csv, 1), "yes");

See test at eval.in; This would return keys of of all "yes" matches in the second column.

edited May 23 '17 at 12:14

Community

1
1

answered Aug 09 '15 at 17:20

Jonny 5

12,171
2
25
42

nazmul mondal · Answer 4 · 2021-09-02T15:51:25.483

0

Well this is what i tried and it worked for searching for a value in rows. Then you can get the values of the rows and use it.

<?php

$file = fopen("test.csv", "r");
$str = "n@gmail.com";
while (($data = fgetcsv($file)) !== false)
{
    if(in_array($str, $data))
    {
        foreach ($data as $i)
        {
            echo $i."<br>";
        }   
    }
}
fclose($file);
?>

edited Sep 02 '21 at 15:51

answered Sep 02 '21 at 15:44

nazmul mondal

1
1

Using PHP to search CSV by Column?

4 Answers4

Linked