//------------------------AllForwards------------------------------------ $result = $client->AllForwards(array("sCountryName" => "")); $AllForwards = $result->AllForwardsResult->string; foreach ($AllForwards as $k => $v) { $sql = "UPDATE player SET position='forward'WHERE player_name='{$v}'"; mysqli_query($con, $sql); } //------------------------AllMidFields------------------------------------ $result = $client->AllMidFields(array("sCountryName" => "")); $AllMidFields = $result->AllMidFieldsResult->string; foreach ($AllMidFields as $k => $v) { $sql = "UPDATE player SET position='mid_field'WHERE player_name='{$v}'"; mysqli_query($con, $sql); } //---------------------------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;