2015年3月

Activate.Php

这个页面自动检查网址中所传入的用户的id和激活码(用户点击右键中的链接后),如果信息与数据库中存储的内容一致,将自动更新数据库中激活码一栏为Yes。

    <?php
    require('includes/config.php');
    
    //collect values from the url
    $memberID = trim($_GET['x']);
    $active = trim($_GET['y']);
    
    //if id is number and the active token is not empty carry on
    if(is_numeric($memberID) && !empty($active)){
    
        //update users record set the active column to Yes where the memberID and active value match the ones provided in the array
        $stmt = $db->prepare("UPDATE members SET active = 'Yes' WHERE memberID = :memberID AND active = :active");
        $stmt->execute(array(
            ':memberID' => $memberID,
            ':active' => $active
        ));
    
        //if the row was updated redirect the user
        if($stmt->rowCount() == 1){
    
            //redirect to login page
            header('Location: login.php?action=active');
            exit;
    
        } else {
            echo "Your account could not be activated.";
        }
    
    }
    ?>

- 阅读剩余部分 -