Download the PHP package phpcodersnp/laravel-database-encryption without Composer
On this page you can find all versions of the php package phpcodersnp/laravel-database-encryption. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download phpcodersnp/laravel-database-encryption
More information about phpcodersnp/laravel-database-encryption
Files in phpcodersnp/laravel-database-encryption
Package laravel-database-encryption
Short Description Auto Encrypt and Decrypt Database through Eloquent
License MIT
Informations about the package laravel-database-encryption
Laravel Database Encryption Package
This package was cloned from here due to the original owner's inactivity.
Package for encrypting and decrypting model attributes for Laravel using openssl
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
whereEncrypted
, orWhereEncrypted
, orderByEncrypted
, selectEncrypted
, concatEncrypted
Usage
whereEncrypted
, orWhereEncrypted
orderByEncrypted
selectEncrypted
concatEncrypted
Requirements
- Laravel: >= 5
- PHP: >= 7.3
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
Step 1: Composer
Via Composer command line:
Step 2: Add ServiceProvider to your app/config.php file (Laravel 5.4 or below)
Add the service provider to the providers array in the config/app.php config file as follows:
Step 3: Publish the config file using the following Artisan command:
For Lumen Projects
Configure Config File
Register Config and Package
Copy below code and paste it in bootstrap/app.php
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:
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
If you have current data in your database you can encrypt it with this command:
Additionally you can decrypt it using this command:
Note: You must implement first the Encryptable
trait and set $encryptable
attributes
Exists and Unique Validation Rules
If you are using exists and unique rules with encrypted values replace it with exists_encrypted and unique_encrypted
Frequently Asked Question
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:
It will automatically added on the eloquent once the model uses EncryptedAttribute
Credits
This package was inspired from the following: austinheap/laravel-database-encryption magros/laravel-model-encryption DustApplication/laravel-database-model-encryption elgiborsolution/laravel-database-encryption
License
The MIT License (MIT). Please see License File for more information.