How to create a json of object in cURL response in php

Question

I just need help regarding this problem. Here's what I wanted to achieve in my php output as this is the structure needed. An array of objects of events returned as JSON.

[
    {
        "page_item_url":"2111",
        "data":{
            "startTime":"11:00"
            "endTime":"12:00",
            "summary":"<p>This has html tags in it from API<p>"
        }
    },{
        "page_item_url":"2112",
        "data":{
            "startTime":"11:00"
            "endTime":"12:00",
            "summary":"<p>This has html tags in it from API<p>"
        }
    }
]

The JSON returned should be like that, it was a call from an API using cUrl. I have a function which first gets all the ID's and I pass it into a variable;

function getOpportunityYearly(){
    //curl here...
    //I pushed all the ID in my array to the global scope
}

So now, I have my array of ID's:

   $events = [2111,2112,2113,2114,2115];//etc
   $jsonResponse = [];

In which I would like to loop through and call another cUrl from the API which then should be pushed through the $jsonResponse my problem is when I pass the returned response from the getEventByID and convert it to json the structure is not correct.

for($i=0;$i<count($events);$i++){
    getEventByID($events[$i]);
}

function getEventByID($eventID){
    curl = curl_init();
    curl_setopt_array($curl, array(
    CURLOPT_URL =>'https://sampleapi.com/api/v3/data/opportunities/'.$eventID.'?key='.$GLOBALS['API_KEY'].'&fields=["startTime","endTime","physicalDifficulty","summary"]&where={"whereType":"AND","clauses":[{"fieldName":"displayToPublic","operator":"checked"}]}',
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_ENCODING => "",
    CURLOPT_MAXREDIRS => 10,
    CURLOPT_TIMEOUT => 0,
    CURLOPT_FOLLOWLOCATION => true,
    CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
    CURLOPT_CUSTOMREQUEST => "GET",

    $response = json_decode(curl_exec($curl));
    curl_close($curl);
    $record = $response->records[0];

    return json_encode([[
      "page_item_url"=> $record->opportunities_id->value,
        "data"=>[
          "startTime"=>$record->startTime->displayValue,
          "endTime"=>$record->endTime->displayValue,
          "summary"=>$record->summary->displayValue,
          ]
    ]],JSON_HEX_QUOT | JSON_HEX_TAG);

}

The return from getEventByID function should be a json formatted like from the one above json sample when I try to use the code returned from getEventByID for a single object it is fine see https://prnt.sc/ris9g7 but when I push first the response to a global array variable then encode it it got something like this https://prnt.sc/risjw5

I tried creating an array and push all the returned from getEventByID but the output is not a JSON string it was an array. Am I doing something wrong.

When I use the forloop the page was slow, and it was getting maximum timeout of 30secs I have tried using $curl, CURLOPT_TIMEOUT_MS and set it to 5mins. But is there any other way to make this cURL not slow? Or is this normal as we are getting all the ID events objects from the API? Can you advise anything to improve this?

This is the returned type from getEventByID https://prnt.sc/ris8zx This is how I construct and return a single event from curl response https://prnt.sc/ris9c0 This is the correct which is I got https://prnt.sc/ris9g7 how ever if I remove the brackets in the json_encode and just pass an assoc array of key value then push it to an array

icedev · Accepted Answer · 2020-03-24 00:57:41Z

EDIT: Finally resolved curl multiple requests by using multi curl. Here's the tutorial link Per Id in the event will be processed and will call a curl request to the API. And construct an assoc array. Once completed, I have encoded jsonResponse as JSON.

function multiCurl($eventArray){
    // array of curl handles
    $multiCurl = array();

    // data to be returned
    $result = array();

    // multi handle
    $mh = curl_multi_init();

    foreach ($eventArray as $event) {
        //$event are the ID per each event
        // URL from which data will be fetched
       // $curl = curl_init();
        $multiCurl[$event] = curl_init();
        curl_setopt_array($multiCurl[$event], array(
          CURLOPT_URL =>'https://api.civicore.com/voc/api/v3/data/opportunities/'.$event.'?key='.$GLOBALS['API_KEY'].'&fields=["opportunityName","typeOfWork","firstDateInOpportunity","lastDateInOpportunity","startTime","endTime","physicalDifficulty","minimumAge","location","state","city","county","campingAvailable","groupsAllowed","registrationFormID","cRQ_payment","paymentAmount","additionalInformation","photo","displayToPublic","latitude","longitude","summary","description","photo"]&where={"whereType":"AND","clauses":[{"fieldName":"displayToPublic","operator":"checked"}]}',
          CURLOPT_RETURNTRANSFER => true,
          CURLOPT_ENCODING => "",
          CURLOPT_MAXREDIRS => 10,
          CURLOPT_TIMEOUT => 0,
          CURLOPT_FOLLOWLOCATION => true,
          CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
          CURLOPT_CUSTOMREQUEST => "GET"
        ));
        curl_multi_add_handle($mh, $multiCurl[$event]);
    }

    do {
      curl_multi_exec($mh,$index);
    } while($index > 0);

      // get content and remove handles
      foreach($multiCurl as $key=>$value) {

        $records = json_decode(curl_multi_getcontent($value));//response of each request
        $record  = $records->records[0];

       if(strtolower($record->displayToPublic->displayValue) == 'yes'){
          $eve =  [ 
            "page_item_url"=> $record->opportunities_id->value,
              "data"=>[
                "startTime"=>$record->startTime->displayValue,
                "endTime"=>$record->endTime->displayValue,
                "summary"=> $record->summary->displayValue
                ]
              ];
          array_push($GLOBALS["jsonResponse"],$eve);
        }
        curl_multi_remove_handle($mh, $value);
      }//foreach
    curl_multi_close($mh);
}

Umair Khan · Accepted Answer · 2020-03-19 05:56:06Z

0

You do have some syntax errors in example code. However please try this.

<?php
function getEventByID($eventID)
{
    $curl = curl_init();
    curl_setopt_array($curl, array(
        CURLOPT_URL => 'https://sampleapi.com/api/v3/data/opportunities/' . $eventID . '?key=' . $GLOBALS['API_KEY'] . '&fields=["startTime","endTime","physicalDifficulty","summary"]&where={"whereType":"AND","clauses":[{"fieldName":"displayToPublic","operator":"checked"}]}',
        CURLOPT_RETURNTRANSFER => true,
        CURLOPT_ENCODING => "",
        CURLOPT_MAXREDIRS => 10,
        CURLOPT_TIMEOUT => 0,
        CURLOPT_FOLLOWLOCATION => true,
        CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
        CURLOPT_CUSTOMREQUEST => "GET",
    ));
    $response = json_decode(curl_exec($curl));
    curl_close($curl);
    $record = $response->records[0];

    return json_decode(json_encode([
        "page_item_url" => $record->opportunities_id->value,
        "data" => [
            "startTime" => $record->startTime->displayValue,
            "endTime" => $record->endTime->displayValue,
            "summary" => $record->summary->displayValue,
        ]
    ], JSON_HEX_QUOT | JSON_HEX_TAG));
}

$events = [2111, 2112, 2113, 2114, 2115]; //etc
$jsonResponse = [];

for ($i = 0; $i < count($events); $i++) {
    $jsonResponse[] = getEventByID($events[$i]);
}

print_r($jsonResponse);

?>

answered Mar 19, 2020 at 5:56

Umair Khan

1,75219 silver badges36 bronze badges

2 Comments

icedev Over a year ago

Okay bro, I will try that as well! Thanks for the input! :)

icedev Over a year ago

yes but the output seems not to be a json file. Still fixing bro :/

Collectives™ on Stack Overflow

How to create a json of object in cURL response in php

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related