コード例 #1
0
 public function getFavoriteGamesiteForLoggedInUser($user)
 {
     $favoriteSite = '';
     $databaseInfo = new DatabaseInfoModel();
     $con = new mysqli($databaseInfo->getHost(), $databaseInfo->getUser(), $databaseInfo->getPassword(), $databaseInfo->getDatabaseName(), $databaseInfo->getPort(), $databaseInfo->getSocket()) or die('Could not connect to the database server' . mysqli_connect_error());
     if ($stmt = $con->prepare($databaseInfo->getFavoriteGamesiteStoredProcedure() . '("' . $user . '")')) {
         $stmt->execute();
         $stmt->bind_result($favorite);
         while ($stmt->fetch()) {
             $favoriteSite = $favorite;
         }
         $stmt->close();
     }
     $con->close();
     return $favoriteSite;
 }
コード例 #2
0
 private function connectToServerAndFetchRSS()
 {
     $databaseInfo = new DatabaseInfoModel();
     $con = new mysqli($databaseInfo->getHost(), $databaseInfo->getUser(), $databaseInfo->getPassword(), $databaseInfo->getDatabaseName(), $databaseInfo->getPort(), $databaseInfo->getSocket()) or die('Could not connect to the database server' . mysqli_connect_error());
     if ($stmt = $con->prepare($databaseInfo->getRSSFeedsStoredProcedure())) {
         $stmt->execute();
         $stmt->bind_result($siteName, $rssLink);
         while ($stmt->fetch()) {
             // Save all DB-content to a "cache-array".
             $rss = new RssModel($siteName, $rssLink);
             $this->rssCache[] = $rss;
         }
         $stmt->close();
     }
     $con->close();
 }