php和mysql的持续时间？

Question

I would like to store the login, logout and duration time in database.

The name of my database is 'registration' and my tablename is 'users'.

This is the source code im using:

https://codewithawa.com/posts/complete-user-registration-system-using-php-and-mysql-database

Anyone knows how can I do this?

Answer 1

I have been testing how it is done but I get many errors with this code ... Am I on track?

session_start(); 
 $_SESSION['username']=$name; 
 date_default_timezone_set('europe/spain')
 $date=date("h:i:sa"); 
 $time=date("d-m-Y", time()); 
 $sql = "INSERT INTO users(id, username, email, password, logintime) VALUES( , , , 
 ,'$time')";