How to get session values from database in laravel

Question

Here is my code

class CreateSessionsTable extends Migration
{
public function up()
    {
        Schema::create('sessions', function (Blueprint $table) {
            $table->string('id')->unique();
            $table->text('payload');
            $table->integer('last_activity');
        });
    }
    public function down()
    {
        Schema::drop('sessions');
    }
}

In config/session.php file changed 'driver' => env('SESSION_DRIVER', 'database'), In DB table was created. When user login i used below code to push values into session

Session::put('userid', $userid);
Session::put('useremail', $useremail);

Then another method i checked session

$data = Session::all();
        var_dump($data);

Its returning like this,

array (size=3)
  '_token' => string 'kD3zC2YF4v63RF1EkAVe0YoM4zLj9kGtiV4vpEzG' (length=40)
  '_previous' => 
    array (size=1)
      'url' => string 'http://localhost/Login' (length=28)
  'flash' => 
    array (size=2)
      'old' => 
...

So how to get that user values from db.

Moris · Accepted Answer · 2016-10-15 07:11:48Z

1

Which Laravel version are you using? If it's 5.3, try with the following:

//Store value
$request->session()->put('key', 'value');

//Get value
$value = $request->session()->get('key', 'valueIfItsNotReturned');

The second argument is the default value that will be returned if the key does not exist in the session.

If it doesn't work, see if you get the same problem by changing the session driver to file.

edited Oct 15, 2016 at 7:11

answered Oct 15, 2016 at 6:55

Moris

3,10318 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

saravanan mp Over a year ago

Im using Laravel 5.1

saravanan mp · Accepted Answer · 2016-10-17 10:52:30Z

1

After adding

Session::save();

Its working fine

answered Oct 17, 2016 at 10:52

saravanan mp

7833 gold badges17 silver badges37 bronze badges

Collectives™ on Stack Overflow

How to get session values from database in laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related