Array search with CSV and php

Question

Hey all i am trying to search through a CSV file using the following code:

$fh = fopen($myFile, "r");
$os = array(fgetcsv($fh));

if (in_array("12.56.102.44", $os)) {
    echo "Got it!";
}

The CSV is in this format:

"132.89.14.110","41.98.365.111","12.56.102.44","77.295.10.111",

However, that does not work so i am sure i am using it incorrectly...

Any help would be great!

Is the CSV sheet setup so that there are numerous lines, one IP to each line; or one line of numerous columns, one IP in each column? — Patrick Moore
– Patrick Moore, Commented Jul 27, 2012 at 0:32

score 3 · Accepted Answer · 2012-07-27 00:39:27Z

3

fgetcsv() already returns an array. You should be calling the function like this:

$os = fgetcsv($fh);

Putting the return value inside an array will make the value of $os the following:

array(array("132.89.14.110","41.98.365.111","12.56.102.44","77.295.10.111"))

If there are multiple lines in your file that you need to check, you'll have to make use of a loop, for example:

$fh = fopen($myFile, "r");
while(($os = fgetcsv($fh)) !== false) {
    if (in_array("12.56.102.44", $os)) {
        echo "Got it!";
        break; // stop the loop, we're done
    }
}

edited Jul 27, 2012 at 0:39

answered Jul 27, 2012 at 0:34

user142162

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

2 Comments

Ben Over a year ago

+1. Also should be pointed that fgetcsv parses only 1 line of the csv file

StealthRT Over a year ago

So since fgetcsv returns an array then how do i go about looping that array and finding the ip? And by multiple lines do you mean "ip","ip",etc or a new line for each ip? Because running your code above provides no Got it! results.

Collectives™ on Stack Overflow

Array search with CSV and php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related