How to decrypt

[matze1708]

Hello,

how can I decode a field again?

what do i have to set in model for casts?

Thank you :-)

[matze1708]

Hi,

I have put the column APP_Token into the

protected $casts = [
        'email_verified_at' => 'datetime',
        'APP_Token' => EncryptableDbAttribute::class,

    ];

In the view I get the value decrypted.
But I want to search for a value in the controller, how can I do that?

my first attempt was

    $credentials = $request->only('RFID');
          
        $user = User::firstorfail()->where('APP_Token', $credentials)->pluck('id')->toArray();

[matze1708]

Hello,
does anyone have an idea how I can search for the number?

Thanks.

[fabianmieller]

@matze1708 have you tried Crypt::decrypt($value);?

[caiowilson]

@matze1708 have you tried Crypt::decrypt($value);?

I did, doesn't work. I'll probably gonna have to either: leave the columns I want to search decrypted or paginate on the frontend and filter over there. cant paginate a collection (which would get me the decrypted values), idk, very weird. and i'm using the sabe method the trait uses.
I'm not sure what i'm missing

[caiowilson]

@matze1708 have you tried Crypt::decrypt($value);?

I did, doesn't work. I'll probably gonna have to either: leave the columns I want to search decrypted or paginate on the frontend and filter over there. cant paginate a collection (which would get me the decrypted values), idk, very weird. and i'm using the sabe method the trait uses. I'm not sure what i'm missing

EG:
(incident_number is encrypted)
Incident::where('incident_number', Crypt::encrypt($request['search']))
doesnt return any matches.
same with like or ilike using %encrypted-value-from-search%, nothing comes back