<?php

require '../database.php';

function getTeams() {

    global $db;

    $query = "SELECT * FROM TEAMS";

    $statement = $db->prepare($query);

    try {
         $query->execute();
    } catch (PDOException $ex) {

    }

    $teams = $statement->fetchAll();
    $statement->closeCursor();

    return $teams;
}

function getTeamByID($teamId) {
    global $db;
    $query = "SELECT teams.name,results.homeGoal,results.awayGoal FROM TEAMs,results WHERE teams.id=$teamId AND homeTeam=$teamId;";

    $statement = $db->prepare($query);

    try {
        $query->execute();
    } catch (PDOException $ex) {

    }

    $team = $statement->fetchAll();
    $statement->closeCursor();

    return $team;
}

function get2Teams($team1, $team2) {
    global $db;
    $query = "SELECT * FROM results where (awayTeam=$team1 or homeTeam=$team1) and (awayTeam=$team2 or homeTeam=$team2);";

    $statement = $db->prepare($query);

    try {
        $statement->execute();
    } catch (PDOException $ex) {

    }

    $teamsVs = $statement->fetchAll();
    $statement->closeCursor();

    return $teamsVs;
}

ini_set("soap.wsdl_cache_enabled", "0");
$server = new SoapServer("ca1.wsdl");
$server->addFunction("getTeams");
$server->addFunction("getTeamByID");
$server->addFunction("get2Teams");
$server->handle();