本文整理汇总了PHP中Select::getQuery方法的典型用法代码示例。如果您正苦于以下问题:PHP Select::getQuery方法的具体用法?PHP Select::getQuery怎么用?PHP Select::getQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Select
的用法示例。
在下文中一共展示了Select::getQuery方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: testConstructorTableNameSelect
/**
* @covers Select::newSelect
* @uses Select::__construct
* @uses Select::getQuery
*/
public function testConstructorTableNameSelect()
{
$select = new Select('TableName');
$assertSql = 'SELECT * FROM TableName';
// Assert
$this->assertEquals($select->getQuery(), $assertSql);
}
示例2: getQuery
/**
* (non-PHPdoc)
* @see \Koldy\Db\Select::getQuery()
*/
protected function getQuery()
{
if ($this->searchTerm !== null) {
// there is search term set, so we'll need to include this to where statements
// but, there might be already some where statements in the query, so we'll create
// new Where instance and we'll add that Where block with AND operator
$where = Where::init();
if ($this->searchFields !== null) {
foreach ($this->searchFields as $field) {
$where->orWhereLike($field, "%{$this->searchTerm}%");
}
} else {
foreach ($this->getFields() as $field) {
$where->orWhereLike($field['name'], "%{$this->searchTerm}%");
}
}
$this->where($where);
}
return parent::getQuery();
}