<?php
	if(isset($_POST['a'])) {
		setcookie("prisCookie", $_POST['a'], time()+3600*48, "/");
		setcookie("areaCookie", $_POST['b'], time()+3600*48, "/");
		setcookie("lanCookie", $_POST['c'], time()+3600*48, "/");
	}

	if (isset($_COOKIE)){
		foreach ($_COOKIE as $cookieName => $value) {
		    $cookieName = htmlspecialchars($cookieName);
		    $value = htmlspecialchars($value);
		    $$cookieName = explode(',', $value);
		}
	}

	/*foreach($_POST as $key => $value){
		echo $key . ' ' . $value;
	}*/

	//echo "hej";
	//echo $_POST['b'];
	//echo $_POST['c'];

	//$a = $_POST['a'];
	//$prisCookie = explode(',', $a);
	//$b = $_POST['b'];
	//$areaCookie = explode(',', $b);

	$server = "mysql-2017.csc.kth.se";
	$username = "gidekull_admin";
	$password = "";
	$dbname = "gidekull";

	//$conn = mysqli_connect($server, $username, $password, $dbname);

	try {
	    $pdo = new PDO("mysql:host=$server;dbname=$dbname;charset=utf8", $username, $password);
	    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}
	catch(PDOException $e)
	{
	    echo "Misslyckad anslutning " . $e->getMessage();
	}

	//echo $kvm[0] . " " .$kvm[1];

	$sql_query = 'SELECT * FROM bostader WHERE lan = :lan0
		AND area BETWEEN :area0 AND :area1
		AND pris BETWEEN :pris0 AND :pris1
		ORDER BY ';

	if(isset($_GET['sort']) && in_array($_GET['sort'], ['lan', 'objekttyp', 'adress', 'area', 'rum', 'pris', 'avgift'])){
		$sort = $_GET['sort'];
	} else {
		$sort = 'pris';
	}
	if(isset($_GET['asc_desc']) && in_array($_GET['asc_desc'], ['ASC', 'DESC'])){
		$ASC_DESC = $_GET['asc_desc'];
	} else {
		$ASC_DESC = 'ASC';
	}

$sql_query .= $sort . ' ' . $ASC_DESC;

	//echo $sql_query . "<br>";

	//echo $prisCookie[9] . " " . $areaCookie;

	try{
	$statement = $pdo->prepare($sql_query);

	$statement->execute(['area0' => $areaCookie[0], 'area1' => $areaCookie[1], 'pris0' => $prisCookie[0]*1000, 'pris1' => $prisCookie[1]*1000, 'lan0' => $lanCookie[0]]);

	}

	catch(Exception $e){
		echo $e->getMessage();
	}
	//TODO, encode with JSON. Skicka bara med kolumn. (funkar med)

	$result = $statement->fetchAll(PDO::FETCH_ASSOC);


	foreach ($result as $key => $row) {
	    foreach ($row as $column => $value) {
	        if (in_array($column, ['pris', 'avgift', 'rum', 'area'])) {
	            $result[$key][$column] = (float) $value;
	        }
	    }
}
	echo json_encode($result, JSON_UNESCAPED_UNICODE);
	//echo json_encode($statement->fetchAll());



?>