function updateUserPasswordByEmail($database, $email, $newPassword)
{
$hashedPassword = password_hash($newPassword, PASSWORD_DEFAULT);
$query = "UPDATE users SET password = :password WHERE email = :email";
$statement = $database->prepare($query);
$statement->bindValue(':password', $hashedPassword, PDO::PARAM_STR);
$statement->bindValue(':email', $email, PDO::PARAM_STR);
return $statement->execute();
}
function storeUserIpAddressByEmail($database, $email)
{
$IpAddress = findIP();
if (!filter_var($temp, FILTER_VALIDATE_IP)) {
$IpAddress = "0.0.0.0"; // invalid ip
}
$query = "UPDATE users SET last_login_ip= :last_login_ip WHERE email = :email";
$statement = $database->prepare($query);
$statement->bindValue(':last_login_ip', $IpAddress, PDO::PARAM_STR);
$statement->bindValue(':email', $email, PDO::PARAM_STR);
return $statement->execute();
}
function updateUserFieldByEmail($database, $email, $column, $value, $type)
{
$query = "UPDATE users SET $column = :value WHERE email = :email";
$statement = $database->prepare($query);
$statement->bindValue(':value', $value, $type);
$statement->bindValue(':email', $email, PDO::PARAM_STR);
return $statement->execute();
}
function updateUserPasswordByEmail($database, $email, $newPassword)
{
$hashedPassword = password_hash($newPassword, PASSWORD_DEFAULT);
return updateUserFieldByEmail($database, $email, 'password', $hashedPassword, PDO::PARAM_STR);
}
function storeUserIpAddressByEmail($database, $email)
{
$IpAddress = findIP();
if (!filter_var($temp, FILTER_VALIDATE_IP)) {
$IpAddress = "0.0.0.0"; // invalid ip
}
return updateUserFieldByEmail($database, $email, 'last_login_ip', $IpAddress, PDO::PARAM_STR);
}