Symfony 5 - 语义 *** 错误没有名为 category.id 的字段或关联

2022-01-16 00:00:00 php doctrine symfony4 doctrine-orm symfony5

我有这个问题,我真的不知道为什么......

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.

相关文章