TP5 多条件where查询（使用PHP变量）

- 想要引用PHP变量记得用双引号

public function queryFullBoxFreight()
    {
        // 数据库表
        $table = 'table_xxx';

        $order_clause = input('order_clause','');
        $order_start_place = input('order_start_place','');
        $order_end_place = input('order_end_place','');

        // 查询数据库
        $wheres = [];
        $wheres['fullBox_clause'] = array('like', "%$order_clause%");
        $wheres['fullBox_start_place'] = array('like', "%$order_start_place%");
        $wheres['fullBox_end_place'] = array('like', "%$order_end_place%");
        $datas = Db::table($table)
            ->where($wheres)
            ->select();

        // 返回数据
        return returnData::returnSuccess($datas);
    }