phpcms自定义sql

// 引入数据库类
pc_base::load_sys_class('db');

// 创建数据库对象
$db = pc_base::load_model('content_model');

// 自定义 SQL 查询
$sql = "SELECT * FROM v9_news WHERE catid = 1 ORDER BY id DESC LIMIT 10";

// 执行查询
$result = $db->query($sql);

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

// 使用预处理语句
$stmt = $db->prepare("SELECT * FROM v9_news WHERE catid = :catid ORDER BY id DESC LIMIT 10");
$stmt->bindParam(':catid', $catid, PDO::PARAM_INT);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 分页查询示例
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$limit = 10;
$offset = ($page - 1) * $limit;
$sql = "SELECT * FROM v9_news WHERE catid = 1 ORDER BY id DESC LIMIT $limit OFFSET $offset";
$result = $db->query($sql);

// 检查数据库连接
try {
    $db = pc_base::load_model('content_model');
    $db->db_connect();
} catch (Exception $e) {
    echo "数据库连接失败: " . $e->getMessage();
}