在laravel数据表上格式化数字

php artisan make:migration create_users_table

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateUsersTable extends Migration
{
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->integer('age');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('users');
    }
}

php artisan migrate

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class User extends Model
{
    public function getFormattedAgeAttribute()
    {
        // 格式化年龄字段
        return number_format($this->attributes['age']);
    }

    public function setAgeAttribute($value)
    {
        // 移除年龄字段中的逗号和空格
        $this->attributes['age'] = str_replace([',', ' '], '', $value);
    }
}

use App\Models\User;

$user = User::find(1);
echo $user->formatted_age; // 输出格式化后的年龄

$user->age = '1,234'; // 设置带逗号的年龄
$user->save(); // 保存时会自动移除逗号和空格