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

$product_id = $_REQUEST['product_id'];

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

//check connection
if($conn->connect_error){
    die("connection failed" .$com->connect_error);
}
$sql = "SELECT p.*,s.name store_name, s.photo store_photo, d.*
FROM store s INNER JOIN product p ON(s.id=p.store_id) LEFT JOIN deal d ON (p.id =d.product_id)
WHERE p.id={$product_id} ";

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

while($row =$result->fetch_assoc()){
    $deal = array(
        'id' => $row['id'],
        'name' => $row ['name'],
        'photo' => $row ['photo'],
        'store_name' => $row['store_name'],
        'store_photo' => $row['store_photo'],
        'price' => $row ['price'],
        'price_old' => $row['price'],
        'description' => $row ['description'],

    );
}
echo json_encode($deal);