本文介绍了带有多个where orwhere和内部联接的laravel mysql查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何在Laravel中准备以下MySQL查询?
How can I prepare the following MySQL query in Laravel?
这是我没有成功使用的代码:
This is the code I used without success:
$user_list = DB::table('users')
->where('users.user_id' ,'=', $clientId)
->where('users.firstname', 'LIKE', '%'.$_POST['name'].'%')
->orWhere('users.lastname', 'LIKE', '%'.$_POST['name'].'%')
->orWhere('users.email', 'LIKE', '%'.$_POST['name'].'%')
->join('users_roles', 'users.id', '=', 'users_roles.user_id')
->where('users_roles.role_id', '=', Role::USER_PARTICIPANT)
->get();
条件必须为:
-
users.user_id == $clientId
-
users.firstname == '%'.$_POST['name'].'%' OR users.lastname == '%'.$_POST['name'].'%' OR users.email == '%'.$_POST['name'].'%'
- users_roles和通过
users.id == users_roles.user_id when users_roles.role_id == Role::USER_PARTICIPANT
穿越的用户之间的内部联接
users.user_id == $clientId
users.firstname == '%'.$_POST['name'].'%' OR users.lastname == '%'.$_POST['name'].'%' OR users.email == '%'.$_POST['name'].'%'
- inner join between users_roles and users crossing by
users.id == users_roles.user_id when users_roles.role_id == Role::USER_PARTICIPANT
推荐答案
好吧,看来您的问题出在嵌套其中
Okay it looks like your problem is with the nested where
尝试一下:
$name = $_POST['name']; // I'd recommend you use Input::get('name') instead...
$user_list = DB::table('users')
->where('users.user_id' ,'=', $clientId)
->where(function($query) use ($name){
$query->where('users.firstname', 'LIKE', '%'.$name.'%');
$query->orWhere('users.lastname', 'LIKE', '%'.$name.'%');
$query->orWhere('users.email', 'LIKE', '%'.$name.'%');
})
->join('users_roles', 'users.id', '=', 'users_roles.user_id')
->where('users_roles.role_id', '=', Role::USER_PARTICIPANT)
->get();
这篇关于带有多个where orwhere和内部联接的laravel mysql查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!