get_product_details.php

<?php

    $response = array();

    require_once __DIR__ . '/db_connect.php';

    $db = new DB_CONNECT();

    if (isset($_GET['pid'])) {
        $pid = $_GET['pid'];
        $result = msql_query("SELECT * FROM products WHERE pid = $pid");

        if (!empty($result)) {
            if (mysql_num_rows($result)>0) {
                $result = msql_fetch_array($result);

                $products = array();
                $products['pid'] = $result['pid'];
                $products['name'] = $result['name'];
                $products['price'] = $result['price'];
                $products['description'] = $result['description'];
                $products['created_at'] = $result['created_at'];
                $products['updated_at'] = $result['updated_at'];

                $response['success'] = 1;
                $response['product'] = array();
                array_push($response['product'], $products);
            } else {
                $response['success'] = 0;
                $response['message'] = "No product found";
            }
        } else {
            $response['success'] = 0;
            $response['message'] = "No product found";
        }
    } else {
        $response['success'] = 0;
        $response['message'] = "Required field(s) is missing";
    }

    echo json_encode($response);

?>