27 lines
No EOL
1.1 KiB
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');
|
|
}
|
|
}
|
|
?>
|