<?php
$servername = "localhost";
$username = "root";
$password = "Dp6ibZWAR2vD3RiME";
$dbname = "statistics";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
mysqli_set_charset($conn,"utf8");

$final['type'] = "FeatureCollection";


$result = $conn->query("SELECT * FROM qarqet");
$i = 0;
while($row = $result->fetch_assoc()) {
    $feature[$i]['type'] = "Feature";
    $feature[$i]['geometry']['type'] = "Point";
    $feature[$i]['geometry']['coordinates'] = array((double)$row['lon'],(double)$row['lat']);
    $feature[$i]['properties']['Qarku'] = $row['qarku'];
    $feature[$i]['properties']['Raste Gjithsej'] = (int)$row['raste_gjithsej'];
    $i++;
}
$final['features'] = $feature;

header('Content-type: application/json; charset=UTF-8;');
echo json_encode($final);

$conn->close();
?>