Issue with encryption decryption in Laravel Query Builder

Basically you could use something like this:

Model::where(...)->filter(function($row) use($value) {
    if(Crypt::decrypt($row->value) == $value) {
        return $row;
    }
});

Found here: https://laravel.io/forum/02-20-2014-search-encrypted-data

Hello Kinomej,

Thanks for your reply.

I have a query like below in which I want to apply search on First name fields which data is encrypted into a database table

$query = User::select('users.id', 'first_name', 'last_name', 'address_line_1', 'cell_phone', 'specialities.name as primary_speciality')
            ->where('role_id', '3')
            ->leftJoin('provider_primary_specialities', 'users.id', '=', 'provider_primary_specialities.user_id', 'left')
            ->join('specialities', 'provider_primary_specialities.speciality_id', '=', 'specialities.id', 'left')
            ->where(function ($query) use ($data) {

                if (isset($data['search'])) {
                $query->orWhere('first_name', 'LIKE', '%' . $data['search'] . '%');
                }

                if (isset($data['search'])) {
                    $query->orWhere('address_line_1', 'LIKE', '%' . $data['search'] . '%');
                }

                if (isset($data['search'])) {
                    $query->orWhere('cell_phone', 'LIKE', '%' . $data['search'] . '%');
                }
                
            });

return $query->orderBy($data['orderColumn'] ?? 'users.created_at', $data['orderDirection'] ?? 'desc')
    ->paginate($data['per_page'] ?? 10);

How can I apply Laravel query builder filter on it?

@RAJDIPBACANCY - For obvious reasons you can't use LIKE queries to search through encrypted data. Your database has no clue what the original values are. The only way you could 'search' your records is by loading them all into your application, decrypting them (one by one preferably) and doing a 'search' with PHP until you find your match.

@devfrey : After doing lots of googling I found that I need to follow the same method which you suggest. Now for searching records, I am first loading all the data than decrypting it and apply a filter on it. this solution increases my result output time but I think there is no other proper solution rather than this.

Thanks for your reply.

@RAJDIPBACANCY - Glad you found a solution. Good luck!

How did you end up doing this? I am trying to search encrypted data with Laravel Nova