$t_id = $row["team_id"];
$gameid = "select game_id from game where play_date='{$v->dGame}' AND team1_id={$t_id}";
$gameID = $con->query($gameid);
if ($gameID->num_rows > 0) {
while ($row1 = $gameID->fetch_assoc()) {
$id = $row1["game_id"];
$cardId = $k + 1;
$sql = "update card SET game_id = {$id} WHERE card_id='{$cardId}'";
mysqli_query($con, $sql);
}
}
}
}
}
//---------------------------GoalsScored----------------------------------
$result = $client->GoalsScored(array("iGameId" => ""));
$goals = $result->GoalsScoredResult->tGoal;
foreach ($goals as $k => $v) {
$sql = "insert into goal (goal_id,iminutes) value({$k}+1,{$v->iMinute})";
mysqli_query($con, $sql);
$playerid = "select player_id from player where player_name='{$v->sPlayerName}'";
$playerID = $con->query($playerid);
if ($playerID->num_rows > 0) {
while ($row = $playerID->fetch_assoc()) {
$id = $row["player_id"];
$goalId = $k + 1;
$sql = "update goal SET player_id = {$id} WHERE goal_id='{$goalId}'";
mysqli_query($con, $sql);
}
}
$teamid = "select team_id from team where team_name='{$v->sTeamName}'";
