[RESOLVED] Display Count of Matched Fields from Textfile

[DaleRobbins]

I am pulling lines from a text file based on a search key. Below is a sample of the pipe delimited file... and the script I'm not using. I am wanting to display the total count of subscribers (in this case, 2) that I find based on the key. Have any idea how I would do that???? Thanks for your help!

text.txt
John|Doe|nonsubscriber
Betty|Dilly|subscriber
John|Smith|nonsubscriber
Ben|Wilson|subscriber

<?php

$key = "subscriber"

$data = file("text.txt");

foreach ($data as $line_num => $line)
{
  $fields = explode('|', $line);
  if (preg_match('/' . preg_quote($key,'/') . '/', $fields[2]))

echo "$fields[0] $fields[1] $fields[2]";

}
?>

[nevvermind]

Maybe this'll help.

// you can change this to "nonsubscriber" or to whatever value you have in your txt file
$key = 'subscriber';

$data = file_get_contents('text.txt'); 

preg_match_all('#\|' . $key . '#', $data, $matches);

echo count($matches[0]);

[bradgrafelman]

Any reason why you aren't using SQL for this?

[DaleRobbins]

Thank you for your help... but is there a way I can confine the match count to field 2 only? (Also, I also forgot to add the date stamp from field 3 of the text file.)

text.txt
John|Doe|nonsubscriber|08/13/10 10:30:26
Betty|Dilly|subscriber|08/15/10 08:22:16
John|Smith|nonsubscriber|08/17/10 11:27:06
Ben|Wilson|subscriber|08/19/10 06:01:26

[DaleRobbins]

Thanks... but there are other part to this script and I really don't know how to convert it over to mysql.

[nevvermind]

DaleRobbins;10961424 wrote:

but is there a way I can confine the match count to field 2 only?

I don't get it.

PS: The script still works with date stamp.

[DaleRobbins]

Hey, you're right, it's working well. Thanks so much! I appreciate you taking your time to help.