条件语法

$cond 查询条件

<?php
    // 查询指定id=1，等同于：WHERE id=1
    $cond = ['id'=>1];

    // 查询指定id大于2，等同于 ：WHERE id>2
    $cond = ['id'=>['>'=>2]];

    // 组合查询指定id范围，等同于：WHERE id>2 AND id<10
    $cond = ['id'=>['>'=>2,'<'=10]];

    // LIKE语法，等同于`WHERE title LIKE '%Tom%'`
    $cond = ['title'=>['LIKE'=>'Tom']];

    // 0701版本新增，多条件LIKE语法，等同于：`WHERE (username LIKE '%admin%' OR phone LIKE '%1715107%')`
    $cond = ['LIKES'=>['username'=>'admin','phone'=>'1715107']];

    // 0701版本新增，IN语法，等同于：`WHERE id IN (1,2,3,4)`
    $cond = ['id'=>['IN'=>'1,2,3,4']];

    // 0701版本新增，BETWEN语法，等同于：`WHERE create_time BETWEN '2022-6-22' AND '2022-7-30'`
    $cond = ['create_time'=>['BETWEN'=>['2022-6-22','2022-7-30']]];

    // 0701版本新增，多条件OR查询，等同于：`WHERE (username='admin'  OR phone='13800138000')`
    $cond = ['EQUALS'=>['user'=>'admin','phone'=>'13800138000']];
?>

$orderBy 排序

<?php
    // 某个字段正序，等同于ORDER BY id ASC
    $orderBy = ['id'=>1];

    // 某个字段倒序，等同于ORDER BY id DESC
    $orderBy = ['id'=>-1];

    // 支持组合查询，等同于：ORDER BY id ASC, gid DESC
    $orderBy = ['id'=>1,'gid'=>-1];
?>

$col 列过滤

<?php
    // 等同于：SELECT username,phone,mail FROM ...
    $col = ['username','phone','mail'];
?>