Bluz\Db\Db::fetchColumnGroup PHP Method

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
    public function fetchColumnGroup($sql, $params = [])
    {
        $stmt = $this->prepare($sql, $params);
        $result = $stmt->fetchAll(\PDO::FETCH_COLUMN | \PDO::FETCH_GROUP);
        $this->ok();
        return $result;
    }

Usage Example

Esempio n. 1
0
 /**
  * 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);
 }