Esempio n. 1
0
Database::clearDB();
$db = Database::getDB('ptest');
$tournaments = TournamentsDB::getTournamentsBy('telephone', '21052348234');
if (empty($tournaments)) {
    echo "No Tournament with this telephone number";
} else {
    echo "The value of Tournament with a specified telephone number is:<br>{$tournaments}<br>";
}
?>

<h2>It should get a tournament name by tournament id</h2>
<?php 
DBMaker::create('ptest');
Database::clearDB();
$db = Database::getDB('ptest');
$tournamentNames = TournamentsDB::getTournamentValuesBy('name', 'tournamentID', 1);
print_r($tournamentNames);
?>
<h2>It should allow update of the tournament name</h2>
<?php 
DBMaker::create('ptest');
Database::clearDB();
$db = Database::getDB('ptest');
$tournaments = TournamentsDB::getTournamentsBy('tournamentID', 1);
$tournament = $tournaments[0];
echo "<br>Before update: {$tournament} <br>";
$parms = $tournament->getParameters();
$parms['name'] = 'Champ1';
$newTournament = new Tournament($parms);
$newTournament->setTournamentID(1);
$tournament = TournamentsDB::updateTournament($newTournament);