public function getAll()
    {
        $query = 'SELECT * FROM `project` ORDER BY `title` ASC';
        $stmt = Database::getConnection('read')->prepare($query);

        if ($stmt->execute()) {
            $res = $stmt->fetchAll(\PDO::FETCH_ASSOC);

            $map = function ($item) {
                return new Project($item);
            };
            $rtn = array_map($map, $res);

            $count = count($rtn);


            return array('items' => $rtn, 'count' => $count);
        } else {
            return array('items' => array(), 'count' => 0);
        }
    }
public function getAll()
    {
        $query = 'SELECT * FROM `project` ORDER BY `title` ASC';
        $stmt = Database::getConnection('read')->prepare($query);

        if ($stmt->execute()) {
            $res = $stmt->fetchAll(\PDO::FETCH_ASSOC);

            $map = function ($item) {
                return new Project($item);
            };
            $rtn = array_map($map, $res);

            $count = count($rtn);


            return array('items' => $rtn, 'count' => $count);
        } else {
            return array('items' => array(), 'count' => 0);
        }
    }
public function getAll ( ) { $ query = 'SELECT * FROM `project` ORDER BY `title` ASC' ; $ stmt = Database :: getConnection ( 'read' ) -> prepare ( $ query ) ; if ( $ stmt -> execute ( ) ) { $ res = $ stmt -> fetchAll ( \ PDO :: FETCH_ASSOC ) ; $ map = function ( $ item ) { return new Project ( $ item ) ; } ; $ rtn = array_map ( $ map , $ res ) ; $ count = count ( $ rtn ) ; return array ( 'items' => $ rtn , 'count' => $ count ) ; } else { return array ( 'items' => array ( ) , 'count' => 0 ) ; } }
Get a list of all projects, ordered by their title.
@return array
Get a list of all projects ordered by their title .