COUNT and GROUP BY via PHP SDK

cappadaan · June 23, 2021, 4:00pm

I cant find it in the documentation (GitHub - manticoresoftware/manticoresearch-php: Official PHP client for Manticore Search) but does anyone know if it is possible to use the built in methods of the SDK to build the following query in stead of using the sql() method.

SELECT
field,
COUNT(*) AS amount
FROM
index
GROUP BY
field

There seems to no methods for COUNT and Group BY?

barryhunter · June 23, 2021, 4:16pm

Looks like the PHP client, is mainly a wrapper around the HTTP API.

As such it seems to be part of Facets/Aggregation.
https://manual.manticoresearch.com/Searching/Faceted_search#HTTP

Which looks like it done via the adding a ‘facet’ to the query

github.com

manticoresoftware/manticoresearch-php/blob/master/docs/searchclass.md#facet

# Search

This class allow performing search operations.


## Initiation


```php
require_once __DIR__ . '/vendor/autoload.php';
use Manticoresearch\Client;
use Manticoresearch\Search;
$config = ['host' => '127.0.0.1', 'port' => '9308'];
$client = new Client($config);
$search = new Search($client);
```

## Set the index
```php
$search->setIndex('indexname');

This file has been truncated. show original

Looks like facetting by an atttibute, sets up the count automatically.

cappadaan · June 23, 2021, 6:30pm

Yes, Facets is what I was looking for, thx so much!!