回答編集履歴
2
修正
answer
CHANGED
|
@@ -16,7 +16,7 @@
|
|
|
16
16
|
$blogs = Blog::query()
|
|
17
17
|
->where('user_id', $request->user()->id)
|
|
18
18
|
->when(count($words), function ($query) use ($words) {
|
|
19
|
-
$query->where(function($query){
|
|
19
|
+
$query->where(function($query) use ($words) {
|
|
20
20
|
foreach ($words as $word) {
|
|
21
21
|
$query->where('title', 'like', '%' . $word . '%')
|
|
22
22
|
->orWhere('target_site', 'like', '%' . $word . '%')
|
1
修正
answer
CHANGED
|
@@ -16,12 +16,14 @@
|
|
|
16
16
|
$blogs = Blog::query()
|
|
17
17
|
->where('user_id', $request->user()->id)
|
|
18
18
|
->when(count($words), function ($query) use ($words) {
|
|
19
|
+
$query->where(function($query){
|
|
19
|
-
|
|
20
|
+
foreach ($words as $word) {
|
|
20
|
-
|
|
21
|
+
$query->where('title', 'like', '%' . $word . '%')
|
|
21
|
-
|
|
22
|
+
->orWhere('target_site', 'like', '%' . $word . '%')
|
|
22
|
-
|
|
23
|
+
->orWhere('content', 'like', '%' . $word . '%')
|
|
23
|
-
|
|
24
|
+
->orWhere('created_at', 'like', '%' . $word . '%');
|
|
24
|
-
|
|
25
|
+
}
|
|
26
|
+
})
|
|
25
27
|
})
|
|
26
28
|
->latest()
|
|
27
29
|
->paginate();
|