PHP r8 Query::select Examples

Programming Language: PHP

Namespace/Package Name: r8

Class/Type: Query

Method/Function: select

Examples at hotexamples.com: 2

PHP r8 Query::select - 2 examples found. These are the top rated real world PHP examples of r8\Query::select extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

parseSQLAlias(3)

parseSQLName(3)

select(2)

Example #1

Show file

File: Query.php Project: Nycto/Round-Eights

 public function testSelect()
 {
     $this->assertThat(\r8\Query::select(), $this->isInstanceOf('\\r8\\Query\\Select'));
 }

Example #2

Show file

File: Select.php Project: Nycto/Round-Eights

 public function testFluent()
 {
     $select = \r8\Query::select()->distinct()->fields("fld1", "db.fld2 AS info")->from("db.tableName")->where("`fld1` = 5")->orderBy("sortField DESC")->groupBy("id")->having("COUNT(*) = 2")->limit(20, 100);
     $link = new \r8\DB\Link(new \r8\DB\BlackHole\Link());
     $this->assertSame("SELECT DISTINCT `fld1`, db.`fld2` AS `info`\n" . "FROM db.`tableName`\n" . "WHERE `fld1` = 5\n" . "ORDER BY `sortField` DESC\n" . "GROUP BY id\n" . "HAVING COUNT(*) = 2\n" . "LIMIT 100, 20", $select->toSQL($link));
 }