PHP pew\db Database::group_by Examples

Programming Language: PHP

Namespace/Package Name: pew\db

Class/Type: Database

Method/Function: group_by

Examples at hotexamples.com: 1

PHP pew\db Database::group_by - 1 examples found. These are the top rated real world PHP examples of pew\db\Database::group_by extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

query(2)

cell(1)

delete(1)

disconnect(1)

from(1)

get_cols(1)

get_pk(1)

group_by(1)

order_by(1)

pdo(1)

select(1)

set(1)

single(1)

table_exists(1)

values(1)

where(1)

Example #1

Show file

File: DatabaseTest.php Project: ifcanduela/pew

 public function testGroupAndHaving()
 {
     $db = new Database($this->pdo);
     $result = $db->group_by('artist_id')->fields('COUNT(*) as album_count, artists.name')->where(['artists.id = albums.artist_id'])->order_by('artists.name')->select('albums, artists');
     $this->assertEquals(3, count($result));
     $this->assertEquals(3, $result[0]['album_count']);
     $this->assertEquals(2, $result[1]['album_count']);
     $this->assertEquals(1, $result[2]['album_count']);
 }