php - Laravel - last login date and time timestamp

Question

I know there are fields automatically inserted (e.g. updated_at and created_at) but I was wondering if there is like an Eloquent method timestamp() or the Laravel way to produce timestamps?

For instance, I want to record a timestamp every time a user logs in to my system and store it into the database, so we can see each user's last login date and time details.

Answer 1

In Laravel 5.2+ (tested on 5.6 as well) the process is a little different. First, add your listener to the EventServiceProvider:

protected $listen = [
    'IlluminateAuthEventsLogin' => [
        'AppListenersLogSuccessfulLogin',
    ],
];

Then do:

php artisan event:generate

Which will create a new listener in app/Listeners. Now edit your Listener to touch the date in the last_login column in your users table:

public function handle(Login $event)
{
    $event->user->last_login = date('Y-m-d H:i:s');
    $event->user->save();
}

Make sure the Listener created by Artisan has the correct namespaces at the top. For this particular case the correct namespaces in your Listener should be:

use IlluminateAuthEventsLogin;
use IlluminateQueueInteractsWithQueue;
use IlluminateContractsQueueShouldQueue;