fetchAll($db->select('table.metas.mid') ->from('table.metas') ->join('table.relationships', 'table.metas.mid = table.relationships.mid') ->where('table.relationships.cid = ?', $this->cid) ->where('table.metas.type = ?', 'category')); foreach ($postCategories as $cat) { $currentCategoryMids[] = $cat['mid']; } if (!empty($currentCategoryMids)): // 构建安全的IN查询 - 使用intval确保安全 $safeMids = array_map('intval', $currentCategoryMids); $midPlaceholders = implode(',', $safeMids); // 获取同分类下的所有文章（排除当前文章） $allRelatedPosts = $db->fetchAll($db->select()->from('table.contents') ->join('table.relationships', 'table.contents.cid = table.relationships.cid') ->where('table.contents.type = ?', 'post') ->where('table.contents.status = ?', 'publish') ->where('table.contents.cid != ?', $this->cid) ->where('table.relationships.mid IN (' . $midPlaceholders . ')') ->group('table.contents.cid')); // 随机打乱并取前4篇 shuffle($allRelatedPosts); $relatedPosts = array_slice($allRelatedPosts, 0, 4); if (!empty($relatedPosts)): ?>

更多相关文章

have()): $postWidget->next(); // 获取分类 $relatedCategories = $db->fetchAll($db->select('table.metas.name', 'table.metas.slug', 'table.metas.mid') ->from('table.metas') ->join('table.relationships', 'table.metas.mid = table.relationships.mid') ->where('table.relationships.cid = ?', $postRow['cid']) ->where('table.metas.type = ?', 'category')); ?>
fields->cover): ?> <?php $postWidget->title(); ?>
无图片
    mid = $cat['mid']; $catWidget->to($catWidget); if ($catWidget->have()): $catWidget->next(); ?>
  • name(); ?>

title(); ?>
fetchAll($db->select('table.metas.name', 'table.metas.slug') ->from('table.metas') ->join('table.relationships', 'table.metas.mid = table.relationships.mid') ->where('table.relationships.cid = ?', $postRow['cid']) ->where('table.metas.type = ?', 'tag') ->limit(5)); if (!empty($relatedTags)): foreach ($relatedTags as $tag): ?>