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

$store_id = $_REQUEST['store_id'];

//create connection
$conn = new mysqli($host, $user, $pass, $dbnamne);

//check connection
if($conn->connect_error){
    die("connection failed" .$com->connect_error);
}

//[nama formula menghitung 2 titik koordinat : mysql great circle distance]

//$sql = "SELECT * FROM store";
$sql = "SELECT *FROM product WHERE store_id={$store_id}";

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

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

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