<?php
$position = '';
if(isset($_GET['position']))
	$position = $_GET['position'];

$dbconn = mysqli_connect("localhost", "root", "", "liverpool");
if ($dbconn->connect_error > 0)
{
	die("cannot connect to db");
	exit();
}

$sql = $dbconn->prepare("SELECT playerid, positions, firstname, lastname, playerage, nationality, kitnumber, appearances, goals, signed  from midfielders");
$sql->execute();
$result = $sql->get_result();

$playerarray = array();
if($sql->affected_rows == 0)
{
	http_response_code(404);
	echo json_encode(
		array("message" => "No players found")
	);
}
else
{
	while($row = $result->fetch_assoc())
	{
		$playerarray[] = $row;
	}
	http_response_code(200);
	header('Content-Type: application/json');
	header('Access-Control-Allow-Origin: *');
	header('Access-Control-Allow-Methods: GET, PUT, POST, DELETE, OPTIONS');
	header('Access-Control-Allow-Headers: Content-Type, Content-Range, Content-Disposition, Content-Description');
	$result = [
		'message' => 'Success',
		'playerlist' => $playerarray,
	];
	echo json_encode($result, JSON_PRETTY_PRINT);	
	
}
?>