//---------------------------TeamsCompeteList---------------------------------
$team = $client->TeamsCompeteList(array());
$teamresult = $team->TeamsCompeteListResult->tTeamCompete;
foreach ($teamresult as $k => $v) {
    $arr = $v->CoachInfo;
    $x = $arr->TeamInfo;
    $sql = "insert into team(team_id,team_name,Country_flag,Country_flag_Large,wikipedia_URL,coach,competed_count,won_count) values({$x->iId},'{$x->sName}','{$x->sCountryFlag}','{$x->sCountryFlagLarge}','{$x->sWikipediaURL}','{$arr->sName}',{$v->iCompeted},{$v->iWon})";
    if (!mysqli_query($con, $sql)) {
        echo mysqli_error($con);
        die(mysqli_error($con));
    }
}
//---------------------------GroupCompetitors-----------------------------------
$array = array("A", "B", "C", "D", "E", "F", "G", "H");
foreach ($array as $i => $value) {
    $result = $client->GroupCompetitors(array("sPoule" => "{$value}"));
    $GroupTeamsA = $result->GroupCompetitorsResult->tTeamInfo;
    foreach ($GroupTeamsA as $k => $v) {
        $result = $client->FullTeamInfo(array("sTeamName" => $v->sName));
        $team = $result->FullTeamInfoResult;
        $sql = "UPDATE team set sCode='{$value}' where team_id={$v->iId}";
        $result = mysqli_query($con, $sql);
        $sql = "UPDATE team set group_description='group {$value}' where team_id={$v->iId} ";
        $result = mysqli_query($con, $sql);
        $players = $team->sGoalKeepers->string;
        foreach ($players as $n => $m) {
            $sql = "UPDATE player SET team_id ={$v->iId} where player_name='{$m}'";
            mysqli_query($con, $sql);
        }
        $players = $team->sDefenders->string;
        foreach ($players as $n => $m) {