Пример #1
0
 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;
     }
 }
Пример #2
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;
     }
 }
Пример #3
0
 public static function getInstance()
 {
     if (self::$instance == null) {
         self::$instance = new FoodoPDO();
     }
     return self::$instance;
 }
Пример #4
0
 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;
     }
 }