Doctrine 2 Update query with query builder

Question

Hi I ve got the following query but it doesn t seem to work    q    this- gt em- gt createQueryBuilder       - gt update  models User    u       - gt set  u username    username      - gt set  u email    email      - gt where  u id    1       - gt setParameter 1   editId      - gt getQuery     p    q- gt execute      This returns the following error message      Fatal error  Uncaught exception    Doctrine ORM Query QueryException    with message   Semantical Error  line   0  col 38 near  testusername WHERE     Error   testusername  is not defined     in       I would be glad of any help

User · Answer

With a small change  it worked fine for me   qb  this- gt dm- gt createQueryBuilder  AppBundle CSSDInstrument                  - gt update                  - gt field  status  - gt set  status                 - gt field  id  - gt equals  instrumentId                 - gt getQuery                  - gt execute

User · Answer

I think you need to use Expr with - gt set    However THIS IS NOT SAFE and you shouldn t do it     qb    this- gt em- gt createQueryBuilder     q    qb- gt update  models User    u           - gt set  u username    qb- gt expr  - gt literal  username           - gt set  u email    qb- gt expr  - gt literal  email           - gt where  u id    1           - gt setParameter 1   editId          - gt getQuery     p    q- gt execute      It s much safer to make all your values parameters instead    qb    this- gt em- gt createQueryBuilder     q    qb- gt update  models User    u           - gt set  u username     1           - gt set  u email     2           - gt where  u id    3           - gt setParameter 1   username          - gt setParameter 2   email          - gt setParameter 3   editId          - gt getQuery     p    q- gt execute

User · Answer

Let s say there is an administrator dashboard where users are listed with their id printed as a data attribute so it can be retrieved at some point via JavaScript   An update could be executed this way      class UserRepository extends  Doctrine ORM EntityRepository       public function updateUserStatus  userId   newStatus                return  this- gt createQueryBuilder  u               - gt update               - gt set  u isActive     1               - gt setParameter 1   qb- gt expr  - gt literal  newStatus               - gt where  u id    2               - gt setParameter 2   qb- gt expr  - gt literal  userId               - gt getQuery               - gt getSingleScalarResult                     AJAX action handling     Post datas may be    handled with a specific custom formType     OR     retrieved from request object  userId    int  request- gt request- gt get  userId     newStatus    int  request- gt request- gt get  newStatus     em    this- gt getDoctrine  - gt getManager     r    em- gt getRepository  NAMESPACE User           - gt updateUserStatus  userId   newStatus   if    empty  r           Row updated     Working example using Doctrine 2 5  on top of Symfony3

[php] Doctrine 2: Update query with query builder

Examples related to php

Examples related to sql

Examples related to database

Examples related to doctrine