php - 在 Doctrine 中如何使用andWhere and orWhere？

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

我该如何在学说中做到这一点？

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

这不正确...应该是:

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

但是我该怎么做呢？在Propel中，函数是getNewCriterion ，在Doctrine中是...？

最佳答案

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