elasticsearch query and cURL in PHP no results

Question

i tried to using PHP to execute the cURL request and separate curl var_dump output into different variables?but didn't shown anything in php and No errors in PHP logs.

Here is my code:

$url='curl -XGET <my_url>:9200/logstash-index-*/_search?pretty -d \'
 {

    "size": 0,
     "aggs" : {
        "langs" : {
                "terms" : { 
                   "field" : "name" ,
                    "size": 0
                          }
                  }
             }
  }\'';

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, 0);
ob_start();
curl_exec ($ch);
curl_close ($ch);
$data = ob_get_contents();
ob_end_clean();
var_dump($data);

Thanks for help!

jquiaios · Accepted Answer · 2016-06-12 15:43:38Z

2

You are currently mixing up two things here, the linux cURL command and the php_curl commands.

Here is a linux command to type in a bash / sh for example :

curl -XGET <my_url>:9200/logstash-index-*/_search?pretty -d '
{
"size": 0,
 "aggs" : {
    "langs" : {
            "terms" : { 
               "field" : "name" ,
                "size": 0
                      }
              }
         }
}'

And here is the same example using php_curl :

$url = '<my_url>:9200/logstash-index-*/_search?pretty';
$data = array(
    "size" => 0,
    "aggs" => array (
        "langs" => array (
                "terms" => array ( 
                   "field" => "name" ,
                    "size" => 0
                )
        )
    )
);
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_POST, true); 
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data)); 
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$return = curl_exec($ch) or die(curl_error());
curl_close($ch);
//var_dump($return);

//return is json_encoded, you can decode it to have an array
$array_return = json_decode($return,true);

$aggregationsArray = array(); 
foreach($array_return['aggregations']['name']['buckets'] as $person) 
{
    $aggregationsArray[$person['key']] = $person['doc_count']; 
}
var_dump($aggregationsArray);

Edit1 : Post data must be json_encoded
Edit2 : Return is json_encoded, decode it with json_decode
Edit3 : Add customized loop

edited Jun 12, 2016 at 15:43

answered Jun 11, 2016 at 16:21

jquiaios

5993 silver badges16 bronze badges

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

18 Comments

matt.crawfoord Over a year ago

got the error : error: root_cause: - type: "parse_exception" reason: "failed to parse search source. source must be an object, but found [VALUE_STRING]\ \ instead" type: "search_phase_execution_exception" reason: "all shards failed" phase: "query" grouped: true failed_shards: - shard: 0 index: "logstash-index-2016.05.23" node: "SQeFot_gTj-mqe5G-6kGSQ" reason: type: "parse_exception" reason: "failed to parse search source. source must be an object, but found\ '... (length=550)

jquiaios Over a year ago

Try to json_encode the $data array when passing threw CURLOPT_POSTFIELDS option.

jquiaios Over a year ago

curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data));

matt.crawfoord Over a year ago

it's work and no error but can i just only to get all key list to array ?

jquiaios Over a year ago

Can you provide your current return please ?

|

Collectives™ on Stack Overflow

elasticsearch query and cURL in PHP no results

1 Answer 1

18 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

18 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related