$result = $mysqli->query("SELECT verified, email, createdate FROM username = '$username' AND password = '$password' LIMIT 1");
if ($result->num_rows != 0) {
    $row = $result->fetch_assoc();
    $verified = $row['verified'];
    $email = $row['email'];
    $date = $row['createdate'];
    $date = strtotime($date);
    $date = date('M d Y', $date);

    if ($verified == 1) {
        echo "logged in";
    } else {
        echo "account not verified"
    }
}