用PHP和MYSQL建立计数器过程详解

更新时间:2023-04-07 04:17:25 阅读：评论：0

运行mysql.exe
mysql> create da家国情怀素材taba counter;
query ok, 1 row affected (0.10 c)

mysql> u counter;
databa changed

mysql> create table tl(id integer(2),count integer(5));
query ok, 0 rows affected (0.21 c)

mysql> show columns from tl;
+——-+——–+——+—–+———+——-+
| field | type | null | key | default | extra |
+——-+——–+——+—–+———+——-+
| id | int(2) | yes | | null | |
| count | int(5) | yes | | null | |
+——-+——–+——bec商务英语听力+—–+———+——-+
2 rows in t (0.05 c)

mysql> lect * from tl;
empty t (0.08 c)

mysql> inrt into tl(id,count) values(1,1);
query ok, 1 row affected (0.02 c)

mysql> lect * from tl;
+——+——-+
| id | count |
+——+——-+
| 1 | 1 |
+——+——-+
1 row in t (0.03 c)

下面编写html文件内容：

<?php
$myvar春雨诗歌 = “来访人数：”;
echo $myvar;
?&g巨枪乌贼t;

<?php
mysql_connect() or die(“there are problems to connect to mysql!”);
$query=”lect * 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 t count=’$counter’ where id=1″;
$result=mysql_db_query(“counter”,$query);
mysql_clo();有种爱叫放手
}
?>
</body>
</html>