PHP competition::selectByName Examples

Example #1

File: read-matches.php Project: errorcodexero/scouting

<?php

// read-matches.php reads all the matches for the competition identified
// by $name below.
set_include_path("../src/");
require_once 'lib/db.php';
require_once 'lib/team.php';
require_once 'lib/match.php';
require_once 'lib/alliance.php';
require_once 'lib/competition.php';
function reportMatches($matches)
{
    foreach ($matches as $match) {
        print "CompetitionID = {$match->CompetitionID}\n";
        $red = $match->RedAlliance;
        $blue = $match->BlueAlliance;
        printf("{$match->Time}, {$match->Number}, {$red->TeamOne}, {$red->TeamTwo}, {$red->TeamThree}, " . "{$blue->TeamOne}, {$blue->TeamTwo}, {$blue->TeamThree}, {$red->Points}, {$blue->Points}\n");
    }
}
//---------------------------------------------------------------------------//
$name = "Oregon City District";
$con = DB::connect();
$comp = competition::selectByName($con, $name);
if (!$comp) {
    die("Competition \"{$name}\" not found.");
}
printf("Competition {$name} ID=%s\n", $comp->ID);
$matches = $comp->selectMatches($con);
reportMatches($matches);