What's Needed
All we need is PHP and MySQL.
Files We Will Make
- count.php
- image.php
We could do it with one file, but I think it's easier to understand with 2 different files. Plus, if you want to have different images, the count.php will log the stuff, and image.php will display the information.
The SQL Query
Creating the table. We are going to try to keep it as simple as posible.
-
CREATE TABLE counter(
-
logging VARCHAR(5) NOT NULL,
-
number INT(5) NOT NULL,
-
ipaddr TEXT NOT NULL,
-
daynum INT(2) NOT NULL,
-
PRIMARY KEY(logging)
-
);
This creates the table we will use. logging will store if it's storing information for today or total hits, and the ipaddr will store the IP of the visitors, number is the number of hits, and daynum is the number of the day.
Now we need to insert some more information in the database.
-
INSERT INTO counter (logging,number) VALUES ('today','0');
-
INSERT INTO counter (logging,number) VALUES ('total','0');
This just creates the 2 storage location in the table we will use.
Count.php
Now we need the file that will store the information. Hopefully you understand the internal documentation.
-
// Database Information, Host, User, Password, and Database
-
$DBHost = 'localhost';
-
$DBUser = 'user';
-
$DBPass = 'pass';
-
$DB = 'database';
-
-
// Now to connect
-
-
// Select today's information
-
-
// Get the total inforamtion
-
$total = $ti['number'];
-
-
// Check to see if it's storing todays information
-
if($i['daynum']==$date){
-
// Since it is, we get the current information
-
$today = $i['number'];
-
// Now to see if we need to increment the counter.
-
$today++;
-
$total++;
-
// Add the IP to the IP List
-
$nip = $i['ipaddr'].'|'.$_SERVER['REMOTE_ADDR'];
-
// Update the Table
-
$up = mysql_query("UPDATE counter SET number='".$today."', ipaddr='".$nip."' WHERE logging='today'");
-
}
-
}else{
-
// It's a new DAY!...?
-
// So update the list, how many hits today, and the total.
-
$nip = $_SERVER['REMOTE_ADDR'];
-
$today = 1;
-
$total++;
-
$up = mysql_query("UPDATE counter SET number='".$today."', ipaddr='".$nip."', daynum='".$date."' WHERE logging='today'");
-
}
-
-
// End the count.php
-
// Today and Total are set and done.
So now the $today and $total variables are set. We will need those when we include count.php in image.php
The Image
So, first off, we need to pick an image.
I chose 
not just because I didn't feel like making a new one for the tutorial, but becuase of it's coloration...?
So anyways, we open it up in our favorite image editor, I picked MS Paint...
Put the cursor where you want the text to be (the numbers or whatever). When I did it, the location was 30, 5. But then after coding it, you may have to change the number a bit. I finished with 30, 3.
Image.php
Image.php is rather easy to make. We have count.php and the numbers for positioning the text.
-
// Include count.php to log and set the variables
-
include("count.php");
-
// Set our header, mine was a png, so i set image/png
-
// jpeg/jpg - image/jpeg
-
// gif - image/gif
-
// Create our image from our image...
-
// change png to whatever the image type is.
-
$image = imagecreatefrompng("blue_orange.png");
-
// Pick a color, 225 is the red, 154 is green, and 10 is blue
-
$text = imagecolorallocate($image,255, 154, 10);
-
// Put a string, notice the 30, 3.
-
$write = imagestring($image, 1, 30,3, $today."/".$total,$text);
-
// Output the image, mine is png so yeah...
-
imagepng($image);
And we wind up with:
RSS