<?php
/* Подключение конфига */
require_once "../config/config.php";

$isCorrect = false;
$neededID;

$db_getter = new mysqli(DATABASE_HOST, LEARNIT_DB_GETTER_NAME, LEARNIT_DB_GETTER_PASSWORD, DATABASE_NAME);
$neededLink = $db_getter->query("SELECT id, activation_link FROM activatedaccs");
while($row = $neededLink->fetch_assoc()) {
    $link = "http://{$_SERVER[HTTP_HOST]}{$_SERVER[REQUEST_URI]}";
    if($row["activation_link"] == $link) {
        echo "Есть совпадения!";
        $isCorrect = true;
        $neededID = $row["id"];
    }
}
$db_getter->close();
$neededLink->close();

if($isCorrect and $neededID) {
    $db_setter = new mysqli(DATABASE_HOST, LEARNIT_DB_SETTER_NAME, LEARNIT_DB_SETTER_PASSWORD, DATABASE_NAME);
    $update = $db_setter->prepare("UPDATE activatedaccs SET activated = true WHERE id = ?");
    $update->bind_param('i', $neededID);
    $update->execute();
    $update->close();
    $db_setter->close();
}
?>