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

$store_id = $_REQUEST['store_id'];

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

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

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

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

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

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