[insert_php]
$verified = isset($_GET[‘verified’])? $_GET[‘verified’] : false;
$verify = isset($_GET[‘verify’])? $_GET[‘verify’] : false;
$submit = isset($_GET[‘submit’])? $_GET[‘submit’] : false;
$servername = “localhost”;
$username = “silverpo_auth”;
$password = “,4mzF7mBre+z”;
$dbname = “silverpo_accounting”;
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}
if($submit) {
echo “Please verify your account by email” .
“
“;
} elseif ($verify) {
// Send verification email
$to = $verify;
$subject = “Silver Pond Estates”;
$txt = “An account has been registered with Silver Pond Estates for this email.” .
“To activate this account, log in using this link: https://silverpondestates.com/index.php/members-area/?verified=863727871”;
$headers = “From: verify@silverpondestates.com”;
mail($to,$subject,$txt,$headers);
echo “An email has been sent to ” . $verify .
“. Please use the link in your email to activate your account.”;
if (isset($_COOKIE[‘uname’]) && isset($_COOKIE[‘sessID’])){
$user = $_COOKIE[‘uname’];
$sessID = $_COOKIE[‘sessID’];
$sql = “UPDATE users SET email ='” . $verify . “‘”;
$sql .= ” WHERE user ='” . $user . “‘ AND sessID='” . $sessID . “‘”;
$result = $conn->query($sql);
}
} elseif ($verified) {
echo “Your account has successfully been verified.”;
}
[/insert_php]