Show sourcecode
The following files exists in this folder. Click to view.
webbsrvprg/projekt/slutprojekt/
board_random.php
board_travel.php
board_vgy.php
create_comment.php
create_post.php
create_tables.php
darkmode.js
fetch_comments.php
fetch_posts.php
fetch_posts_random.php
forgot_password.php
index.php
login.php
nav.css
nav.php
post.php
register.php
reset_password.php
sql_inject.php
verify.php
verify.php
23 lines UTF-8 Windows (CRLF)
<?php
include ('../../incl/dbconnect.php');
if (isset($_GET['token'])) {
$token = $_GET['token'];
// hämta användare med matchande token
$stmt = $dbconn->prepare("SELECT user_id FROM Users_slutprojekt WHERE email_verification_token = :token LIMIT 1");
$stmt->execute([':token' => $token]);
$user = $stmt->fetch(PDO::FETCH_ASSOC);
if ($user) {
// uppdatera användarens verifieringsstatus
$stmt = $dbconn->prepare("UPDATE Users_slutprojekt SET email_verified = 1, email_verification_token = NULL WHERE user_id = :id");
$stmt->execute([':id' => $user['user_id']]);
echo "Din e-post har verifierats. Du kan nu <a href='login.php'>logga in</a>.";
} else {
echo "Ogiltig verifieringstoken.";
}
} else {
echo "Ingen token angiven.";
}
?>