获取栏目文章数量 dedecms

<?php
// 连接数据库
$mysqli = new mysqli("localhost", "username", "password", "dedecms");

// 检查连接
if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

// 查询某个栏目的文章数量
$catid = 1; // 栏目ID
$sql = "SELECT COUNT(*) AS article_count FROM dede_archives WHERE typeid = $catid";
$result = $mysqli->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    echo "栏目ID为 $catid 的文章数量为: " . $row["article_count"];
} else {
    echo "没有找到相关文章";
}

// 关闭连接
$mysqli->close();
?>

<?php
require_once 'include/common.inc.php';

// 获取某个栏目的文章数量
$catid = 1; // 栏目ID
$article_count = $dsql->GetOne("SELECT COUNT(*) AS article_count FROM dede_archives WHERE typeid = $catid");
echo "栏目ID为 $catid 的文章数量为: " . $article_count['article_count'];
?>

{dede:field.typeid function="GetArticleCount(@me)" /}