Laravel Advanced Search - LIKE, BETWEEN, Complex Filters
Build powerful search queries using LIKE patterns, date ranges, IN clauses, and multiple conditions for flexible data filtering.
edit_note
PHP Code Editor
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\DB;
Schema::create('users', function (Blueprint $table) {
$table->id();
$table->string('name');
$table->string('email')->unique();
$table->string('role')->default('user');
$table->boolean('active')->default(true);
$table->timestamps();
});
$domains = ['gmail.com', 'yahoo.com', 'outlook.com', 'company.com'];
$statuses = ['active', 'pending', 'suspended', 'banned'];
for ($i = 1; $i <= 150; $i++) {
DB::table('users')->insert([
'name' => ['John', 'Jane', 'Admin', 'Super', 'Test'][$i % 5] . ' User ' . $i,
'email' => "user{$i}@" . $domains[array_rand($domains)],
'role' => ['user', 'admin', 'moderator'][array_rand(['user', 'admin', 'moderator'])],
'active' => (bool)rand(0, 1),
'created_at' => now()->subDays(rand(0, 180)),
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
terminal
Execution Result
play_circle_outline
Ready to execute
Click the "Run Script" button to see the output here
article
Description
Real-world applications need robust search functionality. This snippet covers text search, date ranges, multi-condition filtering, and combining complex WHERE clauses for comprehensive search capabilities.
Comments
No comments yet
Be the first to share your thoughts!