Writing a stat .dat file

[benson]

Hello,
I want to write an number (count)
and an IP adres in a .dat file
everytime a page loads.

on a other page i want to show the list of ip adresses (not more than 20)
And the count.

Thanx Benson

[mwichmann4]

This board is for solving code problems not teaching you how to do somthing. Go search for help on the internet.

[DeadFly]

Do something like this : (I'm not going to write it all for you !😉 )

writing to file :
Put this before all html on your desired page

If ("file open success...") {
$IP=$HTTP_SERVER_VARS['REMOTE_ADDR']; /// Ip address
$IPNum="whatever criteria for counted number"; ///Counted number
$entry=$IPNum."|".$IP."\n"; /// Connect $IPNum and $IP using a | between them

fwrite("file details and $entry"); /// Write Data to file

fclose("opened file"); /// close opened file

}

That should give you a sense of direction . . .
Read a bit of the manual on reading/writing files, and loops for more depth and for doing the second part of your question.

[Mordecai]

Originally posted by mwichmann4
This board is for solving code problems not teaching you how to do somthing. Go search for help on the internet.

No, actually, it's for both.

Using DeadFly's code would be good, but it has a few errors. Namely, it doesn't ever open a file, nor refer to this non-opened file.
Here's an edited version that should do the trick:

$fp = fopen("stats.dat","a+b"); // a+b = open for reading and writing, place pointer at end of file
if (isset($fp)) {
  $ip=$HTTP_SERVER_VARS["REMOTE_ADDR"]; // Get their IP address using the HTTP server variables
  $ipnum="whatever criteria for counted number"; // The number after the IP... I'm not sure what goes in this.  Evidently, neither did DeadFly.  So, I'll just leave this.
  $entry=$ipnum."|".$ip."\n"; // Concatenate $ipnum and $ip with a pipe
  fwrite($fp,$entry); // Write the data to the file
  fclose($fp); // close the opened file
}

Hope this helps. It currently uses stats.dat.
If you need more help (with $ipnum or something), just say so.

[DeadFly]

Hehe. My code did not have errors.
I was merely trying to get him started in some direction.
Hence the pseudocode, and why I said he should read the manual on reading/writing files.
Errors . . . Bah !
😃

[Mordecai]

Okay, well you should've at least mentioned fopen. 😉
It's all correct functions, just not the right parameters.

Oh well, it's a start, I suppose. He should read up on File Systems, yes.

[DeadFly]

Might be a bit easier to look at using a database, if the .dat file is going to continue counting every visitor, multiple times. That could end up being one BIG file, if you have lots fo traffic.

Maybe doing a mysql table with fields like ID, IPAdd, VisitNum, Recent ?
It would cut down on the size, plus it still has the functionality of using the .dat file but with the possibility for some easier additions later (for example; visitors web browser).
Just a thought.

[DeadFly]

This is how I would go about doing what I think you are trying to do, using a mysql database.

Assuming that the table is already created, with the fields ID (int / auto-increment), IPAdd (text), VNum (int), and Recent (text).

<?php
##### MySQL Variables #####
$DB['name']="wwwwww";/// Database (replace wwwwww with database name)
$DB['host']="localhost";/// Host
$DB['user']="xxxxxx";/// Username  (replace xxxxxx with username)
$DB['password']="yyyyyy";/// Password (replace yyyyyy with password)
$DB['table']="zzzzzz";/// Table (replace zzzzzz with table name)
$DB['connect']=mysql_connect($DB['host'], $DB['user'], $DB['password']) or die ('I cannot connect to the database because: ' . mysql_error());/// Connect to database
$DB['select']=mysql_select_db ($DB['name']) or die (mysql_error());/// Selects the Database to use

##### Database Queries  #####
##### Put before HTML #####
$IP=$HTTP_SERVER_VARS["REMOTE_ADDR"];
$Query="SELECT * FROM ".$DB['table']." WHERE IPAdd='$IP' ";
$Result=@mysql_query($Query);

if ($Row =@mysql_fetch_assoc($Result)) {/// Go to record, if record exists
	/// Update the table with the new values of vnum +1 and recent = today	
	$visit=$Row['vnum'];/// Gets the number of visits to site	
	$today=date("F j, Y, g:i");// Date formatting (Month Day, Year, Hour:Minute)
    $QueryUpdate="UPDATE ".$DB['table']." SET vnum=". $visit+1 ." and recent=".$today." WHERE ipadd=".$IP."";
    if (!mysql_query($QueryUpdate)) {///Query the database
    	mysql_error();/// Prints error message if mysql_query($QueryUpdate) fails
    }

} else {
	/// Create a record with the necessary values
	$visit=1;///Since this is first visit, set visit number to 1	
	$today=date("F j, Y, g:i");/// Date formatting (Month Day, Year, Hour:Minute)

$QueryCreate="INSERT into ".$DB['table']." VALUES ('0', '".$IP."', '".$visit."', '".$today."')";
/// '0' will make the ID pick the next number in auto-index only if auto-increment has been set, else will error
if (!mysql_query($QueryCreate)) {///Query the database
	mysql_error();/// Prints error message if mysql_query($QueryCreate) fails
}

}
?>

[B]Main Webpage Contents[/B] 

<?
##### Disconnect from Database  #####
##### Put at end of all code #####
if ($DB['connect']) {
	mysql_close($DB['connect']);
}
?>

This should work as is, by just replacing the desired variables and whatnot. If it doesn't work, we can always tweak it.

Hope this helps !
🙂

[Mordecai]

You could always just parse the log file.
They get pretty big pretty fast, though. My page has been up for two days and has 516 lines.
The first section is the IP, just loop through each line and count the number of times the IP is repeated.

[benson]

At first thanx for all your reply's.

At the moment i have a super simple stat thingy.

<?php
//A simple counter using php
//open the counter file in read only mode
$counterfile = "mycount.dat";
if(!($fp = fopen($counterfile,"r"))) die ("cannot open counter file");
//Check the value stored in the file
$count = (int) fread($fp, 20);
//close the file
fclose($fp);
//increment the count 
$count++;
//display the count
echo "Welcome visitor no : $count";
//open the file again in write mode (w) and store
// the new count
$fp = fopen($counterfile, "w");
fwrite($fp , $count);
//close the file
fclose($fp);
?> 

But i stead of only increment the count i also want in the file a maximum of 20 IP numbers to be stored.
And the count and store part will come on my home (nothing showing) and the read the count and a list of 20 IP numbers will show at a counter page.

Does any bod know how to put the data in the file as wanted and show it as wanted ?? ?

again... lots of thanks for your previous help.

Benson

[benson]

No one with a good idea ??

Can't it be done with two files ?
one with the increment function and one with a log of 20 IP adresses ???

[benson]

I worked a part out for myself.
But one thing i don't get how can i make (in a .dat file)
A break like this:
Ip number
Ip number
Ip number
etc.

And than read it out of the file and place them under eachother