public function insertReview($restaurant_id, $user_id, $review) { $sql = "INSERT INTO reviews (restaurant_id, user_id, review) VALUES (:rid, :uid, :review)"; $q = $this->pdo->prepare($sql); if ($q->execute(array(':rid' => $restaurant_id, ':uid' => $user_id, ':review' => $review))) { return $this->selectFromId($this->pdo->lastInsertId()); } else { return 0; } }
public function selectFromId($id) { $stmt = $this->pdo->prepare("SELECT id, firstName, lastName, email, apikey FROM users WHERE id=?"); $stmt->execute(array($id)); $r = $stmt->fetch(PDO::FETCH_ASSOC); if ($r) { return $this->createUser($r); } else { return false; } }
public static function getInstance() { if (self::$instance == null) { self::$instance = new FoodoPDO(); } return self::$instance; }
public function selectFromId($id) { $stmt = $this->pdo->prepare("\r\n\t\t\t\tSELECT \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\tWHERE R.id=?\r\n\t\t\t\tGROUP BY R.id"); $stmt->execute(array($id)); $r = $stmt->fetch(PDO::FETCH_ASSOC); if ($r) { return $this->createRestaurant($r); } else { return false; } }