使用ma实现

func BuildCondition(where map[string]interface{}) (whereSql string,
    values []interface{}, err error) {
    for key, value := range where {
        conditionKey := strings.Split(key, " ")
        if len(conditionKey) > 2 {
            return "", nil, fmt.Errorf("" +
                "map构建的条件格式不对，类似于'age >'")
        }
        if whereSql != "" {
            whereSql += " AND "
        }
        switch len(conditionKey) {
        case 1:
            whereSql += fmt.Sprint(conditionKey[0], " = ?")
            values = append(values, value)
            break
        case 2:
            field := conditionKey[0]
            switch conditionKey[1] {
            case "=":
                whereSql += fmt.Sprint(field, " = ?")
                values = append(values, value)
                break
            case ">":
                whereSql += fmt.Sprint(field, " > ?")
                values = append(values, value)
                break
            case ">=":
                whereSql += fmt.Sprint(field, " >= ?")
                values = append(values, value)
                break
            case "<":
                whereSql += fmt.Sprint(field, " < ?")
                values = append(values, value)
                break
            case "<=":
                whereSql += fmt.Sprint(field, " <= ?")
                values = append(values, value)
                break
            case "in":
                whereSql += fmt.Sprint(field, " in (?)")
                values = append(values, value)
                break
            case "like":
                whereSql += fmt.Sprint(field, " like ?")
                values = append(values, value)
                break
            case "<>":
                whereSql += fmt.Sprint(field, " != ?")
                values = append(values, value)
                break
            case "!=":
                whereSql += fmt.Sprint(field, " != ?")
                values = append(values, value)
                break
            }
            break
        }
    }
    return
}

用法

conditionString, values, _ := tool.BuildCondition(map[string]interface{}{
        "itemNO":        "02WZ05133",
        "itemName like": "%22220",
        "id in":         []int{20, 19, 30},
        "num !=" : 20,
    })
var student model.Student
db.where(conditionString,values).Find(&student)

1.注意事项

a、服务器web服务必须是nginx，php必须以php-fpm启动。

b、服务器同时安装了php5.6和php7.1。

2.开始配置

修改nginx配置文件

宝塔站点管理点击你想配置的站点，选择配置文件，我们先将33行左右的include enable-php-xx.conf前加#注释掉然后加入如下代码

location ~ ¹.php(/|$)

{    

    fastcgi_pass unix:/tmp/php-cgi-71.sock; 

    fastcgi_index index.php;

    include fastcgi.conf;

    include pathinfo.conf;

    if ($request_uri ~* "ndot_blindbox"){   

        fastcgi_pass unix:/tmp/php-cgi-72.sock;    

    }   

}

登录阿里云控制台/对象存储/Bucket列表/xxx/权限控制/跨域设置/创建规则。设置如下：

来源：*
允许 Methods：GET|POST
允许 Headers：access-control-allow-origin:*
              access-control-allow-credentials:true
暴露 Headers：空白不写
缓存时间（秒）：600
返回 Vary: Origin：勾选