API getting answers in array and display values in PHP

Question

This seems like such a rookie question but I'm just banging my head against the keyboard here and I can't find anything answered already that gets me moving forward.

This is my PHP:

<?php
header('Content-Type: text/plain; charset=utf-8;'); 
$url = file_get_contents("https://example.org/subdomain/api.php?t=t&q=maria");
print_r(json_decode($url));
?>

This is the results:

stdClass Object
(
    [apiVersion] => 1
    [data] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 47
                    [by] => 5
                    [title] => WATER
                    ...
                 )
            [1] => stdClass Object
                (
                    [id] => 45
                    [by] => 5
                    [title] => HEARTH
                    ...
                 )
      ...

How could I extract and echo the property title?

I tried this without success (error 500, blank page)

<?php
header('Content-Type: text/plain; charset=utf-8;'); 

$url = 'https://example.org/subdomain/api.php?t=t&q=maria';
$json = file_get_contents($url);

$answersArray = Array();
for($i=0;$i<count($jsonArray['data']);$i++){
    array_push($answersArray,$jsonArray['data'][$i]['title']);
}

UPDATE

I tried also with this code, still no luck

<?php
header('Content-Type: text/plain; charset=utf-8;'); 

$url = 'https://example.org/subdomain/api.php?t=t&q=maria';
$json = file_get_contents($url);

$answersArray = Array();
for($i=0;$i<count($jsonArray['data']);$i++){
    array_push(echo $answersArray,$jsonArray['data'][$i]->title);

}
foreach($answersArray as $answer) {
    echo $answer;
}
?>

1) You need to decode your json data 2) Simply loop through your subArray data 3) Return the property title for each object: $titles = array_map(function($v){return $v->title;}, json_decode($json)["data"]); — Rizier123
– Rizier123, Commented Sep 10, 2015 at 15:38
@Rizier123 Thanks, I tried with this but it's still not working $json = file_get_contents($url); $data = json_decode($json); foreach($data as $key => $subarray) { $titles = array_map(function($v){return $v->title;}, json_decode($json)["data"]); } — NineCattoRules
– NineCattoRules, Commented Sep 10, 2015 at 16:13
Add error reporting: ini_set("display_errors", 1); error_reporting(E_ALL); at the top of your file(s) and tell us if you get any + check your error logs and tell what you get. (Also what is the output of: echo PHP_VERSION; ?) — Rizier123
– Rizier123, Commented Sep 10, 2015 at 17:27

Jesse Kernaghan · Accepted Answer · 2015-09-11 22:12:19Z

3

The problem is that you're trying to access an object property like an array:

array_push($answersArray,$jsonArray->data[$i]['title']);

should be:

array_push($answersArray,$jsonArray->data[$i]->title);

To output the titles later you can use the following:

foreach($answersArray as $answer) {
    echo $answer;
}

edited Sep 11, 2015 at 22:12

answered Sep 10, 2015 at 16:07

Jesse Kernaghan

4,6542 gold badges20 silver badges25 bronze badges

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

9 Comments

NineCattoRules Over a year ago

Thanks there are no more errors but I'm unable to echo...how could I display only each title?

Jesse Kernaghan Over a year ago

@Simone Where are you trying to echo? Your code only shows that you are storing each title in the $answersArray. You can loop that to echo each title.

NineCattoRules Over a year ago

I tried outside the loop to echo $answersArray but the results is the word "array"

Jesse Kernaghan Over a year ago

@Simone I've added a simple example for echoing each title from the array.

NineCattoRules Over a year ago

no data shown, only a white page, and from console I got 500 server error...I updated the question with my code

|

Mike Brant · Accepted Answer · 2015-09-11 18:13:24Z

2

Basic steps

Decode the JSON.
Get array at 'data' property.
Iterate the 'data' array.
Load title property for each 'data' item into new array.

Code example:

<?php
header('Content-Type: text/plain; charset=utf-8;');

$url = 'https://example.org/subdomain/api.php?t=t&q=maria';
$json = file_get_contents($url);
$obj = json_decode($json);
$data = $obj->data; // get data array
$titles = array();

foreach ($data as $item) {
    $titles[] = $item->title;
}
print_r($titles);
?>

edited Sep 11, 2015 at 18:13

answered Sep 10, 2015 at 16:51

Mike Brant

71.4k10 gold badges102 silver badges104 bronze badges

5 Comments

NineCattoRules Over a year ago

Hi, I don't know why but with this solution I get the 500 internal server error

NineCattoRules Over a year ago

GET example.org/subdomain/prova.php 500 (Internal Server Error) ...prova.php:1

Rizier123 Over a year ago

Who upvoted this? You don't access a property with . in PHP

Mike Brant Over a year ago

@Rizier123 Stupid typo for me, been doing a lot of javascripting lately :). It is now corrected. Concept remains the same.

NineCattoRules Over a year ago

thanks, I just used echo implode(',', $titles); to display results in comma separated list

Talus · Accepted Answer · 2015-09-12 13:45:27Z

1

Your errors lies in the utilization of the json_decode function... you need to specify true as the second argument to actually get an array instead of an object.

<?php
header('Content-Type: text/plain; charset=utf-8;'); 
$url = file_get_contents("https://example.org/subdomain/api.php?t=t&q=maria");
print_r(json_decode($url, true));

And then, if you use the foreach, or better, array_column (php 5.5), you can fetch the title property of each object.

<?php
header('Content-Type: text/plain; charset=utf-8;'); 
$url = file_get_contents("https://example.org/subdomain/api.php?t=t&q=maria");
$response = json_decode($url, true);

$titles = array_column($response['data'], 'title');
var_dump($titles);

edited Sep 12, 2015 at 13:45

answered Sep 11, 2015 at 18:18

Talus

7547 silver badges18 bronze badges

2 Comments

NineCattoRules Over a year ago

your solution give me the word "NULL" displaying in page, nothing else

Talus Over a year ago

Sorry, made a typo, which I just fixed !

4b0 · Accepted Answer · 2020-01-20 11:10:50Z

0

<?php 
 $json=file_get_contents("https://2b4bxi178h.execute-api.us-east-2.amazonaws.com/dev/h");
      $weather=json_decode($json,true);   


          foreach ([''] as $key => $value) {
             $temperature= $value['Robot_No']['Table_Clean'];
             echo "$temperature";
           }
?>

edited Jan 20, 2020 at 11:10

4b0

22.4k30 gold badges97 silver badges143 bronze badges

answered Jan 20, 2020 at 11:09

rahul phavade

1

1 Comment

4b0 Over a year ago

Code-only answers are not particularly helpful. Please include a brief description of how this code solves the problem.

Collectives™ on Stack Overflow

API getting answers in array and display values in PHP

4 Answers 4

9 Comments

5 Comments

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

9 Comments

5 Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related