phpcms 调取摘要

<?php
// 假设我们有一个文章ID
$article_id = 123;

// 连接数据库
$db = new mysqli('localhost', 'username', 'password', 'phpcms');

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

// 查询文章摘要
$sql = "SELECT content, summary FROM articles WHERE id = ?";
$stmt = $db->prepare($sql);
$stmt->bind_param("i", $article_id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();

if ($row) {
    $content = $row['content'];
    $summary = $row['summary'];

    // 如果没有手动摘要，则自动生成摘要
    if (empty($summary)) {
        $summary = generate_summary($content);
    }

    echo "文章摘要: " . $summary;
} else {
    echo "文章未找到";
}

// 关闭连接
$stmt->close();
$db->close();

// 自动生成摘要的函数
function generate_summary($content, $length = 200) {
    $summary = strip_tags($content); // 去除 HTML 标签
    if (strlen($summary) > $length) {
        $summary = substr($summary, 0, $length) . '...';
    }
    return $summary;
}
?>