phpcms数据库操作

try {
    $pdo = new PDO('mysql:host=localhost;dbname=phpcms', 'username', 'password');
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

try {
    $stmt = $pdo->query('SELECT * FROM articles WHERE id = :id');
    $stmt->bindParam(':id', $id, PDO::PARAM_INT);
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    echo "Query failed: " . $e->getMessage();
}

try {
    $stmt = $pdo->prepare('INSERT INTO articles (title, content) VALUES (:title, :content)');
    $stmt->bindParam(':title', $title);
    $stmt->bindParam(':content', $content);
    $stmt->execute();
} catch (PDOException $e) {
    echo "Insert failed: " . $e->getMessage();
}