Laravel Encrypt Database

Automatic Encrypt and Decrypt your database data. Tested and used on Laravel 8. I'm yet building the tests.

Important

• Note the key used to encrypt your data is your app_key, so keep it in a secure place.
• If you lose it, you will lose all your database data.

• The $casts attribute is not available for encrypted fields yet.

• It is highly recommended to alter your encrypted column types to TEXT or LONGTEXT

Features

• Minimal configuration
• Encrypt and Decrypt database fields easily
• Include searching encrypted data using the following: whereEncrypted and orWhereEncrypted
• Include unique_encrypted, exists_encrypted rules
• Uses openssl for encrypting and decrypting fields

Requirements

Laravel >= 8.0
PHP >= 7.4

Installing

Install the package

composer require wellingtoncarneirobarbosa/laravel-encrypt-database

Add the service provider on your providers list config/app.php:168

WellingtonCarneiroBarbosa\EncryptDatabase\Providers\EncryptDatabaseProvider::class,

Publish the config file

php artisan vendor:publish --tag=laravel-database-encryption

Usage

Just use the trait on yours encryptables models and list the encryptable fields.

use WellingtonCarneiroBarbosa\EncryptDatabase\Traits\EncryptableModel;

class User extends Authenticable
{
    Use HasFactory,
        EncryptableModel;
        
    /**
    * The attributes that should be encrypted.
    *
    * @var array
    */
    protected $encryptable = [
        'name',
        'email',
        'birth_date',
    ];
}

public function setNameAttribute(string $value)
{
  $value = ucwords($value);
  
  $this->attributes['name'] = $this->encrypt('name', $value);
}

public function getNameAttribute()
{
  $decrypted = $this->decrypt('name', $this->attributes['name']);

  $value = strtolower($decrypted);
  
  return $value;
}

If you are validating your form data with unique or exists you should replace it to unique_encrypted and exists_encrypted respectively