include 'config_file.php';
	require 'puzzle_record.php';
	$puzzle_records = array();
    $message = '';
    $connection = new mysqli($host_name, $host_user, $host_password, $database_name);	
    if ($connection->connect_error)
    {
        die("Connection failed: " . $connection->connect_error);
    }
    $json = json_decode(file_get_contents('php://input'), true);
	$puzzle = $json[puzzle];
	echo json_encode($puzzle);
    $check_query = "SELECT * FROM puzzle_records WHERE puzzle = $json[puzzle] ORDER BY steps ASC";
    $result = $connection->query($check_query);
    if ($result->num_rows > 0) //records exist, view
    {
		$text = "In the if!";
		echo json_encode($text);
		for($i=0; $i < $result->num_rows; $i++)
		{
			$row = $result->mysqli_fetch_assoc();
			$new_puzzle_record = new puzzle_record();
			$new_puzzle_record->id = $row[id];
			$new_puzzle_record->email = $row[email];
			$new_puzzle_record->puzzle = $row[puzzle];
			$new_puzzle_record->steps = $row[steps];
			$new_puzzle_record->times = $row[times];
			$puzzle_records[] = new_puzzle_record;
		}
		$outputArr = array();
		$outputArr['puz']=json_encode($puzzle_records);
		$connection->close();
    }
	else
	{
		$text = "No data exists!";
		echo json_encode($text);
		$connection->close();
	}