File: C:/xampp/htdocs/PBN/activate.php
<?php
require_once("dbcontroller.php");
$db_handle = new DBController();
$mail=$_GET["email"];
$name=$_GET["name"];
if(!empty($_GET["id"])) {
$query = "UPDATE registered_users set status = 'active' WHERE id='" . $_GET["id"]. "'";
$result = $db_handle->updateQuery($query);
if(!empty($result)) {
$message = $_GET["name"]."'s account is activated.";
} else {
$message = "Problem in account activation.";
}
}
?>
<html>
<head>
<title>PHP User Registration Form</title>
<link href="style.css" type="text/css" rel="stylesheet" />
</head>
<body>
<?php if(isset($message)) { ?>
<div class="message"><?php echo $message; ?></div>
<?php } ?>
<a href="./Notify.php?email= <?php echo $mail."&name=".$name;?>"><br>Click here to notify the user.</a>
</body></html>