帝国CMS 模板使用灵动标签调用其他数据表里的数据并非空判断

帝国CMS 模板使用灵动标签调用其他数据表里的数据并非空判断

                   <!-- SEO分析报告展示 -->
                    <?php
                    // 获取当前文章的domain字段
                    $current_domain = !empty($navinfor[&39;domain&39;]) ? trim($navinfor[&39;domain&39;]) : &39;&39;;
                    if (!empty($current_domain)) {
                        // 检查是否有符合条件的SEO报告数据
                        global $empire, $dbtbpre;
                        $sql = SELECT id FROM {$dbtbpre}ecms_seo WHERE domain=&39;$current_domain&39; LIMIT 1;
                        $r = $empire->fetch1($sql);
                        if (!empty($r[&39;id&39;])) {
                    ?>
                        <div class=website-recommend>
                            <div class=recommend-banner>
                                [e:loop={44,3,0,0,domain=&39;$current_domain&39;,&39;newstime DESC&39;}]
                                    <?php
                                    $title = !empty($bqr[&39;title&39;]) ? trim($bqr[&39;title&39;]) : &39;&39;;
                                    $titlepic = !empty($bqr[&39;titlepic&39;]) ? trim($bqr[&39;titlepic&39;]) : &39;&39;;
                                    $smalltext = !empty($bqr[&39;smalltext&39;]) ? trim($bqr[&39;smalltext&39;]) : &39;&39;;
                                    $titleurl = !empty($bqr[&39;titleurl&39;]) ? trim($bqr[&39;titleurl&39;]) : &39;&39;;
                                    if (!empty($title) && !empty($titleurl)) {
                                    ?>
                                        <div class=recommend-banner-item>
                                            <?php if (!empty($titlepic)): ?>
                                                <div class=banner-item-image>
                                                    <img src=<?=$titlepic?> alt=<?=$title?> width=50 height=50>
                                                </div>
                                            <?php endif; ?>
                                            <div class=banner-item-info>
                                                <div class=banner-item-content>
                                                    <a href=<?=$titleurl?> target=_blank class=banner-item-title><?=$title?></a>
                                                    <?php if (!empty($smalltext)): ?>
                                                        <p class=banner-item-desc><?=$smalltext?></p>
                                                    <?php endif; ?>
                                                </div>
                                                <div class=banner-item-button>
                                                    <a href=<?=$titleurl?> target=_blank class=view-website-btn>
                                                        <i class=fas fa-external-link-alt></i>
                                                        查看SEO报告
                                                    </a>
                                                </div>
                                            </div>
                                        </div>
                                    <?php
                                    }
                                    ?>
                                [/e:loop]
                            </div>
                        </div>
                    <?php
                        }
                    }
                    ?>