//------------------------AllDefenders------------------------------------ $result = $client->AllDefenders(array("sCountryName" => "")); $Alldefenders = $result->AllDefendersResult->string; foreach ($Alldefenders as $k => $v) { $sql = "UPDATE player SET position='defender'WHERE player_name='{$v}'"; mysqli_query($con, $sql); } //------------------------AllGoalKeepers------------------------------------ $result = $client->AllGoalKeepers(array("sCountryName" => "")); $Allgoalk = $result->AllGoalKeepersResult->string; foreach ($Allgoalk as $k => $v) { $sql = "UPDATE player SET position='goal_keeper'WHERE player_name='{$v}'"; mysqli_query($con, $sql); } //------------------------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;