<?php
require 'db.php'; // Include your database connection file

if (isset($_GET['pid'])) {
    $pid = intval($_GET['pid']); // Ensure it's an integer to prevent SQL injection

    // Using INNER JOIN to fetch package details based on product ID
    $query = "
        SELECT pa.paid, pa.name 
        FROM package pa
        INNER JOIN product p ON pa.paid = p.paid
        WHERE p.pid = $pid
    ";

    $result = $con->query($query);

    $packages = [];
    while ($row = $result->fetch_assoc()) {
        $packages[] = $row;
    }

    echo json_encode(["success" => true, "packages" => $packages]);
} else {
    echo json_encode(["success" => false, "message" => "Invalid request"]);
}
?>