public function getPublicGames()
{
$sql = goPublicGame::getSql();
$link = @mysqli_connect(Config::getDatabaseServer(), Config::getDatabaseUser(), Config::getDatabasePassword(), Config::getDatabase());
if (!$link) {
mydie("Error connecting to Database");
}
if (Config::getDebug()) {
$this->LOG->log("{$sql}", PEAR_LOG_INFO);
}
$cursor = @mysqli_query($link, $sql);
if (!$cursor) {
$this->mydie(mysqli_error($link), $link);
}
$record = 0;
while ($row = @mysqli_fetch_assoc($cursor)) {
$game = new goPublicgame();
//$game->setGameID($row['gameID']);
$game->setDescription($row['description']);
$game->setTitle($row['title']);
$game->setEventName($row['eventName']);
$game->setEventDate($row['eventDate']);
$game->setSportID($row['sport']);
$game->setSportName($row['sportName']);
$game->setLeagueName($row['leagueName']);
$game->setFavorite($row['favorite']);
$game->setTypeID($row['type']);
$game->setTypeName($row['typeName']);
/*** temp explicit treatment as array storage***/
$this->publicGames[$record] = $game;
$record++;
/*** end temp ***/
}
//while
$link->close();
}
