# DbNoRecordExist Validator

**URL:** <https://discourse.laminas.dev/t/dbnorecordexist-validator/2373>\
**Category:** API Tools\
**Created:** [June 21, 2021, 10:35am UTC](https://discourse.laminas.dev/t/dbnorecordexist-validator/2373 "2021-06-21T10:35:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![faizy](https://avatars.discourse-cdn.com/v4/letter/f/ebca7d/32.png) [@faizy](https://discourse.laminas.dev/u/faizy)\
**Post date:** [June 21, 2021, 10:35am UTC](https://discourse.laminas.dev/t/dbnorecordexist-validator/2373/1 "2021-06-21T10:35:53Z")

</div>

How to use exclude in DbNoRecordExist Validator ? I want to give like this; exclude =\> [field =\> “id” , value=\> ‘value of id’]. How to get value of ‘id’ without giving constant value ?

---

<div class="post-metadata">

**Author:** ![juliangorge](https://yyz2.discourse-cdn.com/flex032/user_avatar/discourse.laminas.dev/juliangorge/32/608_2.png) [@juliangorge](https://discourse.laminas.dev/u/juliangorge)\
**Post date:** [July 26, 2023, 9:18pm UTC](https://discourse.laminas.dev/t/dbnorecordexist-validator/2373/2 "2023-07-26T21:18:05Z")

</div>

> [@faizy](#):
>
> ow to get value of ‘id’ without giving consta

Hello! Did you find a solution?

---

<div class="post-metadata">

**Author:** ![ezkimo](https://yyz2.discourse-cdn.com/flex032/user_avatar/discourse.laminas.dev/ezkimo/32/781_2.png) [@ezkimo](https://discourse.laminas.dev/u/ezkimo)\
**Post date:** [July 28, 2023, 3:57pm UTC](https://discourse.laminas.dev/t/dbnorecordexist-validator/2373/3 "2023-07-28T15:57:03Z")

</div>

Hey,

just put the exclude `field` and `value` pair in the validator options as you can see in the [offical documentation](https://docs.laminas.dev/laminas-validator/validators/db/#excluding-records).

```auto
$validator = new Laminas\Validator\Db\NoRecordExists([
    'table' => 'users',
    'field' => 'username',
    'exclude' => [
        'field' => 'id',
        'value' => $user_id,
    ],
]);

```

Think of a factory, that checks the request query parameters for the given user id. When writing your own input filter classes, you can use this validator factory.

```auto
$request = $container->get('Application')->getMvcEvent()->getRequest();
$validators = $container->get(ValidatorPluginManager::class);

$user_id = $request->getQuery('id', null);

$validator = $validators->build(
    'Laminas\ApiTools\ContentValidation\Validator\DbNoRecordExists',
    [
        'exclude' => [
            'field' => 'id',
            'value' => $user_id,
        ],
    ]
);

```