当前位置：网站首页>TP5 multi conditional where query (using PHP variables)

TP5 multi conditional where query (using PHP variables)

2022-04-23 03:03:00 【Stupid little attendant】

- Want to reference PHP Remember to use double quotation marks for variables 

public function queryFullBoxFreight()
    {
    
        //  Database table 
        $table = 'table_xxx';

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

        //  Query the database 
        $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 the data 
        return returnData::returnSuccess($datas);
    }

版权声明
本文为[Stupid little attendant]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220630238752.html

边栏推荐

猜你喜欢

随机推荐