dedecms数据库调用

// 示例代码：检查数据库连接
try {
    $dsn = 'mysql:host=localhost;dbname=dedecms';
    $user = 'username';
    $password = 'password';
    $pdo = new PDO($dsn, $user, $password);
    echo "数据库连接成功";
} catch (PDOException $e) {
    echo "数据库连接失败: " . $e->getMessage();
}

// 示例代码：查询数据库
try {
    $sql = "SELECT * FROM dede_archives WHERE id = :id";
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(':id', $id, PDO::PARAM_INT);
    $stmt->execute();
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
    if (empty($result)) {
        echo "查询结果为空";
    } else {
        print_r($result);
    }
} catch (PDOException $e) {
    echo "查询失败: " . $e->getMessage();
}

// 示例代码：使用索引优化查询
try {
    $sql = "SELECT * FROM dede_archives WHERE title LIKE :title";
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(':title', $title, PDO::PARAM_STR);
    $stmt->execute();
    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
    print_r($result);
} catch (PDOException $e) {
    echo "查询失败: " . $e->getMessage();
}