Comments (5)
Unfortunately, this isn't possible since it requires a fixed IV. You could store a hash of your column, and search for it.
from laravel-gdpr.
Unfortunately, this isn't possible since it requires a fixed IV. You could store a hash of your column, and search for it.
Thank you, would you elaborate more on this please?
I am not sure how to implement this!
from laravel-gdpr.
I'd do something like this:
<?php
namespace App\Traits;
trait HashesAttributes
{
/**
* Set a given attribute on the model.
*
* @param string $key
* @param mixed $value
* @return $this
*/
public function setAttribute(
$key,
$value
) {
if (in_array($key, $this->encrypted) &&
!is_null($value)) {
$this->hashAttributeValue($key, $value);
}
parent::setAttribute($key, $value);
}
/**
* Hash the given attribute's value.
*
* @param string $key
* @param mixed $value
* @return $this
*/
public function hashAttributeValue(
$key,
$value
) {
$hash = hash_hmac('sha1', $value, config('app.key'));
parent::setAttribute($key . '_hash', $hash);
}
/**
* Add a where hash clause to the query.
*
* @param \Illuminate\Database\Eloquent\Builder $query
* @param string $key
* @param mixed $value
* @return \Illuminate\Database\Eloquent\Builder
*/
public function scopeWhereHash(
$query,
$key,
$value
) {
$hash = hash_hmac('sha1', $value, config('app.key'));
return $query->where($key . '_hash', $hash);
}
}
$users = App\User::whereHash('name', 'Sander')->get();
from laravel-gdpr.
I got your idea and I will feedback again after I implement it.
However, this will work fine with full matches only.
Any ideas for partial matching? i.e. using 'LIKE'
from laravel-gdpr.
I don't think that's possible. If you're searching a small set of data, you could always retrieve the data as a (decrypted) collection and filter it.
from laravel-gdpr.
Related Issues (20)
- Decryption not working with toArray() HOT 1
- How to hide relation attributes? HOT 5
- Laravel 6 support HOT 2
- Remove backwards compatibility in next release
- How do I authenticate with db encrypted like email? HOT 1
- Update to Laravel 8 HOT 2
- Is it possible to Login using Encrypted email. HOT 1
- Laravel 8 incompatibility issue HOT 1
- Authentication Mistake HOT 1
- Regarding GDPR HOT 1
- usage doubt
- when use Lazy Eager Loading Relationships, gdprHidden not works HOT 1
- Data download usage with Inertia HOT 7
- API data decryption HOT 1
- Laravel 9 support HOT 3
- show only some relationship attributes HOT 3
- Changing the downloaded file name ? HOT 1
- Laravel 10 support HOT 1
- Laravel 11.x Compatibility HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from laravel-gdpr.