程序由三部分组成,即显示主题信息,显示论坛信息,增加论坛信息,主题与论坛内容采用主从表关系。
表结构如下:
droptablefr_t_forumtitle;
createtablefr_t_forumtitle(
idinteger,
statevarchar(1),
readcountinteger,
replycountinteger,
titlevarchar(100),
createmanvarchar(20),
replymanvarchar(20),
replytimedatetime);
droptablefr_t_forumcontent;
createtablefr_t_forumcontent(
idinteger,
replymanvarchar(20),
replytimedatetime,
replyemailvarchar(100),
replyhttpvarchar(100),
replyfacesmallint,
contenttext);
droptablefr_t_parameter;
createtablefr_t_parameter(
codevarchar(10),
namevarchar(40),
contentvarchar(10));
insertintofr_t_parameter(code,name,content)values('pageline','分页数','20');/*调整该参数可以修改每页行数*/
程序1:mainforum.php
include("c:mydbheader.inc");
?>