Search CVS file for string, can´t make it work

skuliaxe · July 31st, 2010, 04:46 PM

I have a CVS file and a user input field that I need to see if it exists in that CVS file.

Here is what I´m using, but I can´t get it to work:

Code:


			
$input = $_GET["input"];  



# Open the File.  

    if (($handle = fopen("http://www.skuli.us/cvs/demo.cvs", "r")) !== FALSE) {  

        # Set the parent multidimensional array key to 0.  

        $nn = 0;  

        while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {  

            # Count the total keys in the row.  

            $c = count($data);  

            # Populate the multidimensional array.  

            for ($x=0;$x<$c;$x++)  

            {  

                $csvarray[$nn][$x] = $data[$x];  

            }  

            $nn++;  

        }  

        # Close the File.  

        fclose($handle);  

    }  

      

    if (in_array($input, $csvarray)) { die('Found');  }  

    else { echo $input; die('Not found'); }

Even if I type in "1" as the input I get Not Found
I would like to find the exact match to the user input.

bigmax · August 3rd, 2010, 07:41 AM

Try

Code:

$file = file("yourcvs.cvs");
$num = 1;
foreach ($file as $line) {
$one_line = explode(",",$line);
if (in_array($your_input,$one_line)) {
echo "found $your_input in line number $num";
}
$num++;
}

skuliaxe · September 2nd, 2010, 08:57 AM

Quote:

Originally Posted by bigmax

Try

Code:

$file = file("yourcvs.cvs");
$num = 1;
foreach ($file as $line) {
$one_line = explode(",",$line);
if (in_array($your_input,$one_line)) {
echo "found $your_input in line number $num";
}
$num++;
}

I got some help with this from the devshed and here is what worked perfectly for me:

Code:


			
$found = false; 

if ($handle = fopen("http://www.domain.com/csv/demo.csv", "r")) { 

    while ($data = fgetcsv($handle, 1000, ",")) { 

        $csvarray[] = $data; 

        if ($data[0] == $_GET["input"]) { 

            $found = true;

            break; // Stop searching if match is found

        } 

    } 

    fclose($handle); 

} 



if (!$found) echo "NO";

Thank you for your contribution.