摘要: 之前一直用exception 捕捉异常 后来发现一次异常捕捉不到了(其实是错误) 7以上exception与error是分开的 Throwable does not work on PHP 5.x. To catch both exceptions and errors in PHP 5.x and 阅读全文
posted @ 2022-01-27 14:15 可爱香草 阅读(42) 评论(0) 推荐(0)
摘要: 简单查询 // 例如字段filed内容 {"time":"2012-12-01"} where("filed->time","2012-12-01") 数组查询 // 字段field 内容[{"time":"2012-12-01"}] ->whereJsonContains("field ",["t 阅读全文
posted @ 2022-01-14 21:30 可爱香草 阅读(78) 评论(0) 推荐(0)
摘要: $sql = UserRelationMap::select('inviter_id','business_id', DB::raw('COUNT(id) as num,any_value(id) as id,any_value(project_id) as project_id,any_value 阅读全文
posted @ 2022-01-12 16:44 可爱香草 阅读(15) 评论(0) 推荐(0)
摘要: //先group分组 $sql = BlindBox::selectRaw('any_value(id) as id, any_value(business_id) as business_id,project_id,SUM(access_count) as access_count,SUM(joi 阅读全文
posted @ 2022-01-11 17:16 可爱香草 阅读(50) 评论(0) 推荐(0)
摘要: 尝试很多网上的方法无效,自己整理的可行方案 //之前一直是用dom元素(在ios下无效) <audio ref="audio" loop> <source :src="sloganvoice_src" type="audio/mpeg"> </audio> //发现根本不行,在ios无法触发paly 阅读全文
posted @ 2021-12-28 17:38 可爱香草 阅读(22) 评论(0) 推荐(0)
摘要: //laravel User::query()->whereIn('id', User::query()->select('id')->orderByRaw('rand() LIMIT :nums', 3)->get())->get() //mysql SELECT * FROM video WHE 阅读全文
posted @ 2021-12-03 10:03 可爱香草 阅读(13) 评论(0) 推荐(0)
摘要: 很多接口我们会遇到["6","10"] 这样的字符串数组,可是我们需要的是[6,10] 这里推荐一种不用循环解决的方案: $str = ["6","10"]; $str = json_decode('[' . $str. ']', true);//[6,10] 阅读全文
posted @ 2021-10-18 16:44 可爱香草 阅读(11) 评论(0) 推荐(0)
摘要: $refer = [];//临时数组 $tree = [];//树状结构 $list = [];//二维带level foreach ($data as $key => $value) { $refer[$value['id']] = &$data[$key]; } foreach ($data a 阅读全文
posted @ 2021-09-24 17:35 可爱香草 阅读(8) 评论(0) 推荐(0)
摘要: SELECT count(1), DATE(timne), CASE WHEN TIME(timne) BETWEEN '01:00:00' AND '14:00:00' THEN 1 WHEN TIME(timne) BETWEEN '14:00:00' AND '20:00:00' THEN 2 阅读全文
posted @ 2021-09-22 15:14 可爱香草 阅读(17) 评论(0) 推荐(0)
摘要: 在passport v10以上已经移除了相关设置接口,我们可以重写createToken方法实现指定客户端ID public function createToken($name, array $scopes = []) { $clients = new ClientRepository('9466 阅读全文
posted @ 2021-09-22 10:42 可爱香草 阅读(15) 评论(0) 推荐(0)