用PHP和MYSQL建立计数器过程详解
(wrriten by netying 2001-6-1) zrh#163.net http://www.filesee.com
运行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)
下面编写HTML文件内容:
<html> <body>
<?php $myvar = "来访人数:"; 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>
[MySql]PHP存取 Mysql 数据乱码终极解决方案 [MySql]解决Table xxx is marked as crashed and should … [MySql][MySQL]快速解决"is marked as crashed and shoul… [MySql]MySQL DELETE语法用法详解 [MySql]mysql中时间日期格式化 [MySql]修改mysql导入文件大小限制 [其他]MySql常用命令大全 [Web开发]把ACCESS的数据导入到Mysql中的方法详解 [MySql]解决mysql 1040错误Too many connections的方法 [系统软件]利用crontab系统每天定时备份MySQL数据库
|