Last login not showing correctly.

[rvdveen27]

Hello everyone. 

 

With my current coding on the login page, it seems to only set the last logged in date per month, which results in the following:

 

 

 

It seems to set the date logged in only once per month. It's always on the 15th of a month, however the times are all different times. I don't understand why it only sets the dates to the 15th of each month rather then just the actual date a user logged in on? 

 

This is my current code: 

if($login_ok) 
			{ 
				if($row2['status'] == 0) 
				{
					if($row['suspended'] == 1)
					{
						header("Location: usersuspended.php"); 
						exit;
					} 
					else
					{
						unset($row['salt']); 
						unset($row['password']); 
						$_SESSION['loggedin'] = 1;
						$_SESSION['user'] = $row; 
						$_SESSION['username'] = $_POST['username'];
						$_SESSION['adminlevel'] = $adminlevel;
						$_SESSION['userid'] = $userid;
						$_SESSION['verifypend'] = $verifypend;
						$_SESSION['donator'] = $donator;
						
						$query = " 
							UPDATE users 
								SET lastlogged = :date
							WHERE 
								username = :username 
						"; 
						 
						$query_params = array( 
							':date' => date('Y-m-y H:i:s'),
							':username' => $_POST['username'] 
						); 
						 
						try 
						{ 
							$stmt = $db->prepare($query); 
							$result = $stmt->execute($query_params); 
						} 
						catch(PDOException $ex) 
						{ 

							die("Failed to run query: " . $ex->getMessage()); 
						}

[boompa]

Might want to double-check the argument to date in this line:

 

':date' => date('Y-m-y H:i:s'),

[rvdveen27]

Might want to double-check the argument to date in this line:

 

':date' => date('Y-m-y H:i:s'),

 

It seems correct to me? http://php.net/manual/en/function.date.php

[scootstah]

Y-m-y is 4 digit year, 2 digit month, 2 digit year. You want Y-m-d

[rvdveen27]

Y-m-y is 4 digit year, 2 digit month, 2 digit year. You want Y-m-d

 

Oh god, I'm super blind. So sorry >.<