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);
$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
Post a Comment