@dhruvdutt/

Appbase.io - PHP - search - compound

PHP (Legacy)

Complex query combining two conditions together

fork
loading

This Plugin Crashed!

Error: Error: must not create an existing file {"type":"CREATE_FILE","wid":"0.47396421106625364","path":"main.php","file":{"path":"main.php","content":{"asEncoding":{"base64":"JGN1cmwgPSBjdXJsX2luaXQoKTsKCmN1cmxfc2V0b3B0X2FycmF5KCRjdXJsLCBhcnJheSgKICBDVVJMT1BUX1VSTCA9PiAiaHR0cHM6Ly9zY2Fsci5hcGkuYXBwYmFzZS5pby9ob3VzaW5nLWRlbW8vbGlzdGluZy9fc2VhcmNoIiwKICBDVVJMT1BUX1JFVFVSTlRSQU5TRkVSID0+IHRydWUsCiAgQ1VSTE9QVF9FTkNPRElORyA9PiAiIiwKICBDVVJMT1BUX01BWFJFRElSUyA9PiAxMCwKICBDVVJMT1BUX1RJTUVPVVQgPT4gMzAsCiAgQ1VSTE9QVF9IVFRQX1ZFUlNJT04gPT4gQ1VSTF9IVFRQX1ZFUlNJT05fMV8xLAogIENVUkxPUFRfQ1VTVE9NUkVRVUVTVCA9PiAiUE9TVCIsCiAgQ1VSTE9QVF9QT1NURklFTERTID0+IGpzb25fZW5jb2RlKGFycmF5KAogICAgInF1ZXJ5IiA9PiBhcnJheSgKICAgICAgImJvb2wiID0+IGFycmF5KAogICAgICAgICJtdXN0IiA9PiBhcnJheSgKICAgICAgICAgIGFycmF5KAogICAgICAgICAgICAibWF0Y2giID0+IGFycmF5KAogICAgICAgICAgICAgICJyb29tX3R5cGUiID0+ICJwcml2YXRlIgogICAgICAgICAgICApICAKICAgICAgICAgICksCiAgICAgICAgICBhcnJheSgKICAgICAgICAgICAgInJhbmdlIiA9PiBhcnJheSgKICAgICAgICAgICAgICAicHJpY2UiID0+IGFycmF5KAogICAgICAgICAgICAgICAgImd0ZSIgPT4gOTUsCiAgICAgICAgICAgICAgICAibHRlIiA9PiAxMDAKICAgICAgICAgICAgICApCiAgICAgICAgICAgICkgIAogICAgICAgICAgKQogICAgICAgICkKICAgICAgKSAgICAgCiAgICApCiAgKSksCiAgQ1VSTE9QVF9IVFRQSEVBREVSID0+IGFycmF5KAogICAgIkF1dGhvcml6YXRpb246IEJhc2ljIFdXNURaMVozYjNwV09tVTVaV00xWTJJd0xUVTRaRGd0TkdKaU1DMWlZV1JqTFdGallXWTNNalkyTmpGbU1RPT0iLAogICAgIkNvbnRlbnQtVHlwZTogYXBwbGljYXRpb24vanNvbiIKICApLAopKTsKCiRyZXNwb25zZSA9IGN1cmxfZXhlYygkY3VybCk7CiRlcnIgPSBjdXJsX2Vycm9yKCRjdXJsKTsKCmN1cmxfY2xvc2UoJGN1cmwpOwoKaWYgKCRlcnIpIHsKICBlY2hvICJjVVJMIEVycm9yICM6IiAuICRlcnI7Cn0gZWxzZSB7CiAgJGpzb24gPSBqc29uX2RlY29kZSgkcmVzcG9uc2UsIHRydWUpOwogIHByaW50X3IoIkBzZWFyY2ggaGl0czogIik7CiAgcHJpbnRfcigkanNvblsnaGl0cyddWydoaXRzJ10pOwp9"},"asBuffer":null},"loaded":true}}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => "https://scalr.api.appbase.io/housing-demo/listing/_search",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode(array(
    "query" => array(
      "bool" => array(
        "must" => array(
          array(
            "match" => array(
              "room_type" => "private"
            )  
          ),
          array(
            "range" => array(
              "price" => array(
                "gte" => 95,
                "lte" => 100
              )
            )  
          )
        )
      )     
    )
  )),
  CURLOPT_HTTPHEADER => array(
    "Authorization: Basic WW5DZ1Z3b3pWOmU5ZWM1Y2IwLTU4ZDgtNGJiMC1iYWRjLWFjYWY3MjY2NjFmMQ==",
    "Content-Type: application/json"
  ),
));

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  $json = json_decode($response, true);
  print_r("@search hits: ");
  print_r($json['hits']['hits']);
}
PHP 7.0.8 (Legacy: use the following for new features: Command-line PHP: https://repl.it/languages/php_cli PHP Web Server: https://repl.it/languages/php7