Esempi in PHP per Bluz\Db Db::fetchColumnGroup

fetchColumnGroup() public method

Group by first column

public fetchColumnGroup ( string $sql, array $params = [] ) : array
$sql	string	SQL query with placeholders "SELECT ip, id FROM users"
$params	array	params for query placeholders (optional)
return	array

Esempio n. 1

File: DbTest.php Progetto: dezvell/mm.local

 /**
  * fetchColumnGroup
  */
 public function testFetchColumnGroup()
 {
     $result = $this->db->fetchColumnGroup("SELECT status, COUNT(id) FROM test GROUP BY status");
     $this->assertArrayHasKey('active', $result);
     $this->assertArrayHasKey('disable', $result);
     $this->assertArrayHasKey('delete', $result);
 }