[Resolved] Need assistance with Searching a txt file

[TheDefender]

OK, I have been racking my brains for a day now, and am succumbing to stupidity...

I have a text file that I want to search for a specific word, and I am not getting it....

Samle Text File

John 100 200 300 400
Dave 200 300 400 100
Mike 599 399 399 299
Jimmy 500 300 400 400

What I want to do is search the file for the name "Dave" and extract the data just from the line with Dave. I am going to load the values into an array and manipulate that within PHP. Now, the trick is, I have an array...

array("Dave", "Sarah", "Sam", "Jimmy");

I want to cycle through the array, and pull all of the lines that match my values in the array, so with the above array, I would get the lines:

Dave 200 300 400 100
Jimmy 500 300 400 400

I have tried using:

$cid = explode(",", $names);
$countnames = count($cid);
$lines = file("./swr/".$sid.".txt");
FOREACH ($lines as $line_num => $line): 
// This is the part I am stuck with.  I don't know how to search each line to match the $cid[] array.  I have tried using a FOR loop, but that hasn't worked.
ENFOREACH;

Any help would be appreciated. If you need more info, just ask.

Thanks in advance,
TheDefender

[LordShryku]

Give this a shot. Provided, you don't need it to be case insensitive, should work...

$array = array("Dave", "Sarah", "Sam", "Jimmy"); 
$read  = file("/path/to/file");
$lines = array(); // blank array to store results
foreach($array as $name) {
   foreach($read as $line) {
      if(strpos($line, $name) !== false) {
         $lines[] = $line;
      }
   }
}

[TheDefender]

Thanks a million LordShryku... I was close a few times, but missed it every time... The names are case sensitive in that they all need to be all CAPPED (sorry I failed to mention it in my first post).

I tried:

$array = array("Dave", "Sarah", "Sam", "Jimmy");  

$read  = file("/path/to/file"); 
$lines = array(); // blank array to store results 
foreach($array as $name) { 
   foreach($read as $line) { 
      if(strpos($line, strtoupper($name)) !== false) { 
         $lines[] = $line; 
      } 
   } 
}

but my output is Array(), so that tells me it's empty. If I change the array so everything is capped, it works fine though. This is going to to be something where the array is user defined through form inputs, so I guess I will have to cap the values before I create the array... Either way, what you gave me works a bunch. Thanks again!

[drawmack]

Not the most efficient code I've ever written but it does work:

<?php
function find_in_file($find,$filename = "../../data_files/names.txt") {
    if(!file_exists($filename)) {die("Specified file (" . $filename . ") does not exist.");}
    elseif (!is_readable($filename)) {die("Specified file (" . $filename . ") is not readable.");}

if(!is_array($find)) {$find = array($find);}

$contents = file($filename);
$names = array();
foreach($contents as $line) {
     $line = trim($line);
     echo $line . "<br />";
     $temp = explode(" ",$line);
     $names[$temp[0]] = array_slice($temp,1);
} //end foreach

$retval = array(); 

foreach($find as $cur_key) {
    if(array_key_exists($cur_key,$names)) {
        $retval[$cur_key] = $names[$cur_key];
    } else {
        $retval[$cur_key] = 'not found';
    } //end if
} //end foreach

return $retval;
} //end find_in_file
?>

[TheDefender]

Thanks Drawmack, I think the route you were going here was the same route I tried (unsuccessfully of course), and I appreciate your input. At any rate, LordShryku's solution worked perfectly for me... so I am not even going to try to make yours a go 😉 because it works now, and works very quickly. I appreciate your help guys... You all rule!

[drawmack]

Yeah Lord posted his while I was writting/testing mine. Lord's is a simpler and faster solution anyway.

[TheDefender]

Yeah, that's what I figured drawmack. I do appreciate what you posted as well, because if LordShryku's solution hadn't worked, I surely would have been looking into yours 😉