phpcms 调用发布时间

<?php
// 假设这是你的数据库连接代码
$host = 'localhost';
$dbname = 'phpcms';
$user = 'root';
$pass = '';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);
} catch (PDOException $e) {
    die("数据库连接失败: " . $e->getMessage());
}

// 假设内容 ID 为 123
$content_id = 123;

// 查询发布时间
$stmt = $pdo->prepare("SELECT inputtime FROM v9_news WHERE id = :id");
$stmt->bindParam(':id', $content_id, PDO::PARAM_INT);
$stmt->execute();

$result = $stmt->fetch(PDO::FETCH_ASSOC);

if ($result) {
    $publish_time = $result['inputtime'];
    echo "发布时间: " . date('Y-m-d H:i:s', $publish_time);
} else {
    echo "未找到内容";
}
?>

date_default_timezone_set('Asia/Shanghai');