login

    function login() {

        if(isset($_REQUEST['anmelden']))
        {
            session_start();


            $errmsg_arr = array();
            $errflag = false;

            $dbh = $this->database_user_connect;

            // new data



            $user = $_REQUEST['a_email'];
            $password = hash('sha512',$_REQUEST['a_password']);


            // query
            $result = $dbh->prepare("SELECT * FROM user WHERE email= :email AND passwort= :passwort");
            $result->bindParam(':email', $user);
            $result->bindParam(':passwort', $password);
            $result->execute();

            $rows = $result->fetch(PDO::FETCH_NUM);
            print_r($rows);
            $url = $rows[7];

            $_SESSION['your_url'] = $url;

                if($rows > 0) {
                    header("location: ../profil.php?user=" . $url);


                }
        }
    }