在教义中如何使用andWhere and orWhere? [英] How to use andWhere and orWhere in Doctrine?

问题描述

WHERE a = 1 AND (b = 1 Or b = 2) AND (c = 1 OR c = 2)

我该如何在教义中做到这一点?

How can i make this in Doctrine?

$q->where("a = 1");
$q->andWhere("b = 1")
$q->orWhere("b = 2")
$q->andWhere("c = 1")
$q->orWhere("d = 2")

这不是正确的...应该是

this isnt correctly... Should be:

$q->where("a = 1");
$q->andWhere("b = 1")
   $q->orWhere("b = 2")
$q->andWhere("c = 1")
   $q->orWhere("d = 2")

但是我怎么做呢?在Propel中是功能 getNewCriterion ，在Doctrine中是功能...?

but how can i make it? In Propel is function getNewCriterion, and in Doctrine...?

推荐答案

$q->where("a = 1")
  ->andWhere("b = 1 OR b = 2")
  ->andWhere("c = 2 OR c = 2")
  ;

这篇关于在教义中如何使用andWhere and orWhere?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！