Symfony 5 - 语义 *** 错误没有名为 category.id 的字段或关联
我有这个问题,我真的不知道为什么......
I have this issue and I don't know really why...
存储库:
/**
* @return Creations[]
*/
public function displayOne(): array
{
return $this->createQueryBuilder('c')
->andWhere('c.category.id = 1')
->setMaxResults(3)
->getQuery()
->getResult();
// returns an array of Product objects
return $query->getResult();
}
}
实体:
/**
* @ORMManyToOne(targetEntity=Category::class, inversedBy="creations")
* @ORMJoinColumn(nullable=false)
*/
private $category;
控制器功能:
public function index(): Response
{
$repository = $this->entityManager->getRepository(Creations::class);
$creations = $repository->findAll();
$categories = $this->entityManager->getRepository(Category::class)->findAll();
return $this->render('creations/index.html.twig', [
'creations' => $repository->displayOne(),
'categories' => $categories
]);
}
另外,当我 dd($creations) 时,我得到了很好的链接".创作->类别->身份证->1个例子
Also when I dd($creations), I got the good "link" thecreation -> category -> id -> 1 for example
感谢您的帮助!
推荐答案
试试这个:
public function displayOne(Category $category): array
{
return $this->createQueryBuilder('c')
->andWhere('c.category = :category')
->setParameter('category', $category)
->setMaxResults(3)
->getQuery()
->getResult();
}
或者:
public function displayOne(): array
{
return $this->createQueryBuilder('c')
->join('c.category', 'cat')
->andWhere('cat.id = :category')
->setParameter('category', 1)
->setMaxResults(3)
->getQuery()
->getResult();
}
三部分选择器 c.category.id
是行不通的.
The three parts selector c.category.id
is just not going to work.
相关文章