phpcms字段筛选

// 假设我们有一个文章模型 ArticleModel
$article_model = pc_base::load_model('article_model');

// 单字段筛选示例：根据分类ID筛选文章
$catid = 1; // 分类ID
$sql = "SELECT * FROM v9_article WHERE catid = $catid";
$articles = $article_model->query($sql);

// 多字段筛选示例：根据分类ID和发布时间筛选文章
$catid = 1;
$start_time = '2023-01-01';
$end_time = '2023-12-31';
$sql = "SELECT * FROM v9_article WHERE catid = $catid AND inputtime BETWEEN '$start_time' AND '$end_time'";
$articles = $article_model->query($sql);

// 模糊筛选示例：根据标题关键字筛选文章
$key_word = 'PHP';
$sql = "SELECT * FROM v9_article WHERE title LIKE '%$key_word%'";
$articles = $article_model->query($sql);

// 使用预处理语句防止 SQL 注入
$catid = 1;
$sql = "SELECT * FROM v9_article WHERE catid = ?";
$stmt = $article_model->db->prepare($sql);
$stmt->bind_param('i', $catid);
$stmt->execute();
$result = $stmt->get_result();
$articles = $result->fetch_all(MYSQLI_ASSOC);

-- 添加索引
ALTER TABLE v9_article ADD INDEX idx_catid (catid);
ALTER TABLE v9_article ADD INDEX idx_inputtime (inputtime);

// 检查字段是否存在
$field_exists = $article_model->db->query("SHOW COLUMNS FROM v9_article LIKE 'title'");
if ($field_exists->num_rows > 0) {
    // 字段存在，继续筛选操作
} else {
    // 字段不存在，处理错误
}