fetchGroup() public method

Group by first column $db->fetchGroup("SELECT ip, COUNT(id) FROM users GROUP BY ip", []);
public fetchGroup ( string $sql, array $params = [], mixed $object = null ) : array
$sql string SQL query with placeholders "SELECT ip, id FROM users"
$params array params for query placeholders (optional)
$object mixed
return array
Db Class Documentation
Esempio n. 1
0
 /**
  * fetchGroup
  */
 public function testFetchGroup()
 {
     $result = $this->db->fetchGroup("SELECT status, id, name FROM test");
     $this->assertArrayHasKey('active', $result);
     $this->assertArrayHasKey('disable', $result);
     $this->assertArrayHasKey('delete', $result);
 }