本文整理匯總了PHP中JDatabaseQuery::union方法的典型用法代碼示例。如果您正苦於以下問題：PHP JDatabaseQuery::union方法的具體用法？PHP JDatabaseQuery::union怎麽用？PHP JDatabaseQuery::union使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類JDatabaseQuery的用法示例。
在下文中一共展示了JDatabaseQuery::union方法的3個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: testUnionTwo
/**
* Tests the JDatabaseQuery::union method.
*
* @return void
*
* @since 12.1
*/
public function testUnionTwo()
{
TestReflection::setValue($this->_instance, 'union', null);
$this->_instance->union('SELECT name FROM foo');
$this->_instance->union('SELECT name FROM bar');
$teststring = (string) TestReflection::getValue($this->_instance, 'union');
$this->assertThat($teststring, $this->equalTo(PHP_EOL . "UNION (SELECT name FROM foo)" . PHP_EOL . "UNION (SELECT name FROM bar)"), 'Tests rendered query with two unions sequentially.');
}示例2: testUnionTwo
/**
* Tests the JDatabaseQuery::union method.
*
* @return void
*
* @covers JDatabaseQuery::union
* @since 12.1
*/
public function testUnionTwo()
{
$this->_instance->union = null;
$this->_instance->union('SELECT name FROM foo');
$this->_instance->union('SELECT name FROM bar');
$teststring = (string) $this->_instance->union;
$this->assertThat($teststring, $this->equalTo(PHP_EOL . "UNION (SELECT name FROM foo)" . PHP_EOL . "UNION (SELECT name FROM bar)"), 'Tests rendered query with two unions sequentially.');
}示例3: testUnionObjectsArray
/**
* Tests the JDatabaseQuery::union method when passed two query objects in an array.
*
* @return void
*
* @since 12.??
*/
public function testUnionObjectsArray()
{
$this->_instance->select('name')->from('foo')->where('a=1');
$q2 = new JDatabaseQueryInspector($this->dbo);
$q2->select('name')->from('bar')->where('b=2');
$q3 = new JDatabaseQueryInspector($this->dbo);
$q3->select('name')->from('baz')->where('c=3');
TestReflection::setValue($this->_instance, 'union', null);
$this->_instance->union(array($q2, $q3));
$this->assertThat((string) $this->_instance, $this->equalTo(PHP_EOL . "SELECT name" . PHP_EOL . "FROM foo" . PHP_EOL . "WHERE a=1" . PHP_EOL . "UNION (" . PHP_EOL . "SELECT name" . PHP_EOL . "FROM bar" . PHP_EOL . "WHERE b=2)" . PHP_EOL . "UNION (" . PHP_EOL . "SELECT name" . PHP_EOL . "FROM baz" . PHP_EOL . "WHERE c=3)"));
}