Symfony主义更新查询失败 [英] Symfony Doctrine update query fail
问题描述
我的代码是:
$query = $em->createQuery("UPDATE AppBundle:Project u SET u.name=1, u.key=?2, u.leader=?3 WHERE u.id = ?4");
$query->setParameter(1, $project->name);
$query->setParameter(2, $project->key);
$query->setParameter(3, $project->lead->name);
$query->setParameter(4, $project->id);
$result = $query->getResult();
现在,当我运行它时,它给了我一个错误:
Now when I run it, it gives me a error:
SQLSTATE [42000]:语法错误或访问冲突:1064您的SQL语法有一个错误;请参阅第1914页的"SQLSTATE错误".检查与您的MySQL服务器版本相对应的手册,以在'key ='EIAD',Leader ='fake.name'WHERE id ='12305'附近使用正确的语法第1行
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key = 'EIAD', leader = 'fake.name' WHERE id = '12305'' at line 1
我无法弄清楚我在做什么错.我什至尝试了对象更新,例如:
I cant figure out what I'm doing wrong here. I even tried with the Object update like:
$project->setname();
等
忘记说代码是在自己创建的命令中使用的!
Forgot to say the code is used in a self created command!
推荐答案
使用Querybuilder.示例:
Using Querybuilder. Example:
$em = $this->getDoctrine()->getManager();
$query = $em->getRepository(Project::class)->createQueryBuilder('')
->update(Project::class, 'u')
->set('u.name', ':name')
->set('u.key', ':key')
->set('u.leader', ':leader')
->setParameter('name', $project->name)
->setParameter('key', $project->key)
->setParameter('leader', $project->leader)
->where('u.id = :id')
->setParameter('id', $project->id)
->getQuery();
$result = $query->execute();
这篇关于Symfony主义更新查询失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!