Ejemplo n.º 1
0
<?php

include_once 'database/DatabaseBroker.php';
$db = new DatabaseBroker();
$db->openConnection();
$players = $db->getPlayers(1);
$db->closeConnection();
foreach ($players as $player) {
    echo $player . '<br>';
}
Ejemplo n.º 2
0
include_once 'database/DatabaseBroker.php';
if (isset($_GET['function'])) {
    $db = new DatabaseBroker();
    $response = new Response();
    try {
        $db->openConnection();
        switch ($_GET['function']) {
            case 'getClubs':
                // get clubs list from database
                $clubs = $db->getClubs();
                $response->setValue($clubs);
                break;
            case 'getPlayers':
                // get players list from database
                $clubId = $_GET['clubId'];
                $players = $db->getPlayers($clubId);
                $response->setSuccesfull(true);
                $response->setValue($players);
                break;
            case 'getPlayerStatistics':
                // get statistics for the of the single player
                $playerId = $_GET['playerId'];
                $stat = $db->getStatisticsByPlayerId($playerId);
                $response->setSuccesfull(true);
                $response->setValue($stat);
                break;
            case 'getAllPlayersStatistics':
                $statistics = $db->getStatisticsByClubId($_GET['clubId']);
                $response->setSuccesfull(true);
                $response->setValue($statistics);
                break;