Run MYSQL. EXE
Mysql> create database counter;
Query OK, 1 row affected (0.10 sec)
Mysql> use counter;
Database changed
Mysql> create table tl (id integer (2), count integer (5 ));
Query OK, 0 rows affected (0.21 sec)
Mysql> show columns from tl;
+ ------- + -------- + ------ + ----- + --------- + ------- +
| Field | Type | Null | Key | Default | Extra |
+ ------- + -------- + ------ + ----- + --------- + ------- +
| Id | int (2) | YES | NULL |
| Count | int (5) | YES | NULL |
+ ------- + -------- + ------ + ----- + --------- + ------- +
2 rows in set (0.05 sec)
Mysql> select * from tl;
Empty set (0.08 sec)
Mysql> insert into tl (id, count) values (1, 1 );
Query OK, 1 row affected (0.02 sec)
Mysql> select * from tl;
+ ------ + ------- +
| Id | count |
+ ------ + ------- +
| 1 | 1 |
+ ------ + ------- +
1 row in set (0.03 sec)
Write the following HTML file content:
<Html>
<Body>
<? Php
$ Myvar = "visitors :";
Echo $ myvar;
?>
<? Php
Mysql_connect () or die ("there are problems to connect to mysql! ");
$ Query = "select * from tl ";
$ Result = mysql_db_query ("counter", $ query );
If ($ result ){
$ R = mysql_fetch_array ($ result );
$ Counter = $ r ["count"];
$ Counter = $ counter + 1;
Echo $ counter;
$ Query = "update tl set count = '$ counter' where id = 1 ";
$ Result = mysql_db_query ("counter", $ query );
Mysql_close ();
}
?>
</Body>
</Html>