<?php
$position = '';
if(isset($_GET['position']))
	$position = $_GET['position'];

$dbconn = mysqli_connect("localhost", "root", "", "liverpoolfc");
if ($dbconn->connect_error > 0)
{
	die("cannot connect to db");
	exit();
}

$sql = $dbconn->prepare("SELECT managerid, position, firstname, lastname, age, nationality, joined from managers");
$sql->execute();
$result = $sql->get_result();

$managerarray = array();
if($sql->affected_rows == 0)
{
	http_response_code(404);
	echo json_encode(
		array("message" => "No players found")
	);
} 
else
{
	while($row = $result->fetch_assoc())
	{
		$managerarray[] = $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',
		'coachlist' => $managerarray,
	];
	echo json_encode($result, JSON_PRETTY_PRINT);	
}