Symfony查询方法小结分享-tutorial php-php.cn

Symfony查询方法小结分享

小云云

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

asal

1569 orang telah melayarinya

本文主要和大家介绍了Symfony查询方法,结合实例形式总结分析了createQuery与getQuery查询数据的具体使用技巧,需要的朋友可以参考下，希望能帮助到大家。

1. 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();

Salin selepas log masuk

个人总结：:是指占位符的意思，防止sql注入。所以把所有需要的参数做成数组$params里面。

2. 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();

Salin selepas log masuk