<?php

header('Content-Type: application/json');
header('Access-Control-Allow-Origin: *');

$data = json_decode(file_get_contents("php://input"),true);

$categoryID = $data['category'];
$stateID = $data["state"];
$cityID = $data["cityFordisplay"];

include 'config.php';

$sql = "SELECT 
tblshowroom_dealer.s_dealer_name, 
tblshowroom_dealer.s_address, 
tblshowroom_dealer.s_pincode, 
tblshowroom_dealer.s_contact,
tblworkshop_dealer.w_dealer_name,
tblworkshop_dealer.w_address,
tblworkshop_dealer.w_pincode,
tblworkshop_dealer.w_contact
FROM 
tblshowroom_dealer 
JOIN 
tblworkshop_dealer 
ON 
tblshowroom_dealer.s_state_id = tblworkshop_dealer.w_state_id AND
tblshowroom_dealer.s_city_id = tblworkshop_dealer.w_city_id AND
tblshowroom_dealer.s_category_id = tblworkshop_dealer.w_category_id 
WHERE 
tblshowroom_dealer.s_city_id = $cityID 
AND tblshowroom_dealer.s_state_id = $stateID 
AND tblshowroom_dealer.s_category_id = $categoryID";
$result = mysqli_query($con, $sql) or die("sql Query fail");

if (mysqli_num_rows($result) > 0) {
  $output = mysqli_fetch_all($result, MYSQLI_ASSOC);
  echo json_encode($output);
} else {
    echo json_encode(array('message' => 'No record found', 'status' => false));
}

?>