Fisrt time login

[matthewchristianson]

Is it possible in PHP, or in any other language to tell when a user logs into your system for the first time, as they are given a default password and username which must be changed.

 

any help would be welcome

Thanks

[NArc0t1c]

Make a cookie on first visit, Because the client won't have teh cookie when they visit for the first time.

The second time they come, they will have the cookie, thus they have been there before.

[cluce]

Or you can create a field in your table called last_successful_login and record everytime the user logs on successfully with the NOW() function.

 

example from my web page

 

//record last login

    $sql2 = "UPDATE employees SET last_login=NOW() WHERE username = '$checkuser' LIMIT 1"; 

    mysqli_query($mysqli,$sql2);

[bbaker]

I have a community where there is a database table that has a first_login field that is empty by default.  My script is set up so that when the user logs in, it queries the database to see if the first_login filed is empty, if so, it brings them directly to the page to change their password, then inserts the timestamp into the field.  Thus, next time they sign in, they're directed to their default page.