Gecko [ unitednationsplay.com ]

Linux unitednationsplay.com 3.10.0-1160.45.1.el7.x86_64 #1 SMP Wed Oct 13 17:20:51 UTC 2021 x86_64
nginx/1.20.1
Server IP : 188.130.139.92 & Your IP : 18.118.140.120
Domains : Cant Read [ /etc/named.conf ]
User : web

Name	Size	Permission	Date	Action
derived-collections.rst	738 B	-rw-rw-r--	2022-08-18 05:44
expression-builder.rst	3.46 KB	-rw-rw-r--	2022-08-18 05:44
expressions.rst	2.17 KB	-rw-rw-r--	2022-08-18 05:44
index.rst	7.94 KB	-rw-rw-r--	2022-08-18 05:44
lazy-collections.rst	740 B	-rw-rw-r--	2022-08-18 05:44
sidebar.rst	122 B	-rw-rw-r--	2022-08-18 05:44

Rename

Expression Builder
==================

The Expression Builder is a convenient fluent interface for
building expressions to be used with the ``Doctrine\Common\Collections\Criteria``
class:

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$criteria = new Criteria();
    $criteria->where($expressionBuilder->eq('name', 'jwage'));
    $criteria->orWhere($expressionBuilder->eq('name', 'romanb'));

$collection->matching($criteria);

The ``ExpressionBuilder`` has the following API:

andX
----

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->andX(
        $expressionBuilder->eq('foo', 1),
        $expressionBuilder->eq('bar', 1)
    );

$collection->matching(new Criteria($expression));

orX
---

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->orX(
        $expressionBuilder->eq('foo', 1),
        $expressionBuilder->eq('bar', 1)
    );

$collection->matching(new Criteria($expression));

eq
---

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->eq('foo', 1);

$collection->matching(new Criteria($expression));

gt
---

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->gt('foo', 1);

$collection->matching(new Criteria($expression));

lt
---

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->lt('foo', 1);

$collection->matching(new Criteria($expression));

gte
---

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->gte('foo', 1);

$collection->matching(new Criteria($expression));

lte
---

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->lte('foo', 1);

$collection->matching(new Criteria($expression));

neq
---

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->neq('foo', 1);

$collection->matching(new Criteria($expression));

isNull
------

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->isNull('foo');

$collection->matching(new Criteria($expression));

in
---

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->in('foo', ['value1', 'value2']);

$collection->matching(new Criteria($expression));

notIn
-----

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->notIn('foo', ['value1', 'value2']);

$collection->matching(new Criteria($expression));

contains
--------

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->contains('foo', 'value1');

$collection->matching(new Criteria($expression));

memberOf
--------

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->memberOf('foo', ['value1', 'value2']);

$collection->matching(new Criteria($expression));

startsWith
----------

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->startsWith('foo', 'hello');

$collection->matching(new Criteria($expression));

endsWith
--------

.. code-block:: php
    $expressionBuilder = Criteria::expr();

$expression = $expressionBuilder->endsWith('foo', 'world');

$collection->matching(new Criteria($expression));