mysqli_query($con, $sql); } $players = $team->sMidFields->string; foreach ($players as $n => $m) { $sql = "UPDATE player SET team_id ={$v->iId} where player_name='{$m}'"; mysqli_query($con, $sql); } $players = $team->sForwards->string; foreach ($players as $n => $m) { $sql = "UPDATE player SET team_id ={$v->iId} where player_name='{$m}'"; mysqli_query($con, $sql); } } } //---------------------------AllGames----------------------------------- $result = $client->AllGames(array()); $games = $result->AllGamesResult->tGameInfo; foreach ($games as $k => $v) { $StadiumName = $v->StadiumInfo->sStadiumName; $team1 = $v->Team1->iId; $team2 = $v->Team2->iId; $sql = "insert into game (game_id,game_description,play_date,play_time,result,score,is_champion,iUTC_offset,game_name,team1_id ,team2_id) values\n ({$v->iId},'{$v->sDescription}','{$v->dPlayDate}','{$v->tPlayTime}','{$v->sResult}','{$v->sScore}',false,{$v->iUTCOffset},'{$StadiumName}',{$team1},{$team2})"; if (!mysqli_query($con, $sql)) { echo mysqli_error($con); die(mysqli_error($con)); } } //---------------------------AllCards----------------------------------- $result = $client->AllCards(array()); $cards = $result->AllCardsResult->tCardInfo; foreach ($cards as $k => $v) {