. */ define('ROOT', rtrim($_SERVER['DOCUMENT_ROOT'], '/') . '/'); require_once ROOT . '/php/session.php'; require_once ROOT . '/php/database.php'; if ($_SERVER["REQUEST_METHOD"] == "POST") { $code = $_POST['code']; $user_id = get_user_id(); if (!$user_id) { echo "Not logged in."; exit; } try { $sql = "SELECT verification_code FROM users WHERE id = :id"; $user = fetch_row($sql, ['id' => $user_id]); if (!$user) { echo "User not found."; exit; } $real_code = $user['verification_code']; } catch (\PDOException $e) { echo "Error: " . $e->getMessage(); exit; } if ($user['status'] == 'none') { echo "Account is already verifed"; exit; } if ($code != $real_code) { echo "Code is not correct!"; exit; } try { $sql = "UPDATE users SET verification_code = :code, status = :status WHERE id = :id"; $statement = query($sql, [ 'code' => '0000', 'status' => 'member', 'id' => $user_id ]); if ($statement->rowCount() == 0) { echo "User not found."; } } catch (\PDOException $e) { echo "Error: " . $e->getMessage(); exit; } header("Location: /signin/"); } ?>