Design and implementation of php counter page 2/2

//------[Basic Settings]--------
$mysql_server_name = "localhost";
$mysql_username    = "root";
$mysql_password    = "512783";
$mysql_database    = "jishuqi";
//-------

//Create a connection--------pass (server address, user name, user password)
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password );

//Prepare your SQL syntax
$sql = "SELECT COUNT(*) FROM `counter_1`WHERE user= '$user' AND TIME_TO_SEC(NOW()-`time`) < 3 AND ip='$REMOTE_ADDR'";

//Check (or execution, select)
$result=mysql_db_query( $mysql_database, $sql,$conn );

//Cap a result after query -->
$row=mysql_fetch_row($result);

// Print out all columns of this document [array]
//print_r($row);

//Clear the query results
   mysql_free_result($result);

   if($row[0]==0)
   {

//--Basic Settings

//Prepare your sql
$sql = "INSERT INTO `counter_1` ( `user` , `ip` , `time` ) VALUES ('$user', '$REMOTE_ADDR', NOW( ) );";

$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password);
mysql_select_db($mysql_database,$conn);
$result = mysql_query($sql);
$id = mysql_insert_id();
mysql_close($conn);

}

//Create a connection--------pass (server address, user name, user password)
$conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password );

//Prepare your SQL syntax
$sql = "SELECT COUNT(*) FROM `counter_1` WHERE user='$user'";

//Check (or execution, select)
$result=mysql_db_query( $mysql_database, $sql,$conn );

//Cap a result after query -->
$row=mysql_fetch_row($result);

//Print out the array of all columns of this document
//print_r($row);

//Clear the query results
mysql_free_result($result);

   for ( $i=0; $i< strlen($row[0]);$i++)
    {
   $digit= substr($row[0],$i,1);

   $pic.="<img src=\"timex/$\" width=\"15\" height=\"20\">";
   }
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http:///TR/html4/">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>3 types of counters</title>
<style type="text/css">

</style>
</head>

<body>
<div align="center" class="style1 style6">Under the maple forest
</div>
<div align="center">
<p class="style1"> </p>
<p class="style1"> </p>
<p class="style1"><span class="style3">A total of </span><?=$row[0]; ?><span class="style5">people have been to this website
</span></p>
<p class="style1"><span class="style3">A total of </span><?=$row[0]; ?><span class="style5">people</span><span class="style4"> have been to</span><span class="style2"><?=$user?>website</span></p>
<p class="style1"><?=$pic?></p>
</div>
</body>
</html>

Previous page12Read the full text