How to count lines in a file that meet criteria?

[deko]

Below are the contents file that has the IP address and time of visit of
visitors to a website.

68.122.69.241|1 089822686

68.122.69.241|1 089823630

68.122.69.241|1 089823638

68.122.69.241|1 089828547

The second column is the output of time()

I need a script to count each line in this file where the time stamp is
greater than time() - 3600*24. This will give number of visitors in the
last 24 hours. I also need number of visitors in the last 30 days, and
year. Should I use an array? Suggestions for getting started?

Thanks in advance.

[Garp]

"deko" <no****@hotmail .com> wrote in message
news:TD******** ***********@new ssvr29.news.pro digy.com...

Below are the contents file that has the IP address and time of visit of
visitors to a website.

68.122.69.241|1 089822686

68.122.69.241|1 089823630

68.122.69.241|1 089823638

68.122.69.241|1 089828547

The second column is the output of time()

I need a script to count each line in this file where the time stamp is
greater than time() - 3600*24. This will give number of visitors in the
last 24 hours. I also need number of visitors in the last 30 days, and
year. Should I use an array? Suggestions for getting started?

Thanks in advance.

$f=file("filena me.txt");
foreach($f as $line) {
$parts=explode( "|",$line);
if($parts[1] > time()-(3600*24)) { ++$visitors; }
}

Just a suggestion, see how far you get (untested, no warranty, etc).

Garp

[Tim Van Wassenhove]

In article <TD************ *******@newssvr 29.news.prodigy .com>, deko wrote:

Below are the contents file that has the IP address and time of visit of
visitors to a website.

68.122.69.241|1 089822686

68.122.69.241|1 089823630

68.122.69.241|1 089823638

68.122.69.241|1 089828547

The second column is the output of time()

I need a script to count each line in this file where the time stamp is
greater than time() - 3600*24. This will give number of visitors in the
last 24 hours. I also need number of visitors in the last 30 days, and
year. Should I use an array? Suggestions for getting started?

1) determine $time;
2) $count = 0;
3) open file;
4) read file line by line
split/explode line based on | into $ip and $time2
if $time2 > $time -> count = count + 1;
5) close file;
6) return count;

The sections on strings and file handling in the manual
at http://www.php.net/manual will be more than enough

--
Tim Van Wassenhove <http://home.mysth.be/~timvw>

[deko]

> $f=file("filena me.txt");

foreach($f as $line) {
$parts=explode( "|",$line);
if($parts[1] > time()-(3600*24)) { ++$visitors; }
}

$f = file($visdata);
foreach($f as $line)
{
$p = explode("|",$li ne);
if($p[1]>time()-(3600*24))
{
++$f24h;
}
}
echo "<br>f24=".$f24 h

this returns a blank for f24 - is there anyway to walk thrugh this to
troubleshoot? How can I be sure I even have an array?

[deko]

> 1) determine $time;

2) $count = 0;
3) open file;
4) read file line by line
split/explode line based on | into $ip and $time2
if $time2 > $time -> count = count + 1;
5) close file;
6) return count;
I think I'm having trouble with #4

// $visdata = 'visdata.txt' 68.122.69.241|1 089822686
68.122.69.241|1 089823630
68.122.69.241|1 089823638
68.122.69.241|1 089828547

$av = file($visdata);
$v24h = 0;
foreach($av as $line)
{
$pv = explode("|",$li ne);
if($pv[1]<time()-(3600*24))
{
++$v24h;
}
}
echo "<br>v24h=".$v2 4h;

This is not working... is this the best way to parse the array line by line?

[deko]

> 1) determine $time;

2) $count = 0;
3) open file;
4) read file line by line
split/explode line based on | into $ip and $time2
if $time2 > $time -> count = count + 1;
5) close file;
6) return count;

Okay. I got this working:

$av = file($visdata);
$v24h = 0;
foreach($av as $line)
{
$pv = explode("|",$li ne);
//if($pv[5]>time())-(3600*24))
// {
++$v24h;
// }
}
echo "<br>v24h=".$v2 4h; //returns number of lines in the file.

Now if I can just find the best way to inspect the timestamp ... perhaps I
need to use something like:

if number_format($ pv[5])>(time()-(3600*24)) ??

[Chung Leong]

"deko" <no****@hotmail .com> wrote in message
news:ud******** ***********@new ssvr29.news.pro digy.com...

$f=file("filena me.txt");
foreach($f as $line) {
$parts=explode( "|",$line);
if($parts[1] > time()-(3600*24)) { ++$visitors; }
}

$f = file($visdata);
foreach($f as $line)
{
$p = explode("|",$li ne);
if($p[1]>time()-(3600*24))
{
++$f24h;
}
}
echo "<br>f24=".$f24 h

this returns a blank for f24 - is there anyway to walk thrugh this to
troubleshoot? How can I be sure I even have an array?

You didn't set $f24h to zero prior to incrementing it, and ++ does not cast
a null or a boolean into an int. Thus $f24h remains null :-)

[Michael Austin]

deko wrote:

1) determine $time;
2) $count = 0;
3) open file;
4) read file line by line
split/explode line based on | into $ip and $time2
if $time2 > $time -> count = count + 1;
5) close file;
6) return count;

Okay. I got this working:

$av = file($visdata);
$v24h = 0;
foreach($av as $line)
{
$pv = explode("|",$li ne);
//if($pv[5]>time())-(3600*24))
// {
++$v24h;
// }
}
echo "<br>v24h=".$v2 4h; //returns number of lines in the file.

Now if I can just find the best way to inspect the timestamp ... perhaps I
need to use something like:

if number_format($ pv[5])>(time()-(3600*24)) ??

you put it an array of arrays so:

$av = file($visdata);
$v24h = 0;
foreach($av as $line)
{
$pv = explode("|",$li ne); // put each line into an array
foreach ($pv as $key[5]=>$value){ // or whatever the key is....
if($value > time()-(3600*24)) // now check the time
{
++$v24h;
}
}
}
echo "<br>v24h=".$v2 4h; //returns number of lines in the file.

--
Michael Austin.
Consultant - Available.
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)

[Michael Austin]

Chung Leong wrote:

"deko" <no****@hotmail .com> wrote in message
news:ud******** ***********@new ssvr29.news.pro digy.com...

$f=file("fil ename.txt");
foreach($f as $line) {
$parts=explode( "|",$line);
if($parts[1] > time()-(3600*24)) { ++$visitors; }
}

$f = file($visdata);
foreach($f as $line)
{
$p = explode("|",$li ne);
if($p[1]>time()-(3600*24))
{
++$f24h;
}
}
echo "<br>f24=".$f24 h

this returns a blank for f24 - is there anyway to walk thrugh this to
troubleshoo t? How can I be sure I even have an array?

You didn't set $f24h to zero prior to incrementing it, and ++ does not cast
a null or a boolean into an int. Thus $f24h remains null :-)

he had a problem with how he was trying to handle his arrays...

$i = 0;
for ($i=0;$i<10;$i+ +)
{ $x++;
++$y;
}
echo $x ."\n";
echo $y ."\n";

the variables do not "pre-exist" and are incremented correctly.

--
Michael Austin.
Consultant - Available.
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)

[deko]

> he had a problem with how he was trying to handle his arrays...

$i = 0;
for ($i=0;$i<10;$i+ +)
{ $x++;
++$y;
}
echo $x ."\n";
echo $y ."\n";

the variables do not "pre-exist" and are incremented correctly.

--
Michael Austin.
Consultant - Available.
Donations welcomed. Http://www.firstdbasource.com/donations.html
:)

Thanks, Mike. I just re-posted the question in a more clear way. I changed
the way I created the file, which should help.