<?php
$user = "root";
$pass = "";
$host = "localhost";
$dbname = "neardeal";

$lat = $_REQUEST['lat'];
$lng = $_REQUEST['lng'];

// Create connection
$conn = new mysqli($host, $user, $pass, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT id,name, lat, lng, photo, telp, description, open_hour, address, (6371 * acos(cos(radians({$lat})) * cos(radians(lat)) ".
    "* cos(radians(lng) - radians({$lng})) + sin(radians({$lat})) * sin(radians(lat)))) AS distance ".
    " FROM store ".
    " HAVING distance <= 15 ".
    " ORDER BY distance ";

$result = $conn->query($sql);

$data = array();

while($row = $result->fetch_assoc()) {
    $data[] = $row;
}

echo json_encode(array(
    'success' => true,
    'store' => $data
));