dedecms 调用当前栏目热门文章

<?php
// 获取当前栏目ID
$catid = $_GET['catid'];

// SQL查询语句
$sql = "SELECT aid, title, clicks 
        FROM dede_archives 
        WHERE typeid = $catid 
        ORDER BY clicks DESC 
        LIMIT 10";

// 执行查询
$query = mysql_query($sql);

// 获取查询结果
$hot_articles = array();
while ($row = mysql_fetch_assoc($query)) {
    $hot_articles[] = $row;
}

// 输出结果
foreach ($hot_articles as $article) {
    echo "<a href='/plus/view.php?aid={$article['aid']}'>{$article['title']}</a> (点击数: {$article['clicks']})<br>";
}
?>

<?php
// 获取当前栏目ID
$catid = $_GET['catid'];

// 使用预处理语句防止SQL注入
$stmt = $pdo->prepare("SELECT aid, title, clicks 
                       FROM dede_archives 
                       WHERE typeid = :catid 
                       ORDER BY clicks DESC 
                       LIMIT 10");

$stmt->bindParam(':catid', $catid);
$stmt->execute();

// 获取查询结果
$hot_articles = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 输出结果
foreach ($hot_articles as $article) {
    echo "<a href='/plus/view.php?aid={$article['aid']}'>{$article['title']}</a> (点击数: {$article['clicks']})<br>";
}
?>

ALTER TABLE dede_archives ADD INDEX idx_typeid_clicks (typeid, clicks);

<?php
// 定时任务脚本
$sql = "UPDATE dede_archives SET clicks = clicks + 1 WHERE aid = :aid";
$stmt = $pdo->prepare($sql);

// 假设有一个数组包含需要更新的文章ID
$article_ids = [1, 2, 3];

foreach ($article_ids as $aid) {
    $stmt->bindParam(':aid', $aid);
    $stmt->execute();
}
?>