i inserted last_login field inside user table , put $update query in dologin.php not update timestamp in database when user logs in. there missing?
$update = "update `user` set last_login = now() id='user_id'"; $row = mysqli_fetch_array($result); $_session['user_id'] = $row['id']; $_session['username'] = $row['user_name']; $_session['email'] = $row['email_address']; $_session['gender'] = $row['gender_id']; $_session['role_id'] = $row['role_id']; $msg1 = $_session['username']; $msg2 = "gender: " . $_session['gender'] . "<br/>"; $msg3 = "email: " . $_session['email'] . "<br/>"; $msg .= "you logged in " . $_session['role_type'] . "<br/>";
see added mysqli_query($update);
next query
$update = "update `user` set last_login = now() id='user_id'"; mysqli_query($update); $row = mysqli_fetch_array($result); $_session['user_id'] = $row['id']; $_session['username'] = $row['user_name']; $_session['email'] = $row['email_address']; $_session['gender'] = $row['gender_id']; $_session['role_id'] = $row['role_id']; $msg1 = $_session['username']; $msg2 = "gender: " . $_session['gender'] . "<br/>"; $msg3 = "email: " . $_session['email'] . "<br/>"; $msg .= "you logged in " . $_session['role_type'] . "<br/>";
Comments
Post a Comment