/** * Created by PhpStorm. * User: petar * Date: 24.3.2016 * Time: 12:42 */ function get_matches($url, $cmp_id, $cmp_name, $conn, $source) { $curr_url = $url; $xmlMatchData = file_get_contents($curr_url); $curr_data = json_decode($xmlMatchData); $curr_match_data = array(); $replace_strings = array(" ", "(", ")", "."); $new_strings = array("_", "", "", ""); foreach ($curr_data->Matches as $match) { $tmp_data = array(); $home_team_name = $match->HomeCompetitorName; $home_team_id = strtolower(str_replace($replace_strings, $new_strings, $home_team_name)); $visitor_team_name = $match->AwayCompetitorName; $visitor_team_id = strtolower(str_replace($replace_strings, $new_strings, $visitor_team_name)); $match_code = $match->Id; $match_start_time = $match->MatchStartDate; $tmp_data['time'] = $match_start_time; $tmp_data['code'] = $match_code; $tmp_data['home_team'] = $home_team_name; $tmp_data['home_team_id'] = $home_team_id; $tmp_data['visitor_team'] = $visitor_team_name; $tmp_data['visitor_team_id'] = $visitor_team_id; $tmp_data['cmp_id'] = $cmp_id; $tmp_data['cmp_name'] = $cmp_name; $curr_match_data[] = $tmp_data; } foreach ($curr_match_data as $m) { print_r($m); echo "<br />"; } $connUrl = join(DIRECTORY_SEPARATOR, array('..', 'conn', 'mysqlAdminPDO.php')); include $connUrl; foreach ($curr_match_data as $d) { $homeTeam = $d['home_team']; $homeTeamId = $d['home_team_id']; $visitorTeam = $d['visitor_team']; $visitorTeamId = $d['visitor_team_id']; $matchTime = $d['time']; $cmpName = $cmp_name; $cmpId = $cmp_id; $matchName = $d['home_team'] . " - " . $d['visitor_team']; $matchId = $d['code']; $sql = 'INSERT INTO ulaz_new (starttime,dom, dom_id, gost, gost_id, liga, liga_id, source, utakmica, utk_id) VALUES(:srcMatchTime,:srcHomeTeam, :srcHomeTeamId,:srcVisitorTeam, :srcVisitorTeamId, :srcLiga, :srcLigaId, :srcSourceId, :srcMatchName, :srcMatchId);'; $parameters = array('srcHomeTeam' => $homeTeam, 'srcMatchTime' => $matchTime, 'srcHomeTeamId' => $homeTeamId, 'srcVisitorTeam' => $visitorTeam, 'srcVisitorTeamId' => $visitorTeamId, 'srcLiga' => $cmpName, 'srcLigaId' => $cmpId, 'srcSourceId' => $source, 'srcMatchName' => $matchName, 'srcMatchId' => $matchId); $prepare = $conn->prepare($sql); $prepare->execute($parameters); get_match_odds($matchId, $source); } $conn = null; }
$betGame = $d['bet_game']; $betSubgame = $d['bet_subgame']; $OddValue = $d['odd_value']; $code = $d['code']; fwrite($tmpOdds, $code . ";" . $OddValue . ";;" . $betSubgame . ";" . $betGame . ";" . $source . "\n"); } fclose($tmpOdds); $db = mysqli_init(); $db->real_connect("192.168.180.124", "proske", "proske1989", "Uporedna_new"); $db->query("LOAD DATA LOCAL INFILE 'Odds.txt' INTO TABLE ulaz_odds FIELDS TERMINATED BY ';' SET timestamp = CURRENT_TIMESTAMP ;"); // $url = dirname(__DIR__); // echo $url; // $tmpOdds = fopen("Odds.txt", "w"); // include('Odds.txt'); // $connUrl = join(DIRECTORY_SEPARATOR, array('..','conn', 'mysqlAdminPDO.php')); // include($connUrl); // $sql ="LOAD DATA LOCAL INFILE 'Odds.txt' // INTO TABLE ulaz_odds // FIELDS TERMINATED BY ';' // OPTIONALLY ENCLOSED BY '\"' // LINES TERMINATED BY '\\n'"; // $prepare = $conn->prepare($sql); // $prepare->execute(); // // // $conn = null; // echo $sql; // exec("mysql -u proske -p proske1989 -e \"USE Uporedna_new;TRUNCATE ulaz_odds;LOAD DATA INFILE 'Odds.txt' INTO TABLE ulaz_odds;\"; "); } get_match_odds($code, $source);
$trncSql = 'truncate ulaz_new; truncate ulaz_odds;'; $delete = $conn->prepare($trncSql); $delete->execute(); $conn = null; echo "Skidam mečeve <br>"; $curr_cmp_id = 77; $curr_cmp_name = 'Argentina 1'; $curr_url = "https://www.soccerbet.rs/api/Match/GetFilteredScheduledMatches?ItemsPerPage=50&CurrentPage=1&SortOrderFilterId=1&TimeFilterId=7&CompetitionIds={$curr_cmp_id}"; get_matches($curr_url, $curr_cmp_id, $curr_cmp_name); $numMatches = sizeof($curr_match_data); echo "Skinuo sam {$numMatches} mečeva <br>"; echo "Skidam kvote <br>"; foreach ($curr_match_data as $m) { // print_r($m); $matchId = $m['code']; get_match_odds($matchId); // echo "<br />"; } $tmpOdds = fopen("Odds.txt", "w"); foreach ($curr_match_odds as $d) { $betGame = $d['bet_game']; $betSubgame = $d['bet_subgame']; $OddValue = $d['odd_value']; $code = $d['code']; fwrite($tmpOdds, $code . ";" . $OddValue . ";;" . $betSubgame . ";" . $betGame . ";" . $source . "\n"); } fclose($tmpOdds); //Upis mečeva u bazu $tmpMatches = fopen("Matches.txt", "w"); foreach ($curr_match_data as $d) { $homeTeam = $d['home_team'];