Symfony validator with Doctrine query

Question

I'm writing a forgotten password form and, using PHP validation (as opposed to YML), I am trying to first of all check whether the e-mail address exists.

I think I'm mostly there but I can't seem to run a Doctrine query inside the validator. Here is what I have so far:

class EmailExistsValidator extends ConstraintValidator
{

    public function isValid($value, Constraint $constraint)
    {
        $em = $this->container->get('doctrine.orm.entity_manager');
        $query = $em->createQuery('SELECT COUNT(id) FROM users WHERE email=:email')
            ->setParameter('email', $value);
        $count = $query->getQuery()->getSingleScalarResult();

        if ($count != 1) {
            $this->setMessage($constraint->message);

            return false;
        }

        return true;
    }
}

I get "undefined property - container".

Maybe this could help you: php-and-symfony.matthiasnoback.nl/2011/11/… — Hubert Perron
– Hubert Perron, Commented May 6, 2013 at 12:31
Thanks but it doesn't show how to get a Doctrine query in there — James
– James, Commented May 6, 2013 at 12:37

Baba Yaga · Accepted Answer · 2013-05-06 13:06:32Z

1

Just pass the doctrine service to the validator like this:

protected $doctrine;

    public function __construct($doctrine) {
        $this->doctrine = $doctrine;
    }

and than in your services.yml:

my_service.my_constraint:
        class: MyCompany\MyBundleBundle\Validator\Constraints\MyValidator
        arguments:
            - '@doctrine'
        tags:
            - { name: validator.constraint_validator, alias: my_name }

and then you can do in your validator like: $this->doctrine->getRepository('...');

answered May 6, 2013 at 13:06

Baba Yaga

1,81915 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

James Over a year ago

I've added the code and edited DependencyInjection/Configuration.php, but now I'm getting 'There is no extension able to load the configuration...'. Am I missing something?

Baba Yaga Over a year ago

Can you give me the complete error? Because I want to know which extension he can't load.

Baba Yaga Over a year ago

Why did you edit DependencyInjection/Configuration.php? Because if you place the code in your services.yml it should be loaded already.

James Over a year ago

I've removed it but I've got a similar problem.

James Over a year ago

let us continue this discussion in chat

Collectives™ on Stack Overflow

Symfony validator with Doctrine query

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related