<?header("Access-Control-Allow-Origin: *");  //make page public
include "conninfo.php";
$query="SELECT firstname,surname,course,photo FROM staff ORDER BY surname";
$result=mysqli_query($link,$query);

$encode = array();

while($row = mysqli_fetch_assoc($result)) 
{
   $encode[] = $row;
}
echo "{\"staff\" : ";

echo json_encode($encode); 

echo "}";


?>