Giter VIP home page Giter VIP logo

Comments (5)

sander3 avatar sander3 commented on May 24, 2024

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.

ameerElsherif avatar ameerElsherif commented on May 24, 2024

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.

sander3 avatar sander3 commented on May 24, 2024

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.

ameerElsherif avatar ameerElsherif commented on May 24, 2024

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.

sander3 avatar sander3 commented on May 24, 2024

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)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo 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.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.