Summary sharing of Symfony query methods-PHP Tutorial-php.cn

Summary sharing of Symfony query methods

小云云

Release： 2023-03-20 08:32:02

Original

1587 people have browsed it

This article mainly introduces the Symfony query method to everyone, and summarizes and analyzes the specific usage skills of createQuery and getQuery to query data in the form of examples. Friends in need can refer to it. I hope it can help everyone.

1. How to write createQuery

$sql = &#39;SELECT COUNT(DISTINCT(g.goodsId)) FROM AppBundle:GoodsIndex g WHERE g.status = :status&#39;;
$params = array(
 &#39;status&#39; => GoodsIndex::STATUS_NORMAL,
);
if (!empty($keywords)) {
 $params[&#39;keywords&#39;] = "%{$keywords}%";
 $sql .= &#39; AND g.keywords like :keywords &#39;;
}
 if (!empty($warehouseIdList)) {
  $params[&#39;warehouseIdList&#39;] = $warehouseIdList;
  $sql .= " AND g.warehouseId IN :(warehouseIdList)";
 }
$goodsNum = $this->entityManager->createQuery($sql)->setParameters($params)->getSingleScalarResult();

Copy after login

Personal summary:: It means placeholder to prevent SQL injection. So put all the required parameters into the array $params.

2. How to write getQuery

$orderBy = &#39;p.&#39;.$searchOptions[&#39;orderBy&#39;];
$repository = $this->entityManager
 ->getRepository(&#39;AppBundle:GoodsIndex&#39;);
$query = $repository->createQueryBuilder(&#39;p&#39;);
$query->select(&#39;DISTINCT(p.goodsId)&#39;);
$query->where(&#39;p.keywords like :keywords&#39;)
 ->setParameter(&#39;keywords&#39;, "%{$searchOptions[&#39;keywords&#39;]}%")
 ->andwhere(&#39;p.status = :status&#39;)
 ->setParameter(&#39;status&#39;, GoodsIndex::STATUS_NORMAL)
 ->orderBy($orderBy, $searchOptions[&#39;order&#39;])
 ->setFirstResult($pagination[&#39;pageSize&#39;] * ($pagination[&#39;page&#39;] - 1))
 ->setMaxResults($pagination[&#39;pageSize&#39;]);
if (!empty($searchOptions[&#39;warehouseIdList&#39;])) {
 $query->andWhere($query->expr()->in(&#39;p.warehouseId&#39;, $searchOptions[&#39;warehouseIdList&#39;]));
}
$goodsIndexList = $query->getQuery()->getResult();

Copy after login

Related recommendations:

Symfony2 for Detailed explanation of input time for query example

Detailed explanation of the usage of Symfony2 framework form

Detailed explanation of the method of implementing joint query in Symfony2

The above is the detailed content of Summary sharing of Symfony query methods. For more information, please follow other related articles on the PHP Chinese website!