PHPackages                             phpcodersnp/laravel-database-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 & ORM](/categories/database)
4. /
5. phpcodersnp/laravel-database-encryption

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

phpcodersnp/laravel-database-encryption
=======================================

Auto Encrypt and Decrypt Database through Eloquent

1.1.0(2y ago)0385MITPHP

Since Dec 25Pushed 2y ago1 watchersCompare

[ Source](https://github.com/php-coders-np/laravel-database-encryption)[ Packagist](https://packagist.org/packages/phpcodersnp/laravel-database-encryption)[ RSS](/packages/phpcodersnp-laravel-database-encryption/feed)WikiDiscussions master Synced today

READMEChangelogDependencies (2)Versions (9)Used By (0)

Laravel Database Encryption Package
===================================

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

This package was cloned from [here](https://github.com/elgiborsolution/laravel-database-encryption) due to the original owner's inactivity.
===========================================================================================================================================

[](#this-package-was-cloned-from-here-due-to-the-original-owners-inactivity)

Package for encrypting and decrypting model attributes for Laravel using openssl
--------------------------------------------------------------------------------

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

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

[](#key-features)

- Encrypt, Decrypt database fields easily
- Minimal configuration
- Include searching encrypted data using the following: `whereEncrypted`, `orWhereEncrypted`, `orderByEncrypted`, `selectEncrypted`, `concatEncrypted`
- uses openssl for encrypting and decrypting fields

Available Methods
-----------------

[](#available-methods)

`whereEncrypted`, `orWhereEncrypted`, `orderByEncrypted`, `selectEncrypted`, `concatEncrypted`

Usage
-----

[](#usage)

### `whereEncrypted`, `orWhereEncrypted`

[](#whereencrypted-orwhereencrypted)

```
whereEncrypted('first_name','john')
orWhereEncrypted('last_name','!=','Doe')
```

### `orderByEncrypted`

[](#orderbyencrypted)

```
orderByEncrypted('last_name','asc')
orderByEncrypted('last_name','desc')
```

### `selectEncrypted`

[](#selectencrypted)

```
selectEncrypted([
    "first_name as userFirstName",
    "last_name",
    ]) // array only
```

### `concatEncrypted`

[](#concatencrypted)

```
concatEncrypted('first_name , " " ,last_name AS fullUserName')
```

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

[](#requirements)

- Laravel: >= 5
- PHP: >= 7.3

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 phpcodersnp/laravel-database-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' => [
    ...
    \PHPCodersNp\DBEncryption\Providers\DBEncryptionServiceProvider::class,
],
```

### Step 3: Publish the config file using the following Artisan command:

[](#step-3-publish-the-config-file-using-the-following-artisan-command)

```
php artisan vendor:publish --provider="PHPCodersNp\DBEncryption\Providers\DBEncryptionServiceProvider"
```

For Lumen Projects
------------------

[](#for-lumen-projects)

### Configure Config File

[](#configure-config-file)

```
cp vendor/phpcodersnp/laravel-database-encryption/src/Config/config.php config/laravelDatabaseEncryption.php
```

### Register Config and Package

[](#register-config-and-package)

Copy below code and paste it in bootstrap/app.php

```
$app->configure('laravelDatabaseEncryption');
```

```
$app->register(PHPCodersNp\DBEncryption\Providers\DBEncryptionServiceProvider::class);
```

Usage
-----

[](#usage-1)

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 PHPCodersNp\DBEncryption\Traits\EncryptedAttribute;

class User extends Eloquent {
    use EncryptedAttribute;

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

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

### Encrypt your current data

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

If you have current data in your database you can encrypt it with this command:

```
php artisan encryptable:encryptModel 'App\Models\User'
```

Additionally you can decrypt it using this command:

```
php artisan encryptable:decryptModel 'App\Models\User'
```

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

```
$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 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')
        ->first();
```

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

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)[DustApplication/laravel-database-model-encryption](https://github.com/DustApplication/laravel-database-model-encryption.git)[elgiborsolution/laravel-database-encryption](https://github.com/elgiborsolution/laravel-database-encryption)

License
-------

[](#license)

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

###  Health Score

24

—

LowBetter than 31% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity13

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity48

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% 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 ~5 days

Total

8

Last Release

884d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/b5612d9c2b6b73d28280c4112b20f6a32dd9749eaf3c6943678a47ea859523fd?d=identicon)[phpcodersnp](/maintainers/phpcodersnp)

---

Top Contributors

[![php-coders-np](https://avatars.githubusercontent.com/u/92304289?v=4)](https://github.com/php-coders-np "php-coders-np (24 commits)")

---

Tags

eloquentencryptionencryption-decryptionlaravel

###  Code Quality

TestsPHPUnit

### Embed Badge

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

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

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k117.2M117](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

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