convert array got as string from "file_get_contents()" back to array [duplicate]

Question

When I try to get data from an API using

file_get_contents("http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDINR%22)&format=json&env=store://datatables.org/alltableswithkeys&callback=");

I got the result as a string. Is there any way to convert it back to array? The string which I got is

string(202) "{"query":{"count":1,"created":"2014-03-11T13:00:31Z","lang":"en-US","results":{"rate":{"id":"USDINR","Name":"USD to INR","Rate":"60.99","Date":"3/11/2014","Time":"9:00am","Ask":"61.00","Bid":"60.98"}}}}"{"error":"","msg":""}

please help me....

Yes. php.net/json_decode (Set the second parameter as TRUE to get an array) — Amal
– Amal, Commented Mar 11, 2014 at 13:03

Community · Accepted Answer · 2023-11-17 20:33:26Z

8

In your request, you ask that the returned format be JSON-encoded (via the format=json parameter), so you can just decode the response into an array using json_decode:

$response = file_get_contents("http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDINR%22)&format=json&env=store://datatables.org/alltableswithkeys&callback=");
$response = json_decode($response, true);

// Parse the array as you would any other

edited Nov 17, 2023 at 20:33

CommunityBot

11 silver badge

answered Mar 11, 2014 at 13:04

jterry

6,2473 gold badges32 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Arun Over a year ago

thank u fro the fast rply... :)

jterry Over a year ago

Glad to help. Feel free to accept the answer if it proved useful :)

Arun Over a year ago

need to have 15 reputation for accept it.. :(

foszto · Accepted Answer · 2014-03-11 13:10:21Z

0

You have a JSON answer here so jo need to dekode that.

<?php
$s =  file_get_contents("http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.xchange%20where%20pair%20in%20(%22USDINR%22)&format=json&env=store://datatables.org/alltableswithkeys&callback=");$data = 
$data = json_decode($s,true);
?>

and the $data variable will be an array.

answered Mar 11, 2014 at 13:10

foszto

711 silver badge2 bronze badges

Collectives™ on Stack Overflow

convert array got as string from "file_get_contents()" back to array [duplicate]

2 Answers 2

3 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Linked

Related