基于HTML实现论坛社区网站_南部湾论坛(B) v1.6.4_numb1bbsb(HTML源码+数据集+项目使用说明).rar

表格结构 mysql> describe board; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | btable | varchar(20) | | | btable1 | | | name | varchar(30) | | | | | | logo | varchar(100) | YES | | NULL | | | inform | varchar(160) | YES | | NULL | | | focus | varchar(200) | YES | | NULL | | | boardmast | varchar(255) | | | | | | page | varchar(80) | | | | | +-----------+--------------+------+-----+---------+----------------+ mysql> describe btable1; +----------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | boardid | int(40) | NO | | 0 | | | title | varchar(50) | NO | | | | | clas | varchar(2) | NO | | a | | | txt | text | NO | | | | | up | char(2) | NO | | n | | | super | char(2) | NO | | n | | | recommendation | char(2) | NO | | n | | | locked | char(2) | YES | | n | | | userid | varchar(20) | YES | | NULL | | | usname | varchar(20) | NO | | | | | lastid | varchar(20) | YES | | NULL | | | lastname | varchar(20) | YES | | NULL | | | tim | datetime | NO | | 0000-00-00 00:00:00 | | | editime | datetime | NO | | 0000-00-00 00:00:00 | | | ip | varchar(15) | YES | | NULL | | | readtimes | int(11) | YES | | 0 | | | retimes | int(11) | NO | | 0 | | | lastretime | datetime | NO | | 0000-00-00 00:00:00 | | | penname | varchar(250) | YES | | NULL | | +----------------+--------------+------+-----+---------------------+----------------+ 20 rows in set (0.00 sec) mysql> describe friend; +------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | userid | varchar(20) | NO | | | | | username | varchar(20) | NO | | | | | friendid | varchar(20) | NO | | | | | friendname | varchar(20) | NO | | | | | isfriend | char(2) | NO | | y | | +------------+-------------+------+-----+---------+----------------+ mysql> describe gclothes; +--------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | gname | varchar(30) | | | | | | cgname | varchar(30) | | | | | | gimg | varchar(100) | | | | | | userid | varchar(20) | | | | | | fuid | varchar(20) | | | | | | fname | varchar(20) | | | | | | text | varchar(250) | | | | | | time | datetime | | | 0000-00-00 00:00:00 | | +--------+--------------+------+-----+---------------------+----------------+ mysql> describe gfruit; +--------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | gname | varchar(30) | | | | | | cgname | varchar(30) | | | | | | gimg | varchar(100) | | | | | | userid | varchar(20) | | | | | | fuid | varchar(20) | | | | | | fname | varchar(20) | | | | | | text | varchar(250) | | | | | | time | datetime | | | 0000-00-00 00:00:00 | | +--------+--------------+------+-----+---------------------+----------------+ mysql> describe gift; +--------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------+-------+ | gname | varchar(30) | | PRI | | | | cgname | varchar(30) | | | | | | gimg | varchar(100) | | | | | | price | int(11) | | | 0 | | | worth | int(11) | YES | | 0 | | | about | varchar(255) | | | | | | gtable | varchar(30) | | | | | +--------+--------------+------+-----+---------+-------+ mysql> describe gjewelry; +--------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+--------------+------+-----+---------------------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | gname | varchar(30) | | | | | | cgname | varchar(30) | | | | | | gimg | varchar(100) | | | | | | userid | varchar(20) | | | | | | fuid | varchar(20) | | | | | | fname | varchar(20) | | | | | | text | varchar(250) | | | | | | time | datetime | | | 0000-00-00 00:00:00 | | +--------+--------------+------+-----+---------------------+----------------+ mysql> describe massage; +--------+-------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | toid | varchar(20) | NO | | | | |