本文整理匯總了PHP中Propel\Runtime\ActiveQuery\ModelCriteria::_or方法的典型用法代碼示例。如果您正苦於以下問題:PHP ModelCriteria::_or方法的具體用法?PHP ModelCriteria::_or怎麽用?PHP ModelCriteria::_or使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Propel\Runtime\ActiveQuery\ModelCriteria
的用法示例。
在下文中一共展示了ModelCriteria::_or方法的3個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: addStandardI18nSearch
/**
* @param ModelCriteria $search
* @param $searchTerm
* @param $searchCriteria
*/
protected function addStandardI18nSearch(&$search, $searchTerm, $searchCriteria)
{
foreach (self::$standardI18nSearchFields as $index => $searchInElement) {
if ($index > 0) {
$search->_or();
}
$this->addSearchInI18nColumn($search, strtoupper($searchInElement), $searchCriteria, $searchTerm);
}
}
示例2: testOrWhereConditions
public function testOrWhereConditions()
{
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c->where('Propel\\Tests\\Bookstore\\Book.Id = ?', 12);
$c->condition('cond1', 'Propel\\Tests\\Bookstore\\Book.Title <> ?', 'foo');
$c->condition('cond2', 'Propel\\Tests\\Bookstore\\Book.Title like ?', '%bar%');
$c->_or()->where(array('cond1', 'cond2'));
$sql = $this->getSql("SELECT FROM book WHERE (book.id = :p1 OR (book.title <> :p2 AND book.title like :p3))");
$params = array(array('table' => 'book', 'column' => 'id', 'value' => 12), array('table' => 'book', 'column' => 'title', 'value' => 'foo'), array('table' => 'book', 'column' => 'title', 'value' => '%bar%'));
$this->assertCriteriaTranslation($c, $sql, $params, 'orWhere() accepts an array of named conditions');
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c->where('Propel\\Tests\\Bookstore\\Book.Id = ?', 12);
$c->condition('cond1', 'Propel\\Tests\\Bookstore\\Book.Title <> ?', 'foo');
$c->condition('cond2', 'Propel\\Tests\\Bookstore\\Book.Title like ?', '%bar%');
$c->_or()->where(array('cond1', 'cond2'), Criteria::LOGICAL_OR);
$sql = $this->getSql("SELECT FROM book WHERE (book.id = :p1 OR (book.title <> :p2 OR book.title like :p3))");
$this->assertCriteriaTranslation($c, $sql, $params, 'orWhere() accepts an array of named conditions with operator');
}
示例3: testOrWhereConditions
public function testOrWhereConditions()
{
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c->where('Propel\\Tests\\Bookstore\\Book.Id = ?', 12);
$c->condition('cond1', 'Propel\\Tests\\Bookstore\\Book.Title <> ?', 'foo');
$c->condition('cond2', 'Propel\\Tests\\Bookstore\\Book.Title like ?', '%bar%');
$c->_or()->where(array('cond1', 'cond2'));
if (in_array($this->getDriver(), array('mysql'))) {
$sql = "SELECT FROM `book` WHERE (book.ID = :p1 OR (book.TITLE <> :p2 AND book.TITLE like :p3))";
} else {
$sql = "SELECT FROM book WHERE (book.ID = :p1 OR (book.TITLE <> :p2 AND book.TITLE like :p3))";
}
$params = array(array('table' => 'book', 'column' => 'ID', 'value' => 12), array('table' => 'book', 'column' => 'TITLE', 'value' => 'foo'), array('table' => 'book', 'column' => 'TITLE', 'value' => '%bar%'));
$this->assertCriteriaTranslation($c, $sql, $params, 'orWhere() accepts an array of named conditions');
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c->where('Propel\\Tests\\Bookstore\\Book.Id = ?', 12);
$c->condition('cond1', 'Propel\\Tests\\Bookstore\\Book.Title <> ?', 'foo');
$c->condition('cond2', 'Propel\\Tests\\Bookstore\\Book.Title like ?', '%bar%');
$c->_or()->where(array('cond1', 'cond2'), Criteria::LOGICAL_OR);
if (in_array($this->getDriver(), array('mysql'))) {
$sql = "SELECT FROM `book` WHERE (book.ID = :p1 OR (book.TITLE <> :p2 OR book.TITLE like :p3))";
} else {
$sql = "SELECT FROM book WHERE (book.ID = :p1 OR (book.TITLE <> :p2 OR book.TITLE like :p3))";
}
$this->assertCriteriaTranslation($c, $sql, $params, 'orWhere() accepts an array of named conditions with operator');
}