CODEWITHSUNDEEP
laravel
Unbreakable
Unbreakable

Reputation: 8084

How to access Session data from database

I want to access session data from database. Currently, I have changed default setting in session.php to database so that I can capture all the session columns in DB. But now I want to access these in my code. Do I need to create some session model or it's present out of the box just like user.php. Please help me.

Upvotes: 2

Views: 1788

Answers (1)

Alexey Mezenin
Alexey Mezenin

Reputation: 163768

You should create sessions table with these commands:

php artisan session:table
composer dump-autoload
php artisan migrate

Or you could manually create migration and run it, an example from documentation:

Schema::create('sessions', function ($table) {
    $table->string('id')->unique();
    $table->text('payload');
    $table->integer('last_activity');
});

After doing that, you can just use sessions as usual with Session:: facade or sessions() helper:

session()->flash('message', 'Success!');

Update

If you need to access table data directly, you could do this:

DB::table('sessions')->get();

Or you could create SessionData() model and do this:

SessionData::all();

Upvotes: 5

Related Questions