Curl request with array values as input for query (GET) params

Question

I have output from an array I would like to use as input in a PHP Curl request. Do I store them as another array and loop through the array with the Curl request?

Here is the output from the array:

foreach ($threadsarray['threads'] as $thread) {   
    print $thread['id']."<br />";
}

These are values I would like to use as input for Curl (obviously these values are different every time depending on the output for each loop above):

I want to execute a curl request for each of those thread id's... Here is how I am building the Curl request:

$url2 = 'https://api.website.com/endpoint';

    $data2 = array (
        'specialkey' => '123abcd789xyz',
        'anotherparam' => 'Brown',
        'locale' => 'en-US',
        'thread_id' => array (
                       $thread['id']
                       )
        );

        //build the query string because this is a get request
        $params2 = '';
        foreach($data2 as $key2=>$value2)
                $params2 .= $key2.'='.$value2.'&';

        $params2 = trim($params2, '&');


        // Excecute the curl request
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url2.'?'.$params2 );
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 'false');
        $mycurlresult = curl_exec($ch);
echo '<pre>';
$resultarray = json_decode($mycurlrequest, TRUE);
print_r($resultarray);
echo '</pre>';
        if (FALSE === $mycurlrequest)
            throw new Exception(curl_error($ch), curl_errno($ch));

I can't seem to build the request string correctly...what am I missing?

I'm getting Array to string conversion on the following line:$params2 .= $key2.'='.$value2.'&'; — sjackson
– sjackson, Commented May 1, 2017 at 17:55
You're getting that array to string conversion because one of the $value2s in $data2 is an array. — Don't Panic
– Don't Panic, Commented May 1, 2017 at 17:59
Maybe you just want $thread['id'] instead of array($thread['id'])? — Don't Panic
– Don't Panic, Commented May 1, 2017 at 18:01

Don't Panic · Accepted Answer · 2017-05-01 18:21:04Z

4

I can't really test this, but I'd suggest something like this. First, set up your curl, and create an array with an empty placeholder for thread_id.

$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 'false');

$url2 = 'https://api.website.com/endpoint';
$data2 = array(
    'specialkey' => '123abcd789xyz',
    'anotherparam' => 'Brown',
    'locale' => 'en-US',
    'thread_id' => ''
);

Then loop over your array. For each item, replace the thread_id key in the $data2 parameters array with that item's id, build the query using http_build_query and execute the request.

foreach ($threadsarray['threads'] as $thread) {
    $data2['thread_id'] = $thread['id'];                  // add the current id
    $params2 = http_build_query($data2);                  // build the new query
    curl_setopt($ch, CURLOPT_URL, $url2.'?'.$params2 );
    $mycurlresult = curl_exec($ch);
    echo '<pre>';
    $resultarray = json_decode($mycurlrequest, TRUE);
    print_r($resultarray);
    echo '</pre>';
    if (FALSE === $mycurlrequest)
        throw new Exception(curl_error($ch), curl_errno($ch));
}

edited May 1, 2017 at 18:21

answered May 1, 2017 at 18:13

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

6 Comments

sjackson Over a year ago

Thank you sir. You nailed it. Much appreciated!!

sjackson Over a year ago

Instead of this foreach loop creating 10 different arrays as output, is there a way to get the output into 1 array? Or is there an easy way to step through each of the 10 arrays after the foreach completes?

Don't Panic Over a year ago

Sure, just append to $resultarray instead of overwriting it. $resultarray[] = json_decode($mycurlrequest, TRUE);.

sjackson Over a year ago

Ah, yes. But it's still printing each array as it's appending. I'm after the last array (the total combined array). Is there a way to only print that one?

Don't Panic Over a year ago

Yep, just move your print to after the loop instead of inside it.

|

Collectives™ on Stack Overflow

Curl request with array values as input for query (GET) params

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related