mtb_crm_asp/get_product_info.php

<?php
require_once 'conn.php';
checkLogin();

header('Content-Type: application/json');
$id = isset($_GET['id']) ? (int)$_GET['id'] : 0;

$sql = "SELECT p.unit, pr.price 
        FROM products p 
        LEFT JOIN price pr ON p.id = pr.productId AND pr.AreaId = 0 
        WHERE p.id = $id ORDER BY pr.num ASC LIMIT 1";

$result = mysqli_query($conn, $sql);

if ($row = mysqli_fetch_assoc($result)) {
    echo json_encode([
        'unit' => $row['unit'],
        'price' => $row['price'] ?? '0.00'
    ]);
} else {
    echo json_encode(['error' => 'Product not found']);
}
?>