Bluz\Db\Db::fetchGroup PHP Method

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
    public function fetchGroup($sql, $params = [], $object = null)
    {
        $stmt = $this->prepare($sql, $params);
        if ($object) {
            $result = $stmt->fetchAll(\PDO::FETCH_CLASS | \PDO::FETCH_GROUP, $object);
        } else {
            $result = $stmt->fetchAll(\PDO::FETCH_ASSOC | \PDO::FETCH_GROUP);
        }
        $this->ok();
        return $result;
    }

Usage Example

コード例 #1
0
ファイル: DbTest.php プロジェクト: dezvell/mm.local
 /**
  * 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);
 }