Multi_Curl with values from mysql column

Question

I have a mysql table "blackrock" (it has over 14.000 rows).

   item_id | item_class | item_subclass | actual_price | actual_quantity 
    ---------------------------------------------------------------------
    19019   |     2       |    7           | 5727700      |      12         
    84444   |     2       |    1           | 5888040      |      52 

                        ....

I need the item_id of each row to connect to an extern json API file. Every item_id has his own json file. Here is an example. The 19019 is the item_id.

 https://eu.api.blizzard.com/data/wow/item/19019?namespace=static-eu&locale=de_DE&access_token=USDNLqVH41uJ7IST4gAnoBO4nyXBgLNIgx

I think the best way ist to do this is with multi_curl. I don´t know how to combine the table query and the multi_curl funcion.

This is my database table query:

    // Retrieve data from database
    
    $result= $mysqli->query("
    
    SELECT item_id
    
    FROM blackrock
    
    ");
    
    while($rows=mysqli_fetch_array($result)){
  
   }

Multi Curl (I need to use a user agent, maybe there is a mistake)

 $multiCurl = array();
 // data to be returned
 $result = array();
 // multi handle
 $mh = curl_multi_init();

 foreach ($ids as $i => $id) {

  // URL from which data will be fetched

  $fetchURL = 'https://eu.api.blizzard.com/data/wow/item/' . $id . '?namespace=static-eu&locale=de_DE&access_token=USDNLqVH41uJ7IST4gAnoBO4nyXBgLNIgx';
  $multiCurl[$i] = curl_init();
  curl_setopt($multiCurl[$i], CURLOPT_USERAGENT, $userAgent);
  curl_setopt($multiCurl[$i], CURLOPT_URL,$fetchURL);
  curl_setopt($multiCurl[$i], CURLOPT_HEADER,0);
  curl_setopt($multiCurl[$i], CURLOPT_RETURNTRANSFER,1);
  curl_multi_add_handle($mh, $multiCurl[$i]);
}

$userAgent = 'Mozilla/5.0 (Windows NT 5.1; rv:31.0) Gecko/20100101 Firefox/31.0';

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

// get content and remove handles

foreach($multiCurl as $k => $ch) {
  $result[$k] = curl_multi_getcontent($ch);
  curl_multi_remove_handle($mh, $ch);
}

var_dump(json_decode($result));

// close
curl_multi_close($mh);

I can´t test it because I don´t know how I can combine a mysql query an a multi_curl function. — Retros, Sep 25 '20 at 20:32
`curl_setopt($ch, CURLOPT_USERAGENT, $userAgent);` you should pass `$multiCurl[$i]` instead of `$ch` — Dark Knight, Sep 25 '20 at 20:34
Thanks for your help. I´ve edited it. Could you help me how to include the curl function in the mysqli query? — Retros, Sep 25 '20 at 20:37
I have under $fetchURL a variable which comes from the database (item_id). So it´s difficult to test it. At the moment i just get "NULL" as response. — Retros, Sep 25 '20 at 20:43
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/222091/discussion-between-jitendra-yadav-and-retros). — Dark Knight, Sep 25 '20 at 20:44

Dark Knight · Accepted Answer · 2020-09-25T21:27:42.490

Note: CURLOPT_SSL_VERIFYHOST and CURLOPT_SSL_VERIFYPEER are set to 0, for just api verification. These can make your server insecure. Please follow this link to get proper solution.

Now that being said,

// $ids => array of ids fetched from database.
// $ids = [19019, 84444];
$userAgent  =   'Mozilla/5.0 (Windows NT 5.1; rv:31.0) Gecko/20100101 Firefox/31.0';
$mh         =   curl_multi_init();
$channels   =   [];

foreach ($ids as $id) {
    $fetchURL = 'https://eu.api.blizzard.com/data/wow/item/' . $id . '?namespace=static-eu&locale=de_DE&access_token=USDNLqVH41uJ7IST4gAnoBO4nyXBgLNIgx';
    
    $channels[$id] = curl_init($fetchURL);
    curl_setopt($channels[$id], CURLOPT_RETURNTRANSFER, 1);
    // This will make your server insecure, use certificate file for the same.
    curl_setopt($channels[$id], CURLOPT_SSL_VERIFYHOST, 0);
    curl_setopt($channels[$id], CURLOPT_SSL_VERIFYPEER, 0);
    curl_multi_add_handle($mh, $channels[$id]);
}

// execute all queries simultaneously, and continue when all are complete
$running = null;
do {
    curl_multi_exec($mh, $running);
    curl_multi_select($mh);
} while ($running > 0);

//close the handles
foreach ($ids as $id) {
    curl_multi_remove_handle($mh, $channels[$id]);
}

curl_multi_close($mh);

$response   =    [];
foreach($ids as $id){
    $res    = curl_multi_getcontent($channels[$id]);

    $response[$id]  =   ($res === false) ? null : json_decode($res, true);
}

echo '<pre>'; print_r($response);

Multi_Curl with values from mysql column

1 Answers1

Linked

Related