for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace Spatie\QueryBuilder\Filters;
use Illuminate\Support\Facades\DB;
use Illuminate\Database\Eloquent\Builder;
class FiltersPartial implements Filter
{
public function __invoke(Builder $query, $value, string $property) : Builder
if (is_array($value)) {
return $query->where(function (Builder $query) use ($value, $property) {
foreach ($value as $partialValue) {
$query
->orWhere($property, 'LIKE', DB::raw('? ESCAPE "\"'))
->addBinding("%{$this->escapeLike($partialValue)}%");
}
});
return $query
->where($property, 'LIKE', DB::raw('? ESCAPE "\"'))
->addBinding("%{$this->escapeLike($value)}%");
protected function escapeLike(string $value): string
return addcslashes($value, '\%_');
spatie /
laravel-query-builder
