1#@!#!123s

��JFIF�� 1#@!#!123s

: / proc / self / root / home / earnlouq / tapnaire.live / manager /

Filename : fetch_plans.php

back

<?php
include('../../config/conn.php');

if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["country_id"])) {
    $country_id = intval($_POST["country_id"]);
    
    $query = "SELECT * FROM `plans` WHERE `country_id` = ?";
    $stmt = mysqli_prepare($con, $query);
    mysqli_stmt_bind_param($stmt, "i", $country_id);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);

    $plans = [];
    while ($row = mysqli_fetch_assoc($result)) {
        $plans[] = $row;
    }
    
    echo json_encode($plans);
}
?>