createQueryBuilder('p') ->andWhere('p.price < :price') ->setParameter('price', $price) ->orderBy('p.price', 'ASC') // ->setMaxResults(10) ->getQuery(); return $query->getResult(); // to get just one result: // $product = $qb->setMaxResults(1)->getOneOrNullResult(); } public function findProductsLessThanDQL(float $price) { $em = $this->getEntityManager(); $query = $em->createQuery( /** @lang DQL */' SELECT p FROM App\Entity\Product p WHERE p.price < :price ORDER BY p.price ASC ')->setParameter('price', $price); // returns an array of Product objects return $query->execute(); } public function findProductsLessThanSQL(float $price) { $conn = $this->getEntityManager()->getConnection(); // With SELECT * we would get category_id, which is not returned by the // other queries, as it is a physical DB field, not an entity field. $sql = <<prepare($sql); $stmt->execute(['price' => $price]); // returns an array of arrays (i.e. a raw data set). return $stmt->fetchAll(\PDO::FETCH_CLASS, Product::class); } public function findOneByIdJoinedToCategory($productId) { return $this->createQueryBuilder('p') ->innerJoin('p.category', 'c') ->addSelect('c') ->andWhere('p.id = :id') ->setParameter('id', $productId) ->getQuery() ->getOneOrNullResult(); } }