I have store information in MySQL table with PHP (Laravel) encrypted string, now how I can sort it using MySQL query in Laravel.
ex. The first name is store in the database with PHP encrypted string now I do sorting the first name from the database when getting the number of records.
Use eloquent's accessor feature.
Example:
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Crypt;
class User extends Model
{
/**
* Get the user's first name.
*
* @param string $value
* @return string
*/
public function getFirstNameAttribute($value)
{
return Crypt::decryptString($value);
}
}
Then you can easily sort using collection's sorting.
Example:
User::all()->sortBy('first_name');