user.php

<?php
class UDB{
    private static $_db_username = "devside";
    private static $_db_password = "BaKaxY?3347";
    private static $_db_host = "192.168.2.105";
    private static $_db_port = "3306";
    private static $_db_name = "Devside";
    private static $_db;
    
    function __construct() {
         
        try{
            self::$_db = new PDO("mysql:host=" . self::$_db_host . ";dbname=" . self::$_db_name, self::$_db_username, self::$_db_password);
            //self::$_db = new PDO("mysql:host=" . self::$_db_host . ";mysql:port=" . self::$_db_port . ";mysql:dbname=" . self::$_db_name . ";mysql:username=" .self::$_db_username . ";mysql:passwd=" . self::$_db_password . ";");
            //self::$_db = new PDO("mysql:host=devbaka.ddns.net;dbname=Ampel", "devbaka", "Hapsoxy33");

        } catch (PDOException $e) {
          echo "Datenbankverbindung gescheitert!: " .$e->getMessage();
          die();
        }
    }
    
       
  
  public function login($usermail, $userpass){
    $iUserMail = $usermail;
    $iUserPass = $userpass;
    $rUserPass = self::userpwd($iUserMail);
    if($rUserPass[0] == $iUserPass){
        $_SESSION['user'] = $iUserMail;
        return "True";

    }
    else{
      return "False";
      //echo(emailInDatabase($iUserMail));
    }

  }
  
  
     
  public function userpwd($usermail){
    $stmt = self::$_db->prepare("SELECT user_passwd FROM users WHERE user_email=:email");
    $result = $stmt->execute(array('email' => $usermail));
    $passwd = $stmt->fetch();
    return $passwd;
    
  }

    
	public function emailInDatabase($email){ 
       $statement = self::$_db->prepare("SELECT * FROM users WHERE user_email = :email");
       $result = $statement->execute(array('email' => $email));
       $user = $statement->fetch();
       
       if($user !== false) {
          return 'Diese E-Mail-Adresse ist bereits vergeben<br>';
       } 
       
       else{
          return 'Diese E-Mail ist noch verf�gbar. <br>';
       }
  }
	
  public function UserAdd($email, $passwd, $user_vorname, $user_nachname){
    $stmt = self::$_db->prepare("INSERT INTO users (user_email, user_passwd) VALUES (:email, :passwort)");
    $result = $stmt->execute(array('email' => $email, 'passwort' => $passwd));
    return $result;
  }   
  
            
}

?>