prepare("SELECT `hsn`, `cgst`, `sgst`, `igst`, `description` FROM `item_master` WHERE `item_name` = ?"); if ($stmt) { $stmt->bind_param("s", $item_name); $stmt->execute(); $stmt->bind_result($hsn, $cgst, $sgst, $igst, $description); if ($stmt->fetch()) { // echo '

';
            // print_r($hsn);
            // die();
            $response = [
                'hsn' => htmlspecialchars($hsn),
                'cgst' => htmlspecialchars($cgst),
                'sgst' => htmlspecialchars($sgst),
                'igst' => htmlspecialchars($igst),
                'description' => htmlspecialchars($description)
            ];
        } else {
            $response = ['error' => 'Item not found.'];
        }

        $stmt->close();
    } else {
        $response = ['error' => 'Failed to prepare statement.'];
    }
} else {
    $response = ['error' => 'Invalid request.'];
}

echo json_encode($response);