# AQL Query conversion to PHP

**URL:** <https://discuss.aerospike.com/t/aql-query-conversion-to-php/3186>\
**Category:** AQL\
**Tags:** query, aql, php\
**Created:** [July 21, 2016, 6:56pm UTC](https://discuss.aerospike.com/t/aql-query-conversion-to-php/3186 "2016-07-21T18:56:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kumar\_gaurav](https://avatars.discourse-cdn.com/v4/letter/k/9dc877/32.png) [@kumar\_gaurav](https://discuss.aerospike.com/u/kumar_gaurav)\
**Post date:** [July 21, 2016, 6:56pm UTC](https://discuss.aerospike.com/t/aql-query-conversion-to-php/3186/1 "2016-07-21T18:56:22Z")

</div>

Hi All, Following AQL query is working fine for me SELECT \* FROM test.posts IN LIST WHERE ids = 179 I need this record to be fetched in PHP class . how can i write this with query() function ? Please help . Thanks In advance

---

<div class="post-metadata">

**Author:** ![rbotzer](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rbotzer/32/2114_2.png) [@rbotzer](https://discuss.aerospike.com/u/rbotzer)\
**Post date:** [July 21, 2016, 7:47pm UTC](https://discuss.aerospike.com/t/aql-query-conversion-to-php/3186/2 "2016-07-21T19:47:30Z")

</div>

First, is there a secondary index for type LIST over the ids bin of test.posts? If not, you’ll need to [create it](http://www.aerospike.com/docs/operations/manage/indexes) for the query to execute.

In the PHP client you’ll be using [predicateContains()](https://github.com/aerospike/aerospike-client-php/blob/master/doc/aerospike_predicatecontains.md) with your [query()](https://github.com/aerospike/aerospike-client-php/blob/master/doc/aerospike_query.md). For example:

```php
$results = [];
$where = Aerospike::predicateContains("ids", Aerospike::INDEX_TYPE_LIST, 179);
$status = $client->query("test", "posts", $where, function ($record) use (&$results) {
    $results[] = $record['bins'];
});

```

---

<div class="post-metadata">

**Author:** ![kumar\_gaurav](https://avatars.discourse-cdn.com/v4/letter/k/9dc877/32.png) [@kumar\_gaurav](https://discuss.aerospike.com/u/kumar_gaurav)\
**Post date:** [July 25, 2016, 11:19am UTC](https://discuss.aerospike.com/t/aql-query-conversion-to-php/3186/3 "2016-07-25T11:19:40Z")

</div>

Thank you very much @rbotzer . This is working fine for me . You are a Rockstar . 😄