//---------------------------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) {