PDO将回显ID号转入SESSION

Question

This is the code i use to login a user, i want to get the id number of the user and echo it into $_SESSION['Teacher'] to use later on, i thought you could do it using $row['id'], but it seems not.. any help is appreciated.

public function verifyLogin($username, $password){
    // this function checks whether the user name exists and if its a match
    if(!empty($username) && !empty($password)){
        $st = $this->db->prepare("SELECT * FROM teachers WHERE username=? AND password=?");
        $st->bindParam(1, $username);
        $st->bindParam(2, $password);
        $st->execute();

        if ($st->rowCount() == 1){

            session_start();
            $_SESSION['Teacher'] = $row['id'];

            header("Location: dashboard.php");

        } else {

            header("Location: login.php?incorrect");
        }

    } 

}

Answer 1

$row is not being set anywhere. You have to call $st->fetch() to fetch the first row and then the assignment to $_SESSION['Teacher'] should work.