帝国CMS通过评论调用对应的文章链接和文章标题

  1. 查询并调用文章信息
    <?php
    $sql = $empire->query("select * from {$dbtbpre}enewspl_1 where id='$navinfor[id]' and checked=0 order by saytime limit 10");
    $userr = sys_ShowMemberInfo(0, '');
    while ($r = $empire->fetch($sql)) {
        $q = $empire->fetch1("select title, titleurl from {$dbtbpre}ecms_news where id='$r[id]' limit 1");
    ?>
    栏目id:<?=$r['classid']?>
    文章id:<?=$r['id']?>
    用户名:<?=$r['username']?>
    评论内容:<?=$r['saytext']?>
    标题:<?=$q['title']?>
    链接:<?=$q['titleurl']?>
    <?php } ?>

     

posted @ 2024-12-08 17:36  黄文Rex  阅读(7)  评论(0)    收藏  举报