dedecms 调用sql

<?php
// 连接数据库
$db = new PDO('mysql:host=localhost;dbname=dedecms', 'username', 'password');

// 查询示例
$query = "SELECT * FROM dede_archives WHERE id = :id";
$stmt = $db->prepare($query);
$stmt->bindParam(':id', $id, PDO::PARAM_INT);
$id = 10;
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 插入示例
$insertQuery = "INSERT INTO dede_archives (typeid, title, sortrank) VALUES (:typeid, :title, :sortrank)";
$insertStmt = $db->prepare($insertQuery);
$insertStmt->bindParam(':typeid', $typeid, PDO::PARAM_INT);
$insertStmt->bindParam(':title', $title, PDO::PARAM_STR);
$insertStmt->bindParam(':sortrank', $sortrank, PDO::PARAM_INT);
$typeid = 1;
$title = 'New Article';
$sortrank = 100;
$insertStmt->execute();

// 更新示例
$updateQuery = "UPDATE dede_archives SET title = :title WHERE id = :id";
$updateStmt = $db->prepare($updateQuery);
$updateStmt->bindParam(':title', $newTitle, PDO::PARAM_STR);
$updateStmt->bindParam(':id', $id, PDO::PARAM_INT);
$newTitle = 'Updated Article';
$id = 10;
$updateStmt->execute();

// 删除示例
$deleteQuery = "DELETE FROM dede_archives WHERE id = :id";
$deleteStmt = $db->prepare($deleteQuery);
$deleteStmt->bindParam(':id', $id, PDO::PARAM_INT);
$id = 10;
$deleteStmt->execute();
?>