web_php/hotel_booking/email_confirm.php

27 lines
No EOL
1.1 KiB
PHP

<?php
require('admin/components/utils.php');
require('admin/components/db_config.php');
if(isset($_GET['email_confirmation'])){
$data = filteration($_GET);
$query = select("SELECT * FROM `user_creds` WHERE `email`=? AND `token`=? LIMIT 1", [$data['email'], $data['token']], 'ss');
if(mysqli_num_rows($query) == 1){
$fetch = mysqli_fetch_assoc($query);
if($fetch['is_verified'] == 1){
echo "<script>alert('Your email is already verified.')</script>";
} else{
$update = update("UPDATE `user_creds` SET `is_verified`=? WHERE `id`=?", [1, $fetch['id']], 'ii');
if($update){
echo "<script>alert('Your email was successfully verified.')</script>";
} else{
echo "<script>alert('Fail to verify your email')</script>";
}
}
redirect('index.php');
} else{
echo "<script>alert('Invalid link!')</script>";
redirect('index.php');
}
}
?>