1 files changed, 111 insertions, 0 deletions
diff --git a/php/database.php b/php/database.php
new file mode 100644
index 0000000..934aafa
--- /dev/null
+++ b/php/database.php
@@ -0,0 +1,111 @@
+<?php 
+require_once "configuration.php";
+require_once "user.php";
+require_once "misc.php";
+
+/*handles database stuff*/
+	class Database
+	{
+		private $pdo;
+
+
+		public function __construct()
+		{
+			global $domain_name;
+			global $database_name;
+			global $database_username;
+			global $database_password;
+			global $database_location;
+			try
+			{
+				$this->pdo=new PDO("mysql:dbname={$database_name};host={$database_location}",$database_username,$database_password);
+			}catch(PDOException $e)
+			{
+				error_log("Could not get database {$database_name} from {$database_location}, {$e} ");
+				die("The cow bought the farm");
+			}
+		}
+
+		/*returns false if this isn't a user, otherwise returns the userid*/
+		function get_user(string $user) 
+		{
+			$ret=new User;
+
+			$prep=$this->pdo->prepare("select user_id,username,email from users where username=:username");
+			$prep->bindParam(':username',$user);
+
+			$prep->execute();
+
+			$hold=$prep->fetch(PDO::FETCH_ASSOC);
+
+			if($hold)
+			{
+				$ret->user_id=$hold["user_id"];
+				$ret->username=$hold["username"];
+				$ret->email_address=$hold["email"];
+				return $ret;
+			}else
+			{
+				return false;
+			}
+		}
+		/*returns false if this isn't a user or the password is incorrect, otherwise returns the userid*/
+		function authenticate(string $user, string $password) 
+		{
+			$ret=new User;
+			global $password_hash_algo;
+			
+
+
+			$hashed_pass=password_hash($password,$password_hash_algo);
+			$prep=$this->pdo->prepare("select user_id,username,email from users where username=:username and password=:password");
+			$prep->bindParam(':username',$user);
+			$prep->bindParam(':password',$hashed_pass);
+
+			$prep->execute();
+
+			$hold=$prep->fetch(PDO::FETCH_ASSOC);
+			if($hold)
+			{
+				$ret->user_id=hold["user_id"];
+				$ret->username=hold["username"];
+				$ret->email_address["email"];
+				return $ret;
+			}else
+			{
+				return false;
+			}
+		}
+		/*returns false if username is taken, email is not checked here*/
+		function register_user(string $user,string $password,string $email) : bool
+		{
+			$hold=$this->get_user($user);
+			global $domain_name;
+			global $has_email_verification;
+			global $password_hash_algo;
+
+
+			if($hold)
+			{
+				return false;
+			}else
+			{
+				if($has_email_verification)
+				{
+					generate_email_verification_link();
+				}else
+				{
+					$hashed_pass=password_hash($password,$password_hash_algo);
+					$prep=$this->pdo->prepare("insert into users(username,password,email) values(:username,:password,:email)");
+					$prep->bindParam(':username',$user);
+					$prep->bindParam(':password',$hashed_pass);
+					$prep->bindParam(':email',$email);
+					$prep->execute();
+				}
+				return true;
+			}
+		}
+	}
+
+
+?>