public function getInfoRoom($room)
	{

		$sql = "SELECT 
    g.firstname, 
    g.lastname, 
    c.date_in, 
    c.date_out
FROM checkins c
JOIN rooms r ON c.roomid = r.id
JOIN guests g ON c.guestid = g.id
WHERE r.name = '".$room."'  
ORDER BY `c`.`id`  DESC limit 1";


		$result = $this->conn->query($sql);
		$myarr = array();

		if ($result->num_rows > 0) {
			// output data of each row

			while ($row = $result->fetch_assoc()) {
				$myarr[] = $row;
			}
		} else {
			//echo "0 results";
			$myarr = array('reponse' => false);
		}

		$myarr = json_decode(json_encode($myarr));

		return $myarr;
	}
	
			public function getInfoRoom($room)
	{

		$sql = "SELECT 
    g.firstname, 
    g.lastname, 
    c.date_in, 
    c.date_out
FROM checkins c
JOIN rooms r ON c.roomid = r.id
JOIN guests g ON c.guestid = g.id
WHERE r.name = '".$room."'  
ORDER BY `c`.`id`  DESC limit 1";


		$result = $this->conn->query($sql);
		$myarr = array();

		if ($result->num_rows > 0) {
			// output data of each row

			while ($row = $result->fetch_assoc()) {
				$myarr[] = $row;
			}
		} else {
			//echo "0 results";
			$myarr = array('reponse' => false);
		}

		$myarr = json_decode(json_encode($myarr));

		return $myarr;
	}