public function selectAll() { $items = array(); $sql = "SELECT * FROM users"; foreach ($this->pdo->query($sql, PDO::FETCH_ASSOC) as $row) { $items[] = $this->createUser($row); } return $items; }
public function selectAll() { $items = array(); $sql = "SELECT \r\n\t\t\t\tR.*, \r\n\t\t\t\tFORMAT(AVG(ratings.rating),1) as rating, \r\n\t\t\t\tCOUNT(ratings.id) as rating_count,\r\n\t\t\t\t(\r\n\t\t\t\t\tSELECT GROUP_CONCAT(tid) as types FROM restaurantstypes X, types T\r\n\t\t\t\t\tWHERE X.rid = R.id\r\n\t\t\t\t\tAND X.tid = T.id\r\n\t\t\t\t\tGROUP BY X.rid\r\n\t\t\t\t) as types\r\n\t\t\t\tFROM \r\n\t\t\t\trestaurants R\r\n\t\t\t\tLEFT JOIN ratings \r\n\t\t\t\tON R.id = ratings.restaurant_id\r\n\t\t\t\tGROUP BY R.id"; foreach ($this->pdo->query($sql, PDO::FETCH_ASSOC) as $row) { $items[] = $this->createRestaurant($row); } return $items; }