Laravel session table add additional column

user_898931 0
Viewed 8410

I want to add an extra column user_id on session table.

The reason is, some time there are spammer to sign up fake account, once I know that the user is spammer, I want to log the user out by deleting the session record.

Is it possible to achieve this?

laravel-4 laravel logout session
3 Answers

Short version of migration

if( Schema::hasTable('sessions') ) {
    $table->integer('user_id')->unsigned();
}

Need to check if exist session table. Or create it before:

php artisan session:table
php artisan migrate

https://laravel.com/docs/5.7/session#introduction

user_10453530

This is the session migration schema:

Schema::create('sessions', function (Blueprint $table) {
        $table->string('id')->unique();
        $table->integer('user_id')->nullable();
        $table->string('ip_address', 45)->nullable();
        $table->text('user_agent')->nullable();
        $table->text('device')->nullable();
        $table->text('payload');
        $table->integer('last_activity');
    });

To add the information to the payload after adding COLUMN to the TABLE, just change the DatabaseSessionHandler class.

path: vendor/laravel/framework/src/illuminate/Session

Ex:

1º Creates the function

protected function device()
{
    $agent = new \Jenssegers\Agent\Agent;

    if ($agent->isDesktop()){
        $device = 'desktop';
    }

    return $device;
}

2º add in function addRequestInformation (& $ payload)

protected function addRequestInformation(&$payload)
{
    if ($this->container->bound('request')) {
        $payload = array_merge($payload, [
            'ip_address' => $this->ipAddress(),
            'user_agent' => $this->userAgent(),
            'device' => $this->device(),
        ]);
    }

    return $this;
}

Ready, device added to the table when the user login.

Admin1
Related