<?php  
require_once '../../includes/conn.php';

$productId = $_POST['productId'];

$sql = "SELECT product_id, product_name, product_image, brand_id, categories_id, quantity, rate, buy_rate, active, status FROM product WHERE product_id = '$productId' and status = 1  ";
$result = $con->query($sql);

if($result->num_rows > 0) { 
 $row = $result->fetch_array();
} // if num_rows

$con->close();

echo json_encode($row);

?>