phpcms调用发布时间

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

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

// 查询发布时间
$sql = "SELECT inputtime FROM v9_news WHERE id = 1";
$result = $mysqli->query($sql);

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

$mysqli->close();
?>

<?php
$url = "http://example.com/api/get_news_time?id=1";
$response = file_get_contents($url);
$data = json_decode($response, true);

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

{phpcms:time id="1" type="inputtime"}
发布时间: {$time|date="Y-m-d H:i:s"}
{/phpcms:time}

// 检查时区设置
date_default_timezone_set('Asia/Shanghai');