fds

<?php

	class DatabaseController {


		public $handle;

		public function getHandler() {
			return $this->handle;
		}

		public function connectToDatabase($address, $username, $password, $databaseName) {

			$this->handle = mysqli_connect($address, $username, $password, $databaseName);
			if(!$this->handle) {
				die("I can't connect to database. Error: " . mysqli_connect_error());
				return false;
			} else
				return true;

		}

		public function disconnectFromDatabase($handle) {
			mysqli_close($handle);
		}

		public function signIn($handle, $username, $password) {
			$stmt = $handle->prepare("SELECT username, password FROM user WHERE username = ? && password = ?");
			$stmt->bind_param('ss', $username, $password);
			$stmt->execute();
			$result = $stmt->get_result();
/*			if ($data = $result->fetch_assoc()) {
				return $data;
			} else {
				return false;
			}*/
			$data = $result->fetch_assoc();
			return $data;

		}

		public function register($handle, $username, $password) {

			$stmt = $handle->prepare("INSERT INTO user (username, password) VALUES(?, ?)");
			$stmt->bind_param("ss", $username, $password);
			$stmt->execute();

			if($handle->affected_rows > 0) {
				return true;
			} else {
				return false;
			}

		}

		public function addVideo($handle, $user, $videoPath, $videoThumbnail, $videoExtension, $videoResolution, $videoTitle, $videoDescription) {
			$null = NULL;
			$stmt = $handle->prepare("INSERT INTO video (user, videoPath, videoThumbnail, videoExtension, videoResolution, videoTitle, videoDescription) VALUES (?, ?, ?, ?, ?, ?, ?)");
			$stmt->bind_param("ssbssss", $user, $videoPath, $null, $videoExtension, $videoResolution, $videoTitle, $videoDescription);
			$stmt->send_long_data(2, $videoThumbnail);
			$stmt->execute();
			if($handle->affected_rows > 0)
				return true;
			else
				return false;

		}

		public function getUserVideos($handle, $username) {
			$stmt = $handle->prepare("SELECT videoPath, videoThumbnail, videoExtension, videoResolution, videoTitle, videoDescription FROM video WHERE user = ?");
			$stmt->bind_param('s', $username);
			$stmt->execute();

			$result = $stmt->get_result();

			if($data = $result->fetch_all(MYSQLI_ASSOC)) {
				return $data;
			} else {
				return false;
			}
		}

		public function getAllVideos($handle)  {

			$stmt = $handle->prepare("SELECT videoPath, videoThumbnail, videoExtension, videoResolution, videoTitle, videoDescription FROM video");
			$stmt->execute();

			$result = $stmt->get_result();

			if($data = $result->fetch_all(MYSQLI_ASSOC)) {
				return $data;
			} else {
				return false;
			}

		}

	}

?>