html带数据库模板

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

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 查询数据
$sql = "SELECT id, title, content FROM articles";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "<h2>" . $row["title"] . "</h2>";
        echo "<p>" . $row["content"] . "</p>";
    }
} else {
    echo "0 结果";
}
$conn->close();
?>

<?php
// 连接Redis
$redis = new Redis();
$redis->connect('127.0.0.1', 6379);

// 尝试从缓存中获取数据
$data = $redis->get('articles');

if (!$data) {
    // 数据库连接
    $conn = new mysqli("localhost", "username", "password", "database");

    if ($conn->connect_error) {
        die("连接失败: " . $conn->connect_error);
    }

    // 查询数据
    $sql = "SELECT id, title, content FROM articles";
    $result = $conn->query($sql);

    $data = [];
    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            $data[] = $row;
        }
    }

    $conn->close();

    // 将数据存入缓存
    $redis->set('articles', json_encode($data), 3600); // 缓存1小时
}

// 渲染模板
foreach (json_decode($data, true) as $row) {
    echo "<h2>" . $row["title"] . "</h2>";
    echo "<p>" . $row["content"] . "</p>";
}
?>