Symfony2: update query with query builder

Posted by Ichigo Kurosaki on Stack Overflow See other posts from Stack Overflow or by Ichigo Kurosaki
Published on 2013-06-26T10:18:01Z Indexed on 2013/06/26 10:21 UTC
Read the original article Hit count: 145

Filed under:

symfony2

This is my query $id contains primary key and $status contains new status public function updateStatus($id,$status) { $qb=$this->createQueryBuilder('b') ->update() ->set('b.status',$status) ->where('b.id='.$id); echo $qb; return $qb->getQuery() ->getResult(); }

Problem I am facing is [Semantical Error] line 0, col 56 near 'Complete WHERE': Error: 'Complete' is not defined.

Related posts about symfony2

how to use console use in Symfony2

as seen on Stack Overflow - Search for 'Stack Overflow'
I found the console and run it like this: root@valugi-laptop:/var/www/sandbox/hello# php console Symfony version 2.0.0-DEV - hello Usage: Symfony [options] command [arguments] Options: --help -h Display this help message. --quiet -q Do not output any message. --verbose -v … >>> More
Symfony2: automatically logging in users from their Windows session

as seen on Stack Overflow - Search for 'Stack Overflow'
In Symfony2 I have built an intranet. It currently uses the FOSUserBundle and an LDAP bundle to log users in, and I would like to add the functionality to log in user from their session in Windows. I found an NTLM script for PHP and an updated version of it, but I haven't been able to incorporate… >>> More
Integrating CKeditor to my symfony2 project

as seen on Stack Overflow - Search for 'Stack Overflow'
I was trying to integrate ckeditor to my symfony2 project so that some of the textarea will have the ckeditor html editor. I brought the ckeditor on my required textarea by calling the class="ckeditor" in my form. The issue that I am facing now is that when I use the ckeditor the submit button of… >>> More
Symfony2 app in subdirectory nginx

as seen on Server Fault - Search for 'Server Fault'
I'm trying to setup a symfony2 app in a subdirectory of our Server Webserver: nginx 1.1.6 + php fpm OS: gentoo my target is to get the app working from a subdirectory subdomain.xy.domain.tld/tool my nginx config looks like that server { listen 80; server_name subdomain… >>> More
Create combined client side and server side validation in Symfony2

as seen on Stack Overflow - Search for 'Stack Overflow'
I think it would be very useful to create client side form validation up on the symfony2 Form and Validator components. The best way to do this would be to pass the validation constraints to the form view. With that information it would be possible to make a template that renders a form field to… >>> More

Developer IT

Symfony2: update query with query builder - Developer IT

Symfony2: update query with query builder

symfony2

Related posts about symfony2

how to use console use in Symfony2

Symfony2: automatically logging in users from their Windows session

Integrating CKeditor to my symfony2 project

Symfony2 app in subdirectory nginx

Create combined client side and server side validation in Symfony2

Categories cloud