This coding is an add-on which builds an image 'ctr2.jpg' for the counter of visits (CTR) if your are using in relation,
the statistic prog phpMyVisites
You have to implement a sub-directory /images, where would be stored the digit images of 0 to 9 naming them 1.jpg 2.jpg up to 9.jpg.
The previous number of visits is saved in a text file named : compteur.txt


here is the code to implement in a file named ctr.php for example :
<?php
$host="localhost"; //indicate here the host for example localhost or the IP of the server
$user="root"; //indicate here the MySQL user's name for example root, though to avoid: rather create a user for php
$base="mybase"; //indicate here the name of the Data Base
$passe="password";  //indicate here the password 
if (!($dblink=mySql_connect($host,$user,$passe)))
{
 //echo "<h2>the Connection failed !</h2>\n";
// die ("<br><h2>Shut Down!</h2>\n");
 exit();
}
 $namtbl="phpmv_visit"; // name of the table to scan
 $namfield="idvisit"; // name of the field in that table
 $select_base=mySql_selectdb($base,$dblink);  //select Data Base
 $query="SELECT * FROM ".$namtbl; //Save in $query the request SQL
 $dbresult=mysql_query($query,$dblink); //Execute the request
 if (!(mysql_query($query,$dblink)))
 { 
 //echo "<b>Sorry, the table ".$namtbl." is missing, </b>\n";
 exit();
 }
// find out the last record (idvisit)
$query="SELECT MAX(idvisit) FROM ".$namtbl; //Save the request of max(idvisit)
$result=mysql_query($query,$dblink); //Execute the request
if (!$result) {
//  echo 'enable to execute the request : ' . mysql_error();
 exit();
}
$row = mysql_fetch_row($result);
//echo $row[0]; // idvisit is the first field in that table
$visit = $row[0];
//echo "visit: ".$visit."</br>";
//Update Visits and Create an Image for the counter
$text="";
$fic="";
$Ndig=6; // number of digits to display
$bias=1234;  // original bias if the CTR does not start from zero
//
  $fp=fopen('compteur.txt','r'); //Open file compteur.txt for reading
  $oldvisit=fgets($fp,20); // take 20 first bytes
  fclose($fp); // close file
$dvisit = $visit - $oldvisit;
//echo "  DVisites : ".$dvisit."</br>";  
if ( $dvisit > 0) // test if one or more  visits
{   
  $fp=fopen('compteur.txt','w');  // Open file for writing
  fputs($fp,$visit); // save new value
  fclose($fp);  // close the file
// 
$myvisit = $bias + $visit;
$text = strval($myvisit);
//echo "  text : ".$text."</br>";
  // the text to draw
  $text=str_pad($text, $Ndig, "0", STR_PAD_LEFT);
  // Create the image
  $Dim = imagecreate(10*$Ndig, 12); // an image of (10xNdig x 12) pixels
  $nx=0;
while($nx<strlen($text))
{
    $digit=$text{$nx};
	$fic="images/".$digit.".jpg"; // build the image of the CTR
    $image = imagecreatefromjpeg($fic);
    imagecopy($Dim, $image, $nx*10, 0, 0, 0, 10, 12);
    $nx++;
}
$fh = fopen('ctr2.jpg','w'); // Open file for writing
 imagejpeg($Dim,'ctr2.jpg');//save CTR image into file 'ctr2.jpg'
 imagedestroy($Dim); // destroy the memory image of the CTR
} 
?>

in order to get the CTR, include the following lines in your web page:


<!-- Update the  visits CTR-->
<?php
include ("ctr.php");
?>

then display the CTR with <img src="ctr2.jpg" alt="ctr">
top
© JPSoft - 2007