CodingForums.com - View Single Post - How To Use Curl In Php For Json Results From Google Places Api

n_sr6 · 01-12-2013, 10:42 PM

I used my API key for querying google places API for obtaining museums around a particular place and obtained the following results in JSON form:
{
"html_attributions" : [],
"results" : [
{
"geometry" : {
"location" : {
"lat" : 15.4954990,
"lng" : 73.82120
}
},
"icon" : "http://maps.gstatic.com/mapfiles/place_api/icons/museum-71.png",
"id" : "1f1425a4048b951552591838918fddcfa92ce0a9",
"name" : "Museum",
"reference" : "CpQBgQAAABj0cBhH-lN_qR75O8cH-CaRqZxZyY98edwHytsuW3hEgA9YX0L9Q5lNSxxJkWKc4hQWZaBie4rAxF6toH1gfcF-EH-8aidpfccqXH7Y6UyN06gNRtaMZtX4KdoQfoDrMvcLPxlpC519Aa6ZFBWII7agaGJ8x3-4Bi7PDIH3nqe6h7ywvQFI12sXh80VE7DhuhIQ-vAeCJylozUNoeZdYEIvLRoUYjxWFbm08-HG-7RIt1JBNcCOsyI",
"types" : [ "museum", "establishment" ],
"vicinity" : "Althino, Panaji (Panjim)"
}
],
"status" : "OK"
}

Then I wrote the following code to obtain only certain data from the JSON result i.e name,type,vicinity

Code:

<?php

$details_url = "https://maps.googleapis.com/maps/api/place/nearbysearch/json?location=15.495602,73.825209&radius=500&types=museum&sensor=false&key=AIzaSyDqEa1fnjGtG4QdAiaekCHKV_tDaN4Nuxo";

   $ch = curl_init();
   curl_setopt($ch, CURLOPT_URL, $details_url);
   curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
   $geoloc = json_decode(curl_exec($ch), true);

  $name=var_dump($geoloc['results'][0]['geometry']['name']);
$types=var_dump($geoloc['results'][0]['geometry']['types']);
$vicinity=var_dump($geoloc['results'][0]['geometry']['types']);


   print $name;
   print $types;
     print $vicinity;

?>

i get the following in my browser when i run the php file:
null
null
null

what do i do next? don't know what the error in the code is. i need to insert the specific data from JSON result that i have got into a database.

01-12-2013, 10:42 PM	PM User \| #1
n_sr6 New to the CF scene Join Date: Jan 2013 Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts	How To Use Curl In Php For Json Results From Google Places Api I used my API key for querying google places API for obtaining museums around a particular place and obtained the following results in JSON form: { "html_attributions" : [], "results" : [ { "geometry" : { "location" : { "lat" : 15.4954990, "lng" : 73.82120 } }, "icon" : "http://maps.gstatic.com/mapfiles/place_api/icons/museum-71.png", "id" : "1f1425a4048b951552591838918fddcfa92ce0a9", "name" : "Museum", "reference" : "CpQBgQAAABj0cBhH-lN_qR75O8cH-CaRqZxZyY98edwHytsuW3hEgA9YX0L9Q5lNSxxJkWKc4hQWZaBie4rAxF6toH1gfcF-EH-8aidpfccqXH7Y6UyN06gNRtaMZtX4KdoQfoDrMvcLPxlpC519Aa6ZFBWII7agaGJ8x3-4Bi7PDIH3nqe6h7ywvQFI12sXh80VE7DhuhIQ-vAeCJylozUNoeZdYEIvLRoUYjxWFbm08-HG-7RIt1JBNcCOsyI", "types" : [ "museum", "establishment" ], "vicinity" : "Althino, Panaji (Panjim)" } ], "status" : "OK" } Then I wrote the following code to obtain only certain data from the JSON result i.e name,type,vicinity Code: <?php $details_url = "https://maps.googleapis.com/maps/api/place/nearbysearch/json?location=15.495602,73.825209&radius=500&types=museum&sensor=false&key=AIzaSyDqEa1fnjGtG4QdAiaekCHKV_tDaN4Nuxo"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $details_url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $geoloc = json_decode(curl_exec($ch), true); $name=var_dump($geoloc['results'][0]['geometry']['name']); $types=var_dump($geoloc['results'][0]['geometry']['types']); $vicinity=var_dump($geoloc['results'][0]['geometry']['types']); print $name; print $types; print $vicinity; ?> i get the following in my browser when i run the php file: null null null what do i do next? don't know what the error in the code is. i need to insert the specific data from JSON result that i have got into a database.