简单的调用论坛帖子并生成HTML[070119增加按时间更新页面代码.2楼]

<?
//论坛数据库信息
$dbuser='dbuser';  //数据库用户名
$dbpass='dbpass';  //数据库密码
$dbname='dbname';  //数据库名
$shownum='10';      //显示数量
$titlelen=35; //第一个版块的标题长度
$titlelen2=35; //第二个版块的标题长度
$titlelen3=35; //第三个版块的标题长度
$lasttime=time()-51840000;  //显示两个月内的热门贴
mysql_connect('',$dbuser,$dbpass); //连接数据库
mysql_query("SET NAMES GBK");
mysql_select_db($dbname);
//-------------------美女写真-------------------
$select = mysql_query("SELECT tid,fid,author,lastpost,dateline,lastposter,views,subject,replies FROM cdb_threads where fid=27 and lastpost>$lasttime and closed=0 ORDER BY replies DESC LIMIT 0, $shownum"); //查询表
$result=mysql_fetch_array($select); //以下show是输出
$show.= "<table width='100%' border='0' cellspacing='0' cellpadding='0'>\r\n";
while ($result)
{
$longname=$result['subject'];
//截取帖子标题长度
if(strlen($result['subject']) > $titlelen)
{
$result['subject']=substr($result['subject'],"0",$titlelen-4).chr(0);
$result['subject']=$result['subject']."...";
}
$lastpost=date('Y-m-d',$result[lastpost]);
$dateline=date('Y-m-d',$result[dateline]);
$show.="<tr><td>";
$show.="<a href=http://bbs.1001year.net/thread-{$result[tid]}-1-1.html target=_blank title='标题：{$longname}
作者：{$result['author']}
发表日期：{$dateline}
最后回复：{$lastpost}({$result['lastposter']})
阅读次数：{$result['views']}
回复次数：{$result['replies']}'>".$result['subject']."</a>";
$show.="</td></tr>";
$result=mysql_fetch_array($select);
}
$show.="</table>";
$filename='bbs_mv.html';
$handle=fopen ($filename,"w");
fwrite($handle,$show);
fclose($handle);
unset ($show);
//-------------------精彩贴图-------------------
$select = mysql_query("SELECT tid,fid,author,lastpost,dateline,lastposter,views,subject,replies FROM cdb_threads where fid=20 and lastpost>$lasttime and closed=0 ORDER BY replies DESC LIMIT 0, $shownum");
$result=mysql_fetch_array($select);
$show.= "<table width='100%' border='0' cellspacing='0' cellpadding='0'>\r\n";
while ($result)
{
$longname=$result['subject'];
//截取帖子标题长度
if(strlen($result['subject']) > $titlelen2)
{
$result['subject']=substr($result['subject'],"0",$titlelen2-4).chr(0);
$result['subject']=$result['subject']."...";
}
$lastpost=date('Y-m-d',$result[lastpost]);
$dateline=date('Y-m-d',$result[dateline]);
$show.="<tr><td>";
$show.="<a href=http://bbs.1001year.net/thread-{$result[tid]}-1-1.html target=_blank title='标题：{$longname}
作者：{$result['author']}
发表日期：{$dateline}
最后回复：{$lastpost}({$result['lastposter']})
阅读次数：{$result['views']}
回复次数：{$result['replies']}'>".$result['subject']."</a>";
$show.="</td></tr>";
$result=mysql_fetch_array($select);
}
$show.="</table>";
$filename='bbs_tt.html';
$handle=fopen ($filename,"w");
fwrite($handle,$show);
fclose($handle);
unset ($show);
//-------------------占星奇缘-------------------
$select = mysql_query("SELECT tid,fid,author,lastpost,dateline,lastposter,views,subject,replies FROM cdb_threads where fid=78 and lastpost>$lasttime and closed=0 ORDER BY replies DESC LIMIT 0, $shownum");
$result=mysql_fetch_array($select);
$show.= "<table width='100%' border='0' cellspacing='0' cellpadding='0'>\r\n";
while ($result)
{
$longname=$result['subject'];
//截取帖子标题长度
if(strlen($result['subject']) > $titlelen2)
{
$result['subject']=substr($result['subject'],"0",$titlelen3-4).chr(0);
$result['subject']=$result['subject']."...";
}
$lastpost=date('Y-m-d',$result[lastpost]);
$dateline=date('Y-m-d',$result[dateline]);
$show.="<tr><td>";
$show.="<a href=http://bbs.1001year.net/thread-{$result[tid]}-1-1.html target=_blank title='标题：{$longname}
作者：{$result['author']}
发表日期：{$dateline}
最后回复：{$lastpost}({$result['lastposter']})
阅读次数：{$result['views']}
回复次数：{$result['replies']}'>".$result['subject']."</a>";
$show.="</td></tr>";
$result=mysql_fetch_array($select);
}
$show.="</table>";
$filename='bbs.html';
$handle=fopen ($filename,"w");
fwrite($handle,$show);
fclose($handle);
unset ($show);
?>


能解释的就这些了，实在找不到可以再解释的东西。

没看懂~~~

以后慢慢研究..米看懂吖...呵呵~

不过你确实解释得不清楚啊.

比如我把这段代码放到我的htm页里.数据地址什么全改好了.结果页面显示的只是你这些代码.并不显示贴子.

你应该说说.这些代表往哪贴.

还有是自动更新,还是手动更新?如果手动就不好了.

这个是PHP代码,你可以专门在你的论坛根目录建个test.php看效果.


这个是手动的，如果想自动更新,加个时间判断即可.

谢谢楼主的好帖，说了不当老师了，但是我这个学生实在是太笨。 麻烦您能详细的讲解清楚吗？

关于如何按时间更新.我个人是用的dede , 不一定都适用.给大家这段代码参考下吧.看2楼.

我改成PHP，什么东西也没有啊。

怎么不好用啊，执行之后出现一堆错误！  

1. 
   
2. Notice: Undefined variable: show in E:\web-php\cg119#Sbbs\test.php on line 17
   
3. 
   
4. Notice: Use of undefined constant lastpost - assumed 'lastpost' in E:\web-php\cg119#Sbbs\test.php on line 27
   
5. 
   
6. Notice: Use of undefined constant dateline - assumed 'dateline' in E:\web-php\cg119#Sbbs\test.php on line 28
   
7. 
   
8. Notice: Use of undefined constant tid - assumed 'tid' in E:\web-php\cg119#Sbbs\test.php on line 30
   
9. 
   
10. Notice: Use of undefined constant lastpost - assumed 'lastpost' in E:\web-php\cg119#Sbbs\test.php on line 27
    
11. 
    
12. Notice: Use of undefined constant dateline - assumed 'dateline' in E:\web-php\cg119#Sbbs\test.php on line 28
    
13. 
    
14. Notice: Use of undefined constant tid - assumed 'tid' in E:\web-php\cg119#Sbbs\test.php on line 30
    
15. 
    

复制代码

怎么会?信息不要改,只改数据库连接的.