phpcms 自定义sql语句

// 假设我们有一个数据库连接对象 $db
$db = pc_base::load_config('database');

// 自定义 SELECT 语句
$sql = "SELECT * FROM `v9_news` WHERE `status` = 1 ORDER BY `id` DESC LIMIT 10";
$result = $db->query($sql);

// 处理查询结果
while ($row = $db->fetch_array($result)) {
    echo $row['title'] . '<br>';
}

// 自定义 INSERT 语句
$insert_sql = "INSERT INTO `v9_news` (`title`, `content`, `status`) VALUES ('New Article', 'This is the content of the new article.', 1)";
$db->query($insert_sql);

// 使用预处理语句防止 SQL 注入
$stmt = $db->prepare("SELECT * FROM `v9_news` WHERE `status` = ? ORDER BY `id` DESC LIMIT 10");
$stmt->bind_param('i', $status);
$status = 1;
$stmt->execute();
$result = $stmt->get_result();

try {
    $db->query($sql);
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}