<?php
require("config_DB.php");
//$email = "patrice.delpy@outlook.fr";
if (isset($_GET['code']))
{
$code = $_GET['code'];
// Update user status to verified
$sql = "UPDATE appli_table_users SET verified = 1 WHERE MD5(email) = '$code'";
echo $sql ."<br><br>";
if ($connexion->query($sql) === TRUE)
{
echo "Email verified successfully.";
}
else
{
echo "Error verifying email.";
}
$connexion->close();
}
?>