Crypt in Eloquent Query

If it's encrypted everywhere it should be like this

$get = Model::firstWhere('key', Auth::user()->key);

Hey, thanks for the reply

However, it's the 'key' ie the first parameter in the query I want to decrypt to match the results. It doesn't get decrypted in the eloquent query I guess?

Thanks :)

In Model key is encrypted, in User it's also encrypted, but you use trait where when you call it it will be automatically decrypts. So you have to encrypt it again.

$get = Model::firstWhere('key', encrypt(Auth::user()->key));

Well, the question is,

I want to do this

$get = Model::firstWhere(Crypt::decrypt('key'), Crypt::decrypt(Auth::user()->key));

& it will get me the row which has the same key when decrypted.

But I cannot do that because Crypt::decrypt('key') is not a valid parameter and it will not search the column. The Crypt Facade will give me a "Low Payload" error.

Since laravel encryptions are randomized and it is not suggested to use the same encrypted string two places.

But it doesn't matter if you compare encrypted or decrypted key, if you compare every time the same value.

And another question why you don't use forein key?

Oh thanks btw, I found a way out of this.

I used a raw randomized key in the core db and an encrypted key in the user db. It matches perfectly.

Thanks :)

@myselfaaryan So what is your final code?

$get = Model::firstWhere('key', Crypt::decrypt(Auth::user()->key));

@myselfaaryan And what is different from your original post?

You had there the same

$get = Model::firstWhere('key', Crypt::decrypt(Auth::user()->key));