<?php

if (isset($_POST["likegamer"])){
	$gamerlike=$_POST['gamerlike'];

	//$checkgamerlike = "SELECT reviewid FROM thumbsupgamer WHERE id ='" . $_SESSION["id"] . "'";  //Looks to find an username on the database identical to the one typed in to fetch all details
	//$checkgamerlike =  $database->query($checkgamerlike);
	//$checkgamerliked = mysqli_fetch_array($checkgamerlike);

	$checkgamerlike = $conn->prepare("SELECT reviewid FROM thumbsupgamer WHERE id ='" . $_SESSION["id"] . "'"); //find session id on session table equal to the studentid
	$checkgamerlike->execute();
	while ($checkgamerliked = $checkgamerlike->fetch(PDO::FETCH_ASSOC)){
		if ($checkgamerliked['reviewid'] == $gamerlike){
			echo "You've already liked this review";
		}else{
			$checksamerev = "SELECT id FROM gamerreviewdb WHERE reviewid ='" . $gamerlike . "'";  //Looks to find an username on the database identical to the one typed in to fetch all details
			$checksamerev =  $database->query($checksamerev);
			$checksamereviewer = mysqli_fetch_array($checksamerev);
			IF($checksamereviewer ["id"] == $_SESSION["id"])
			{
				echo "You can't like your own review";
			}
			else
			{
				$getmax = mysql_query("SELECT MAX(likes) FROM gamerreviewdb WHERE reviewid = '" . $gamerlike . "'"); //Sql search to detect the highest session number adding 1 to produce an unqiue number
				while ($max = mysql_fetch_assoc($getmax)) {
				$gamerlikes = $max['MAX(likes)'] + 1;
				}

				$sql = "UPDATE gamerreviewdb SET likes='" . $gamerlikes . "' WHERE reviewid = '" . $gamerlike . "'";
				$sql=mysql_query($sql);

				$thumbsupgamer = "INSERT INTO thumbsupgamer(reviewid, id, liked)";
				$thumbsupgamer .= "VALUES (".$gamerlike.", '".$_SESSION['id']."', 'Y')";
				$thumbsupgamer=mysql_query($thumbsupgamer);
				echo "Review has been liked";
			}
        }
	}
?>