PHPackages                             dustapplication/laravel-database-model-encryption - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database &amp; ORM](/categories/database)
4. /
5. dustapplication/laravel-database-model-encryption

ActiveLibrary[Database &amp; ORM](/categories/database)

dustapplication/laravel-database-model-encryption
=================================================

Provides database encryption/decryption with search encrypted fields.

0.3.18.12(6y ago)11.9k2[2 issues](https://github.com/DustApplication/laravel-database-model-encryption/issues)[1 PRs](https://github.com/DustApplication/laravel-database-model-encryption/pulls)MITPHPPHP &gt;=7.1

Since Jul 26Pushed 5y agoCompare

[ Source](https://github.com/DustApplication/laravel-database-model-encryption)[ Packagist](https://packagist.org/packages/dustapplication/laravel-database-model-encryption)[ RSS](/packages/dustapplication-laravel-database-model-encryption/feed)WikiDiscussions master Synced today

READMEChangelogDependencies (1)Versions (13)Used By (0)

Laravel DB Encryption Package
=============================

[](#laravel-db-encryption-package)

Package for encrypting and decrypting model attributes for Laravel using Laravel's Crypt
----------------------------------------------------------------------------------------

[](#package-for-encrypting-and-decrypting-model-attributes-for-laravel-using-laravels-crypt)

Most of client wanted to encrypt their database. So encase a person got access to database, they won't see the actual data of it. BUT the problem is, developers will have difficulty searching encrypted data when they need it.

The purpose of this project is to create a set-it-and-forget-it package that can be installed without much effort to encrypt and decrypt Eloquent model attributes stored in your database tables, and most of all able to search encrypted database fields using `whereEncrypted` and `orWhereEncrypted` functions similar to laravel eloquent's `where` and `orWhere`.

Key Features
------------

[](#key-features)

- Encrypt, Decrypt database fields easily
- Minimal configuration
- Include searching encrypted data using the following: `whereEncrypted` and `orWhereEncrypted`
- uses Laravel's Facades `Crypt` for encrypting and decrypting fields

Requirements
------------

[](#requirements)

- Laravel: 5.5, 5.6, 5.7, or 5.8
- PHP: 5.6 Above

Schema Requirements
-------------------

[](#schema-requirements)

Encrypted values are usually longer than plain text values, sometimes much longer. You may find that the column widths in your database tables need to be altered to store the encrypted values generated by this package.

We highly recommend to alter your column types to `TEXT` or `LONGTEXT`

Installation
------------

[](#installation)

### Step 1: Composer

[](#step-1-composer)

Via Composer command line:

```
$ composer require dustapplication/laravel-database-model-encryption
```

### Step 2: Add ServiceProvider to your app/config.php file (Laravel 5.4 or below)

[](#step-2-add-serviceprovider-to-your-appconfigphp-file-laravel-54-or-below)

Add the service provider to the providers array in the config/app.php config file as follows:

```
    'providers' => [
        ...
        \DustApplication\Encryption\Providers\EncryptServiceProvider::class,
    ],
```

Usage
-----

[](#usage)

Use the `EncryptedAttribute` trait in any Eloquent model that you wish to apply encryption to and define a `protected $encrypted` array containing a list of the attributes to encrypt.

For example:

```

    use DustApplication\Encryption\Traits\EncryptedAttribute;

    class User extends Eloquent {
        use EncryptedAttribute;

        /**
         * The attributes that should be encrypted on save.
         *
         * @var array
         */
        protected $encryptable = [
            'first_name', 'last_name'
        ];
    }
```

By including the `EncryptedAttribute` trait, the `setAttribute()`, `getAttribute()` and `getAttributeFromArray()`methods provided by Eloquent are overridden to include an additional step.

### Searching Encrypted Fields Example:

[](#searching-encrypted-fields-example)

Searching encrypted field can be done by calling the `whereEncrypted` and `orWhereEncrypted` functions similar to laravel eloquent `where` and `orWhere`.

```
    namespace App\Http\Controllers;

    use App\User;
    class UsersController extends Controller {
        public function index(Request $request)
        {
            $user = User::whereEncrypted('first_name','john')
                        ->orWhereEncrypted('last_name','!=','Doe')->firstOrFail();

            return $user;
        }
    }
```

#### NOTE:

[](#note)

The use of encryption searching is recommended for small group of data. Using it on large amount of data rows will affects the performance.

### Encrypt your current data

[](#encrypt-your-current-data)

If you have current data in your database you can encrypt it with the: `php artisan encryptable:encryptModel 'App\User'` command.

Additionally you can decrypt it using the: `php artisan encryptable:decryptModel 'App\User'` command.

Note: You must implement first the `Encryptable` trait and set `$encryptable` attributes

### Exists and Unique Validation Rules

[](#exists-and-unique-validation-rules)

If you are using exists and unique rules with encrypted values replace it with exists\_encrypted and unique\_encrypted `php       $validator = validator(['email'=>'foo@bar.com'], ['email'=>'exists_encrypted:users,email']); $validator = validator(['email'=>'foo@bar.com'], ['email'=>'unique_encrypted:users,email']); `

Frequently Asked Question
-------------------------

[](#frequently-asked-question)

#### Can I use other encryption other than crypt?

[](#can-i-use-other-encryption-other-than-crypt)

No for now, but we may include it on next update

#### Can I search encrypted data?

[](#can-i-search-encrypted-data)

YES! You will able to search on attributes which are encrypted by this package because. If you need to search on data then use the `whereEncrypted` and `orWhereEncrypted` function:

```
    User::whereEncrypted('email','test@gmail.com')->orWhereEncrypted('email','test2@gmail.com')->firstOrFail();

```

It will automatically added on the eloquent once the model uses `EncryptedAttribute`

#### Can I encrypt all my `User` model data?

[](#can-i-encrypt-all-my-user-model-data)

Aside from IDs you can encrypt everything you wan't

For example: Logging-in on encrypted email

```
$user = User::whereEncrypted('email','test@gmail.com')->filter(function ($item) use ($request) {
        return Hash::check($password, $item->password);
    })->where('active',1)->first();

```

Credits
-------

[](#credits)

This package was inspired from the following: [austinheap/laravel-database-encryption](https://github.com/austinheap/laravel-database-encryption)[magros/laravel-model-encryption](https://github.com/magros/laravel-model-encryption)

License
-------

[](#license)

The MIT License (MIT). Please see [License File](LICENSE.md) for more information.

###  Health Score

22

—

LowBetter than 25% of packages

Maintenance0

Infrequent updates — may be unmaintained

Popularity19

Limited adoption so far

Community10

Small or concentrated contributor base

Maturity50

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 65% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~1 days

Total

12

Last Release

2419d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/3730f86ca20b2a29ecb6a256cb15ec73547f7a2215493c8cfeb18ace18b27f37?d=identicon)[JoeselDuazo](/maintainers/JoeselDuazo)

---

Top Contributors

[![vincentkristoffer](https://avatars.githubusercontent.com/u/25742605?v=4)](https://github.com/vincentkristoffer "vincentkristoffer (26 commits)")[![DustApplication](https://avatars.githubusercontent.com/u/48473392?v=4)](https://github.com/DustApplication "DustApplication (14 commits)")

---

Tags

composerlaravelencryptiondatabasemodeleloquentencryptdecryptdblaravel5cryptattributedatabase encryptiondecryptiondecryptedencryptedlaravel-encryptionlaravel55model encryptionattribute encryptionlaravel56laravel57laravel58encrypted searchencryption searchwhere encrypted

### Embed Badge

![Health badge](/badges/dustapplication-laravel-database-model-encryption/health.svg)

```
[![Health](https://phpackages.com/badges/dustapplication-laravel-database-model-encryption/health.svg)](https://phpackages.com/packages/dustapplication-laravel-database-model-encryption)
```

###  Alternatives

[betterapp/laravel-db-encrypter

Provides database model attribute encryption/decryption

366604.2k8](/packages/betterapp-laravel-db-encrypter)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)
