Laravel验证字段是否由中文、英文组成
摘要:function editValidator(array $params){ //定义规则 $rules = [ 'name' => ['regex:/^[\x{4e00}-\x{9fa5}A-Za-z]+$/u'], ]; //重新编辑错误信息 $messages = [ 'name.regex'
阅读全文
Laravel实现mysql的OR
摘要:SELECT * FROM user WHERE (`id` = 1 OR `name` LIKE '%1%'); DB::table('user') ->select(['*']) ->where(function ($query) use ($idOrName) { $query->where(
阅读全文
Laravel实现FIND_IN_SET
摘要:SELECT * FROM user WHERE FIND_IN_SET(1, type); DB::table('user') ->select(['*']) ->whereRaw('FIND_IN_SET(?, type)', [$type]) ->get();
阅读全文