php - Symfony3 Doctrine querybuilder -


i writing symfony3 app using doctrine orm.

i have entity attributes , setters , getters.

trying build can retrieve row based on email address.

my query:        /**      * @param $email      */     public function getuserbyemail($email) {     $repository = $this->db->entitymanagerorm()         ->getrepository('testbundle:user');      $query = $repository->createquerybuilder('t')         ->where('t.emial = :email')         ->setparameter(':email', $email)         ->getquery();      $test = $query->getresult();      var_dump($test); 
  1. $this->db entitymanager service , instantiated in __construct. retrieve entity, create querybuilder want retrieve entire row email == given email.

    response get:

    "notice: undefined index: [semantical error] line 0, col 63 near 'emial 

    = :ema': error: class test\testbundle\entity\user has no field or

    association named emial"

anything suspicious in code....?

it's spelling of email. change this:

$query = $repository->createquerybuilder('t')       ->where('t.email = :email')       ->setparameter(':email', $email)       ->getquery(); 

that should fix problem.


Comments