php - Unrecognized field: user_name, while querying Via Doctrine using ZF2

Solution:

You are querying for the wrong field. The field is named_username in your entity class. Also check you annotations,_username and_password seem to not have any so they won't be created as database fields.

If you set up your entity correctly and all fields are in database you just need to query for your_username property:

 if ($request->isPost()) {
     $form->setData($request->getPost());
     $repo = $this->getEntityManager()->getRepository('Subject\Entity\User');
     if ($form->isValid()) {
         // snip ...
         $criteria = array("_username" => $username,);
         $results= $repo->findBy($criteria);
         print_r($results);
         exit;
    }
}
Copy code

You user entity should look something like:

class User implements InputFilterAwareInterface {
    /**
     * @ORM\Column(name="username", type="string", length=64, unique=true)
     */
    protected $_username;
    /**
     * @ORM\Column(name="password", type="string", length=64)
     */
    protected $_password;

    // snip ...
}
Copy code

You may take a look at the PSR-2 standards. Underscores in method and variable names are discouraged by now.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.