User.class.php

<?php

class User {
	
	private $connection;
	//käivitab siia kui on =new User(see jõuab siia)
	function __construct($mysqli){
		
		$this->connection = $mysqli;
	}
	
	
	//siia kõik funktsioonid 
	
	function login($email, $password) {
		
		$notice = "";
			
		$stmt = $this->connection->prepare("
			SELECT id, email, password, created
			FROM user_sample
			WHERE email = ?
		");
		
		echo $this->connection->error;
		
		//asendan küsimärgi
		$stmt->bind_param("s", $email);
		
		//rea kohta tulba väärtus
		$stmt->bind_result($id, $emailFromDb, $passwordFromDb, $created);
		
		$stmt->execute();
		
		//ainult SELECT'i puhul
		if($stmt->fetch()) {
			// oli olemas, rida käes
			//kasutaja sisestas sisselogimiseks
			$hash = hash("sha512", $password);
			
			if ($hash == $passwordFromDb) {
				echo "Kasutaja $id logis sisse";
				
				$_SESSION["userId"] = $id;
				$_SESSION["userEmail"] = $emailFromDb;
				//echo "ERROR";
				
				header("Location: data.php");
				exit();
				
			} else {
				$notice = "parool vale";
			}
			
		} else {
			
			//ei olnud ühtegi rida
			$notice = "Sellise emailiga ".$email." kasutajat ei ole olemas";
		}
		
		$stmt->close();
		
		return $notice;
		
	}
	
	function signup($email, $password) {
		
	
		$stmt = $this->connection->prepare("
			INSERT INTO user_sample (email, password) 
			VALUE (?, ?)
		");
		echo $this->connection->error;
		
		$stmt->bind_param("ss", $email, $password);
		
		if ( $stmt->execute() ) {
			echo "õnnestus";
		} else {
			echo "ERROR ".$stmt->error;
		}
		
	}
	

}
?>