phpcms 数据分离

try {
    // 开启事务
    $pdo->beginTransaction();

    // 执行数据操作
    $pdo->exec("UPDATE users SET balance = balance - 100 WHERE id = 1");
    $pdo->exec("UPDATE users SET balance = balance + 100 WHERE id = 2");

    // 提交事务
    $pdo->commit();
} catch (Exception $e) {
    // 回滚事务
    $pdo->rollBack();
    echo "数据更新失败：" . $e->getMessage();
}

// 使用Redis缓存数据
$redis = new Redis();
$redis->connect('127.0.0.1', 6379);

$key = 'user:1';
$data = $redis->get($key);

if (!$data) {
    $data = $pdo->query("SELECT * FROM users WHERE id = 1")->fetch(PDO::FETCH_ASSOC);
    $redis->setex($key, 3600, json_encode($data));
} else {
    $data = json_decode($data, true);
}

$stmt = $pdo->prepare("SELECT * FROM users WHERE username = :username AND password = :password");
$stmt->bindParam(':username', $username);
$stmt->bindParam(':password', $password);
$stmt->execute();

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