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;
}
