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

Summary of query methods in Symfony

零下一度

Release： 2023-03-12 12:04:02

Original

1595 people have browsed it

This article mainly introduces the Symfonyquery method, and summarizes and analyzes the specific usage techniques of createQuery and getQuery to query data in the form of examples. Friends in need can refer to the following

The examples of this article are described Symfony query method. Share it with everyone for your reference, the details are as follows:

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:: refers to the meaning of placeholder, to prevent sql injection. So put all the required parameters into 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

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